Friday, May 30, 2008

Cognos 8 Report Studio – Broken Links

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.

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.