Filtering through Date Variables on WRS

[tejeshwar]

Hi,

We are using the SAS WRS 4.3 to support reporting requirement across different functions in our organization. Most of the time, the data is reported for last 24 rolling months and hence there is a need to provide users the ability to filter out data based on a month or an year before they look at a report.

We have observed that if the month or year is in a date format, the ability to create a filter is disabled (not highlighted) when we go to Web Report Studio and hence we have been creating Month or Year in a Character format to enable filtering and have numbers preceed the name of the Month to maintain their sequence.

I was wondering if there is an alternative to that as users dont want to see actual numbers like 1,2 before the name of the months and hence if there is a way to keep that variable in a date format without numbers and be able to filter and maintain the way its sorted.

Regards,
Tej

[mojerry2]

Hi,

there's a solution. You can create a dataset with two columns. The first on has "formatted" values and the second has your numeric values.

Then you "just" have to reference your filter on the created dataset.

sort your filter on the numeric value and the trick is done.

The reporting I've created I've placed a new column (calculated field) with yyyy\mm and on this on I've placed my filter.