To display parameter query criteria on report even for nil results?

[yampeck]

Hi,

Need advise on how to display on my report the criteria that i had specified in the parameter query even if the result is nil.

How can this be done??

Thanks!

 

[llkhoutx]

Store it in the page footer.

 

[yampeck]

Hi,

Thanks for the reply, but storing it in the page footer doesn't seem to work.

What i intend to do is to have a report that shows what i have queried for, even if there is zero results on the parameter query.

Regards.

 

[JoeCruse]

I usually put stuff like that in the header. I do it by using an unbound form as a dialog form to input the query parameters. Have the query parameters reference the specific controls (text box, combo box, etc) on the form to run the query and report. In the report design view, put text boxes for the parameters you want shown in the header (or footer). The record source of these text boxes should reference the names of the controls on the dialog form that you input the parameters in.

 

[llkhoutx]

I often need to force a report row when no data exists, so I create a union query as my report recordsource. The union adding an all blank row. Then the footer appears with no data appearing.

JoeCruse - if no data, no header.

 

[JoeCruse]

Hmmm,

you're right, as far as getting data from the query. You can still have the report print a header (not sure about report header, but I have one that still prints a page header). I have a report that sticks 3 values picked up off the dialog form and puts them in the page header. But these are not the query parameters, so doing this with query parameters might not work after all.