Column Chart Problem

[ttyre]

I am trying to get rid of empty spaces showing in column chart in place of null values.

I am plotting following fields: Category, Reason, Down Time, Date. Each Category has 1 to 5 Reasons. Not all Categories / Reasons have Down Time.

In Chart Expert, Data tab, Layout I select:
Place chart: Once per report
On change of: Category, Reason
Show values: Sum of Down Time

I am using Date parameter to filter data.
However, on column chart I have empty spaces for Reason(s) for which I don't have data (Down Time). How can I get rid of these empty spaces?

I am using CR 8.5 Dev. edition. Will appreciate help/suggestions.

ttyre

 

[synapsevampire]

Perhaps you can just add to the record selection criteria to filter out those rows?

{MyTable.DownTime} > 0

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[ttyre]

I had tried both {MyTable.DownTime} > 0 and Not(IsNull({MyTable.DownTime])) without success....

Thanks,

ttyer

 

[synapsevampire]

You need to substitute your table and the name of your field for {MyTable.DownTime}.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[ttyre]

I had done that... my selection formula has been:
{vwDownTime.DownDate} = {?Date} And
Not(IsNull({vwDownTime.TimeDown}) And {vwDownTime.TimeDown} > 0)

ttyre

 

[synapsevampire]

And it's showing data that is 0???

Post the SQL (use Database->Show Sql Query)

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com