Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can I add a line of text to a blank report

Status
Not open for further replies.

Forest75

Technical User
Apr 13, 2011
8
GB
Hi all,

If my report returns no data in the details section I need to print a line of text in the details sections to say "No Data Found". Is there an easy way of doing this?

Many thanks.
 
Split a report header into two sections

Place your text "No Data Found" in lower section

In section expert of two sections

In upper section

isnull( select a field which is primary to your report)

In lower section

not(isnull( select a field which is primary to your report))

Ian

 
Hi Ian,

Thanks very much, that is excatly what was required.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top