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

Setting field if no data returned from dataset

Status
Not open for further replies.

espltd

Programmer
Apr 6, 2005
233
US
I have a crystal report and would like to place a string value in 2 columns if no data is returned by the dataset. So with a report that has 2 columns named Name and Total,
if no data is returned instead of

Name Total

I would have

Name Total
none N/A

Thanks.
 
Code the 'none' line as a section. Set conditional section suppression
Code:
not isnull({your.field})

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

Part and Inventory Search

Sponsor

Back
Top