How Do I Display a Message

[granny1]

I have a report that allows users to select a parameter from a drop down list.
If there is no data for the specified time frame I need a meesage to appear that displays a message something like "No Data available for the selected Department this reporting period".
I do not want any of the sub-reports etc. to run. Just display the message.
Any help would be greatly appreciated.

 

[Naith]

Insert a Report Header section, and base it on a conditional suppression to the tune of something like:

Not IsNull{CompulsoryField} or
Count(CompulsoryField) = 0

(You might want to check the syntax...)

Place a text field in the section saying what you want.

When there are no records, this section should appear.

Naith