Print a report when no data is returned

[Kate]

I want to still print the report showing that no data was
returned. I have a parameter for the date and when there
is no data, this field does not print on the report. How
do I get it to print anyways.

 

[Wilson]

Several ways to do it.
I like to have a special "No Data" report.
Before sending to print the report count the items to be
included using 'DCount'.
Then if the result of DCount=0 then Print the special "No
Data" Report, if Dcount>0 then print your Report.

 

[Duane Hookom]

You can't get a parameter prompt to display in the report if there are no
records returned. I would recommend using a control on a form for the
criteria. Then you can add a text box to your report header with a control
source of:
=Forms!frmYourForm!txtYourCriteria

 

[Kate]

-----Original Message-----
You can't get a parameter prompt to display in the report if there are no
records returned. I would recommend using a control on a form for the
criteria. Then you can add a text box to your report header with a control
source of:
=Forms!frmYourForm!txtYourCriteria

I want to still print the report showing that no data was
returned. I have a parameter for the date and when there
is no data, this field does not print on the report. How
do I get it to print anyways.

.
Duane, Thank you for your response...it worked like a[/QUOTE]
charm.

 

[Guest]

-----Original Message-----
Several ways to do it.
I like to have a special "No Data" report.
Before sending to print the report count the items to be
included using 'DCount'.
Then if the result of DCount=0 then Print the special "No
Data" Report, if Dcount>0 then print your Report.



.
Thank you for your help