Print a report when no data is returned

  • Thread starter Thread starter Kate
  • Start date Start date
K

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.
 
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.
 
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
 
-----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
Click to expand...
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.
Click to expand...


.
Duane, Thank you for your response...it worked like a[/QUOTE]
charm.
 
-----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
Click to expand...
 
Back
Top