Page 1 of 1

Filter Non Numeric Data

Posted: Wed Sep 12, 2012 6:53 am
by Ink
Hi,

I have a report based on an xml file
The xml contains a list of 3 columns which contain numeric and non numeric data e.g

Item Qty100g QtyPortion
First 10 50
Second 20 100
Third 1 Tr
Fourth 0 N/A

I have 2 databand on my report - the first renders the xml 'as is' displaying all the values.
The second contains a barchart graphing the values. Obvioulsy the graph fails if the value is non-numeric.
Is there a way to filter the data just for the graph data band to exclude the non numeric values?

Thanks,

jon.

Re: Filter Non Numeric Data

Posted: Wed Sep 12, 2012 9:39 am
by Alex K.
Hello,

Please send us your report with test data for analysis.

Thank you.