Filter Non Numeric Data
Posted: Wed Sep 12, 2012 6:53 am
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.
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.