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!

Supress null values in graph

Status
Not open for further replies.

marydn

Programmer
Mar 26, 2001
152
US
Hello,
I created a simple graph that displays a name and a count. The data comes directly from the db so I don't sum any data in the report. The problem is that all my names must be in the report even if there is no count value. However, in my graph all the names appear even when there is no count. I want to eliminate those names wihtout a count from the graph. I went to format chart and supress and entered

isnull({table.Count})

When I do that all my data disappears.

Any help would be appreciated.

M.
 
Never mind. I got around this by creating a subreport and filtered only the non-null values for the entire report.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top