Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. crystalize

    Select dates not working

    The data type is date/time.
  2. crystalize

    Select dates not working

    I am using client supplied data thru odbc in Access 2002 When I write a command it's doesn't select the right dates. In the arhdrh file and the invoice date fields. The command is: Between #1/1/2007# And #12/31/2009# It looks like it returns all the records. The data is from SagePFW and...
  3. crystalize

    Last sales order by ship to

    LB, Thanks for your help. I think I am okay for now.
  4. crystalize

    Last sales order by ship to

    Thanks for explaining the difference between record selection and group selection. I found that helpful. I am begining to understand it, but I think that is where my problem is. I have as record selection: {ARHDRH.Shipdate} = {?Date Range} I have group selection: {ARHDRH.Shipdate} = Maximum...
  5. crystalize

    Last sales order by ship to

    How do I create runnng totals across groups? I am only familiar with creating running totals within groups. When I select 2003 to 2007 the running total shows the correct last ship date. When I select 2003 it show the last ship date being in 2003.
  6. crystalize

    Last sales order by ship to

    This is working well. The situation changed some from when I originally posted here. I found that in the data there are no blank ship to's they default automatically from the customer key if nothing was entered. I had to suppress duplicates. I created a formula called ship dates: formula =...
  7. crystalize

    Last sales order by ship to

    if isnull({table.shiptokey}) then {table.customerkey} else {table.shiptokey} When I create a formula for this I get "a statement is expected here" and it highlights {table.customerkey} Is there something else I need to do?
  8. crystalize

    Last sales order by ship to

    I am trying to create a report that will list the date of the last order placed by a customer, by ship to address. I have 3 columns: Customer Key, Ship To Key, and Ship Date. Sometimes the ship to key will be blank, meaning we need to default to the Customer Key because the ship to is the same...
  9. crystalize

    Number of Cross Tab Columns user defined

    The user is just writing in the checkoff cell. Also, we don't care about a history. Tell me more how creating column headers conditionally would work. I need it to create the number of columns required for this report. Each time the report is ran it will be a different number of columns. I'm...
  10. crystalize

    Number of Cross Tab Columns user defined

    Thanks for your reply. None of the columns are populated. The rows are populated. It's a check list. When the first item in the row is accomplished column 1 get a check mark, when it happens again column2 gets a check mark. Each report has a different number of columns. They are at random...
  11. crystalize

    Number of Cross Tab Columns user defined

    I have created a formula that asks how many columns do you want to see. Next I need to put that formula somewhere into the cross tab so that it will create the number of blank columns I specify. Also I would like it to number the columns across the top. Such as column 1, column 2 etc...
  12. crystalize

    OLE Dd OR NATIVE ORACLE

    How do I tell whether I am using ole db or Oracle Native? Crystal 9 and Oracle 8i.
  13. crystalize

    Record selection formula

    module id tablename row_id userfieldprofile_id tab_id type_cd parent -not used description required datatype fieldposition usereditmask lookupcategory userfieldvalue numberfield stringfield bytefield datefield logicalfield comment_id constraintvalue changeby lastchange type_cat Let me know if...
  14. crystalize

    Record selection formula

    Here are the available field details for userfield file. It stores user field values and other information for user defined fields. I linked (inner join) USERFIELD.ROW_ID to matter.matternumber_id. And I linked (inner join)matterlitigation.matternumber_id to matter.matternumber_id. See...
  15. crystalize

    Record selection formula

    if {USERFIELD.FIELDPOSITION} = 1200 and {USERFIELD.NUMBERFIELD} = 1 then Userfield.fieldposition is the 1200th line (record selection), and userfield.numberfield is the value in that fieldposition. I need to go to that 1200 line and evaluate the value there and print other records based on...
  16. crystalize

    Record selection formula

    I am trying to print certain records based on the value of one line. For example if userfield.fieldposition=1200 and userfield.numberfield= 1 then print certain lines. {USERFIELD.FIELDPOSITION} in [1000.00, 1100.00, 1200.00, 1600.00, 1800.00, 1850.00, 100.00, 2000.00, 2100.00, 2200.00...
  17. crystalize

    Data fields disappear when a new field is added to the report

    The fields have data, they are just not showing when a field from a different file is dragged into the preview screen.
  18. crystalize

    Data fields disappear when a new field is added to the report

    I have added several fields to the report from the invoice.detail file and the data shown when I do a preview. As soon as I add a new field from another file such as matter, the existing data shown in preview disappears. When I undo this insert the data shows again. This is happening on many if...
  19. crystalize

    Record selection

    I have changed my direction some. I want to be able to select records by matter.number. The row.id and the matter.number.id are both number data type. Examples of both would be from 10,019.00 to 16,693.00. I need to select records based on the matter number which is a string, for example...
  20. crystalize

    Linking subreports

    That seems to be working when I use the matter.number for my main record selection. However, in 3 subreports the exact data I need is not showing up. I need to use matter.number.id (which is different from matter.number) on some subreports. Also, I need to use row.id which is linked to...

Part and Inventory Search

Back
Top