Note: I apoligize if this is a PEBKAC problem. =P
Hi,
I have a creator application that is linked to Zoho Reports using a CSV feed.
My problem is that the decision boxes in Creator get converted accross as Yes/No boxes.
However, when I actually try to filter something according to this, the filter box is showing TRUE and FALSE (If I filter by either, for any of my decision box columns), which, when clicked, say "No Data" when the report regenerates.
A few pictures might explain it better:
http://img99.imageshack.us/img99/5053/ss20100108140018.png
In the above picture, I have just clicked on the green bit which correctly identifies 13 records marked as "YES", however, when Reports actually goes and tries to filter the data I assume it is filtering for the actual words "true" and "false" and thus not picking up my data and letting me filter on it.
http://img237.imageshack.us/img237/6517/ss20100108140350.png
The above picture shows the filter view using the words "true" and "false" to filter.
http://img515.imageshack.us/img515/3729/ss20100108140608.png
The above picture shows my table (the "Yes" and "No" text).
Is there anything I can do so I can correctly report(filter) on these decision boxes that get converted to Yes/No boxes from Creator -> Reports?
Thanks!