Stupid Question

[Darrick]

I have a report that runs on demand and rarely returns any data. I want to put a formula in the report to display if the query doesn't yield any data. I have seen this done numerous tims however, when the query doesn't return anything none of my sections display, not allowing me to put a formula to display a message.

Any help will be appericated!

Thanks,

Darrick

 

[Madawc]

Create a section that says "No details found", in the report footer.
Right-click on the section and choose Format Section. Then choose the formula icon (x+2 and a pencil) for suppression.
Test not isnull({your.field})
The section will appear when there were no records and otherwise be suppressed.

Madawc Williams (East Anglia, UK)

 

[SROY0270]

I am assuming in your report you suppress the sections when there is no detail. You need to add another section in your report, probably a second report footer, and suppress that section the opposite way you have the other sections suppressed. In your new section put in a text object that states there are no records to display. I hope this works.

 

[lbass]

You can use Madawc's suggestion, but I think you also need to go to file->report options->and make sure you DO NOT have "suppress printing if no records" checked.

-LB