COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: coghelp on 11 Aug 2012 12:28:20 PM

Title: Is any script gurus here? I need help
Post by: coghelp on 11 Aug 2012 12:28:20 PM
I here 2 different URLs for Cognos and each is pulling transaction reports and it is not possible to pull them in to FM model. So please dont give those suggestions...

e.g.
http://abc/cognos83

http;//xyz/cognos83

I want to get both of this reports in to single report with the help of iframe. Is it possible to do with the script ?
Title: Re: Is any script gurus here? I need help
Post by: CognosPaul on 12 Aug 2012 03:22:19 PM
At the most basic level, using iFrames to pull two separate reports into a single page doesn't require any scripting.

The easiest way is to get the URL of the report, and put it in the src of the iFrame. If you're unsure how to generate the URL of the report, just follow these steps.

1. Navigate to the report in question, and click on the properties.
2. Set the default action to something that opens in HTML (run report or view most recent version). If you want to prevent the report from prompting the user, set it there. Click OK.
3. Open the properties again, then click on "View the search path, ID and URL".
4. Copy the default action URL.
5. Refer to the Admin and Security Guide for more details on parameterized URLs.

Once you have the URL of the report, it's a simple matter of:

<iframe src="URL GOES HERE" frameBorder="0" style="height = 200px; width=100px">Default text if browser does not support iFrames</iframe>

Depending on how your authentication system is set up, you may have some issues. The users' sessions will be checked for credentials to both systems.