Suppress Zero Values in Chart 1

[mtownbound]

I'm charting players' points with a bar chart in my report, but players that have zero points are being also displayed in the chart. I could add amplifying information, but it's a pretty straightforwrd issue(or so it seems)



Thanks!

 

[IanWaterman]

Just filter data to exclude zero points in select statement

If you want to see zero point players in another part of report, you could create a subreport just for the chart and filter out the zero point players in that.

Ian

 

[mtownbound]

Thanks Ian, but I can't filter the data to only players with >0 points because I'm using multiple charts. I guess I could flip your suggestion and use a subreport to filter the results for players more than zero points.

 

[mtownbound]

Ian, using that subreport did the trick!! Thanks!!