I am working on WRS 3.1, and my reports have filter prompts requiring the user to select the report dates to be displayed (please see attachment). The values in the "Available values" are sorted in descending order, and the Default value in the "Selected values" is the maximum report date.
However, when the client would de-select the values from the right ("Selected values"), the de-selected report-date will be appended on the left window ("Available values"). They want the values to have a consistent sorting, like in the case of my report, the values SHOULD ALWAYS be in descending order. Has anybody here tried adding a sorting action when selecting/de-selecting values in the prompt? Can you guys please teach me how?
Thanks for looking into this problem. I tried checking on available tools in wrs, and I think there is no option to customize the sorting on the user-prompt... I am now thinking if we can adjust some settings in the back-end. I just don't know how 😞
Thanks for your suggestions. The reason for setting a default value, and choosing the maximum date as the default value is for convenience. Users usually look at reports that are most recent.
Actually, aside from the default value and sorting of available values, one user requirement is also to limit the number of selection in the "Selected values" window. I managed to set that by using a stored process and integrate that with my information map. The initial sorting (descending) and setting of the default value is updated by running some codes to update the parameter properties in the metadata of the stored process.
The activity of selecting and de-selecting the values are the items that I need to address... like, what if user changed his/her mind with his/her selection? Again, having a consistent sorting all throughout the process of choosing the parameter leads to the goal of providing the business users a more convenient way of finding things in the selection box.
BTW, I am curious, in WRS 4.2, are values in the prompt always sorted or is it still behaving the same? I haven't tried WRS 4.2 yet 🙂 But back to 3.1, I noticed that the "Filter and Rank" option inside the report (under the "Edit table options") is consistently sorted in ascending order (and there's no option to set it in descending order)
The activity of selecting and unselecting values in 3.1 would require a refresh which I dont think is designed by default into that version.
The prompts in WRS 4.2 are much different. When using timestamp or date formats, the prompts are geared toward dates and date ranges rather than item selections.
For instance on a date time field, I added a prompt with a default value of current hour. When in WRS - I see a drop down box for different selections - such as prior hour, current minute, n minutes ago, etc. There is also a calendar icon that I can select a specific date to use.
When creating a date range prompt this filter operates almost the same way, but then you create two prompts for beginning & end selections.
Is this something that you need to be able to do often? If so, I'd like to talk to you further about this problem. Perhaps several other people have the same problem and we need to address it. Can you give me some detailsr (e.g., how often this is a problem, whether Angelas work arounds helped out, etc.)? Also, if you are a reader and you have experienced the same thing, please tell me about it by posting to this thread.
So far, I just got this request from this particular client. You can say that they are very picky. For now, I have to add the filter to 22 reports. In the future, maybe they will implement pre-filtering the data first before generating the actual report so that the response time will be faster, especially when the volume of data expands.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.