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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

No data found

Status
Not open for further replies.
bubu2006

bubu2006

MIS
May 2, 2006
157
US
Hi,

I want to display a message if the report retuns no data. I am using Oracle 10g as back end and Crystal Report 10 as front end.

Any one has any clue,
bb
 
Sort by date Sort by votes
Create a section with the message "*** No Data ***". Right-click, Section Export, Suppress Formula. Do a test for some value that won't be null unless there was no data, e.g.
Code: 
not IsNull({your.accno})

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Ivan Kok
  • Locked
  • Question
Crystal Reports Runtime causing AS/400 DB2 Database ID to be disabled intermittently
Replies
0
Views
582
Ivan Kok
Ivan Kok
dgillz
  • Locked
  • Question
Outlook as a Datasource?
Replies
0
Views
559
dgillz
dgillz
BTPJayW
  • Locked
  • Question
Verify Database Not Working Against Stored Procedure
Replies
1
Views
649
hilfy
hilfy
dgillz
  • Locked
  • Question
Cannot connect to any ODBC datasource with MS SQL Server data in crystal
Replies
8
Views
962
LyleU
LyleU
PaulWiersma
  • Locked
  • Question
Failed to retrieve data from database
Replies
1
Views
182
kray4660
kray4660

Part and Inventory Search

Sponsor

Back
Top