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!

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

No Data

Status
Not open for further replies.
Barrow66

Barrow66

Programmer
Sep 3, 2002
37
US
I want to print NO DATA on a report if zero record is returned.Can someone please help? I tried using running total formula if 0 then suppress GF1a and placed NO DATA in GF1b to print when record count is zero.Any other suggestions.
 
Sort by date Sort by votes
Insert a new Report Header section, and conditionally suppress it on Count({CompulsoryField}) >= 1.

Insert a text box or formula saying "No Data" in the new section.

Naith
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

D
  • Locked
  • Question
Stored Procedure with no Parameters
Replies
1
Views
576
hilfy
hilfy
anandm19
  • Locked
  • Question
Crystal report byte array data to Unicode data format export issue
Replies
0
Views
420
anandm19
anandm19
tlbrown88
  • Locked
  • Question
How to duplicate data from main report lines for sorting purposes
Replies
2
Views
414
lbass
lbass
1tufgt
  • Locked
  • Question
Detail data in Header?
Replies
1
Views
253
dgillz
dgillz
Statey603
  • Locked
  • Question
Page Setup - No Printer - Changes Font Size
Replies
1
Views
263
kray4660
kray4660

Part and Inventory Search

Sponsor

Back
Top