Report preview problem with Add Command datasource

[Grouper1138]

I finally had time to get back on this issue and got the Add Command correct in version 9. I worked out the syntax problems with the parameter fields and then I could finally save the SQL with the report. I made a simple report of the results, but I can't get any data to show up in the print preview. In another report on the same datasource I do get data. This was used to set my parameter defaults so I know the data is there.

Any ideas on why the data might not show up on the preview?

 

[synapsevampire]

In another report on the same datasource I do get data"

If the process and the data source are the same, then the results will be.

I suggest that you're using parameters differently in each.

-k

 

[Grouper1138]

Well, the process is not the same. I'm using the Add Command so that I can specify a union of the detail and detail history files. The other report only looks at the current detail records and doesn't need to use Add Command. Since I need to see both files contents, that's why I started with the Add Command, a different process, so that I could specify the SQL myself, thusly...

SELECT
GL00100.ACTNUMBR_1, GL00100. ACTNUMBR_2, GL00100.ACTNUMBR_3, GL00100.ACTNUMBR_4, GL00100.ACTDESCR, GL20000.JRNENTRY, GL20000.REFRENCE, GL20000.TRXDATE, GL20000.ORMSTRID, GL20000.ORMSTRNM, GL20000.CRDTAMNT, GL20000.DEBITAMT
FROM GL00100
INNER JOIN GL20000
ON GL00100.ACTINDX = GL20000.ACTINDX
WHERE GL00100.ACTNUMBR_4 < '5999' AND
GL00100.ACTNUMBR_4 > '8100' and
GL00100.ACTNUMBR_1 = {?Division} and
GL00100.ACTNUMBR_2 = {?Location} and
GL00100.ACTNUMBR_3 = {?Cost Center} and
GL20000.TRXDATE > {?Begin date} AND
GL20000.TRXDATE < {?Ending date}
UNION ALL
SELECT
GL00100.ACTNUMBR_1, GL00100. ACTNUMBR_2, GL00100.ACTNUMBR_3, GL00100.ACTNUMBR_4, GL00100.ACTDESCR, GL30000.JRNENTRY, GL30000.REFRENCE, GL30000.TRXDATE, GL30000.ORMSTRID, GL30000.ORMSTRNM, GL30000.CRDTAMNT, GL30000.DEBITAMT
FROM GL00100
INNER JOIN GL30000
ON GL00100.ACTINDX = GL30000.ACTINDX
WHERE GL00100.ACTNUMBR_4 < '5999' AND
GL00100.ACTNUMBR_4 > '8100' and
GL00100.ACTNUMBR_1 = {?Division} and
GL00100.ACTNUMBR_2 = {?Location} and
GL00100.ACTNUMBR_3 = {?Cost Center} and
GL30000.TRXDATE > {?Begin date} AND
GL30000.TRXDATE < {?Ending date}

 

[ind123p]

grouper,

Were you able to resolve your issue? I am using CR XI, Access 2000

I am having a similar situation where no data appears in the preview. I have a UNION query with 5 parameters added in the Command window.

The parameters in the Command window do not prompt for values ????

Am I missing something