This is one issue where I spent like 1 full day. The issue I was facing was, the report had a ‘search and select prompt’. I had created similar reports just couple of days back and this new report basically had a different object, nothing more.
I added some new prompts and when I ran the report, everything was fine except that the filter was taking in only 1 value in a multi select prompt. When I display the filter on the report page as a text, it shows all the data items I selected but in the table it was giving only one value. I checked on the filter whether I used ‘=’ or ‘in’ because usually that is the mistake we do.
Anyways, the reason it was happening was because of the framework. The parameter filter in the framework was assigned to ‘=’ rather than ‘in’, so no matter what the filter was, it would not allow it to work. So when things act very weird, just talk to your framework manager on the conditions that he has applied on the framework.
No comments:
Post a Comment