Search results for query: *

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...

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...

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...

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

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...

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...

I don't get the linking of subreports. I have created 5 subreports and when I click refresh of the main report all 5 report params are shown there. I need to fill-in each one to get the report to look right. Most of the reports can be selected by name but one needs to be selected by number_ID...

I am working on a report that uses a file called userfield.description. It is organized by userfield.row_ID numbers and userfield.fieldposition numbers. By selecting the right userfield.row_id and a range of userfield.fieldpostions, I am able to get the data I need. However, I need to select...