Hello everyone.

I am creating a few production reports. All goes well as long as there is something to find in the search criteria. If there is no record available, my report shows a blank page in preview mode, but a normal page with no record otherwise.

There is a header with useful information, like how many projects for the months there was.

It's not because there is no record found that the report is no good. I can have a 100% efficiency if there is no trouble found in the search and I need to see that data, print it and send it to my boss.

So how do you people do with that sort of problem? I was thinking about creating a blank record within the table and add to my script something like if Get ( FoundCount ) = 0 show that record... going to try it now but I'm hoping for a better solution.

Thank you for your help

I don't think blank records are a good idea. They are bad data.

I check for get( foundcount ) = 0 and don't print or preview. I usually show a dialog explaining why nothing happened.

If you need to still print a report then create a layout that displays the data just for this case and print it from any record. IOW treat the empty found set as a special case.

The blank record idea worked, but I'm going to try your instead.

Thank you