Sometimes when u make changes / save other reports on an existing one, all the report views related to that report will break (i.e. broken links). The symbol for a broken link would be something like that is seen in the picture above.
The solution is simple, go to the “set properties” of that report view. Under “General Properties” you can find “Link the Report” at the bottom of the page just above the “Ok” button. Click on this link and choose the report that u want to connect to. The report view should run fine with all the predefined selections that we had done earlier.
My experiences with IBM COGNOS... Issues and Solutions ... The content on this blog is completely my interpretation and has nothing to do with IBM or my present / older employers
Friday, May 30, 2008
Wednesday, May 21, 2008
Filter accepting only 1 value instead of multiple values Congos Report Studio
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.
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.
Subscribe to:
Posts (Atom)