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!

Null Value in Chart 1

Status
Not open for further replies.
Aug 9, 2006
17
GB
Hello,

Apologies if this question has been asked before. I am using Crystal Reports 9 on an Access database. I have created a bar chart which displays catalogue records in stock grouped by owner (I am reporting on a library database). Unfortunately some of the items have no owner so the bar relating to them displays no label.

I had been able to create a formula in other non chart reports which displays an owner unknown message where the owner isnt present i.e if ({Catalogue.Owner}) = " " then "---Owner unknown---" else {Catalogue.Owner}

However I cannot see any way to do this in the chart. Is it not possible or am I missing something obvious?

Many thanks,

Brenda
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top