I have Dynamic report and column say some_date column and data can be in the columun (01-JAN-13) OR (01-JAN-13,04-JAN-13), (01-JAN-13,04-JAN-13,10-JAN-13) so on.
in actual table column some_date is date field but in report as above (string) because using RTRIM(some_date, ',') some_date within the select MODEL clause.
my problem is when run the report and select filter from action menu then it doesn't give option such as < , > or so on because of string but I want it should give <, <=, >, >= operators too as date column. how and what should I do please?
if I have multiple rows on same ID as mentioned earlier so in report showing only one row as follows:
ID Description Date
101, abc 01-Jan-2013
101, abc 15-jan-2013
so in report 101 abc (01-Jan-2013,15-Jan-2013) data will be showing in one column seprated by comma. so when user try to filter on date colum using report then unable to select <, > operators because of data type is string but in actaul table is data type is Date. I understand it is difficult but thinking if any possibility?