Button Page Change

[CoginAustin]

Is it possible to make a button or link change the page(jump to) to a particular page.

Say I have a very large report 1 page is US sales and 1 page is International.
I want to click a button to jump to the page named International.

Similar to the TOP, BOTTOM, Page Up, Page Down links on the footer but be able to specify an actual page name or some other ID to get it to move there.

[MFGF]

Hi CoginAustin,

You might be able to achieve something like this by adding bookmarks to your report.Ã,  Assuming you have grouped your report by Sales Region (or created section headings), you could add a list containing the Sales Region to the report header, add a bookmark before the Sales Region within the report (based on the Sales Region Query Item), then from your list in the header, turn on drill-through to the bookmark.

There is one big limitation to this, though - you must be rendering as HTML for the bookmarks to work, and the report should be completely rendered too (try running the report from Cognos Connection and saving the output as HTML before you test the bookmarks).

Best,

MF.

[JennyF1]

Hi CoginAustin,

did you already solve the problem? - I heave a similar one: A report with a ConditionalLayout. One variable with 7 values, where every value has 1 to 3 Report Pages. No groupings, no sections. I'd just like to adress the next or next but one page ...

Some ideas anyone?
Thx a lot, Jenny.

[bdybldr]

I have a similar issue.

I have a Summary (Dashboard-type) page.  I'm trying to create a drill-through on a text item (don't need to pass any parameters) to the second page.  Yes, I could tell the users to use the next page option but I also have other text items in the dashboard to other pages.

For example, I have a page named "Calls Per Surgeon".  I set a drill through on a text item using expression: PageName() = 'Calls Per Surgeon'.  Just to check it it, I create a calculated display: IF (pagename() = 'Calls Per Surgeon) THEN (1) ELSE (0).  When I run the report the calculation is displaying 1 as it should.  But, when I click on the text item with the drill-through, nothing happens.  Does anyone know what I'm doing wrong?

THANKS.

[MFGF]

I'm guessing you are rendering as HTML?

Bookmarks only work if they are on the same HTML page, so if you are trying to test your bookmark by running the report interactively from Report Studio (or from Cognos Connection), only one page at a time is getting rendered, so your bookmark will not work.  Try saving the report, running it from Cognos Connection and saving the HTML output into the content store.  Once the report has executed, click to view the output, and your bookmark should then work as the whole report appears in one long HTML page.

In short, you're doing nothing wrong - it's just a case of understanding how the bookmarks work.

Best regards,

MF.

[bdybldr]

Thanks for your reply, MF.  I really appreciate the help.  I saved the report and opened in Cognos Connection.  Then, I saved the report to the content store using the far left icon (Save the Report).  I then ran the report and the drill-through did nothing.  Any suggestions?

Thanks.

[bdybldr]

Can anyone offer some assistance with this issue.  I have an extremely tight deadline and I feel like I'm just spinning my wheels.  Any help is greatly appreciated.  Thanks in advance!

[sir_jeroen]

CoginAustin = bdybldr?

[bdybldr]

No, I just didn't want to start another topic when one already exists.  Should I open another topic?

[MFGF]

Just checking - you are viewing the saved output rather than running the report again?  Please don't be offended - I know it's an obvious thing, but no stone should be left unturned... :-)

I have put together a simple example of what (I think) you want to achieve using the GO Sales and Retailers package - the xml for the report is attached.  Can you compare what you're doing with my example - it may help you to see if there's a problem with something you're doing?

To get my bookmark to work, I saved the report to My Folders, then in Cognos Connection I used the 'run with options' icon next to the report, and selected the 'save the report' radio button.  Once the report had executed and saved the output to the content store, I clicked on the report name link to view it, and the bookmark navigated me to the next 'page'.

Best regards,

MF.

[bdybldr]

Excellent!Ã,  Thanks for all your help, MF.Ã,  My hat is off to you.Ã,  It worked as you said.

question1: Will the user be required to save the report first before running it?

question2: I noticed that it displayes everything as one page.Ã,  Is it possible to open a new window and only show the section that you bookmarked?

One thing that needs to be mentioned here...The text item label must be identical to the label used in the bookmark or it will not work.

Thanks again MF!  btw...I applauded you for your contribution.

[MFGF]

Wow!  High praise indeed!  Thank you :)

Sorry to say the answer to your first question is yes - the report will need to be run and saved to the content store before the bookmark will work, as drillthrough to bookmark will only work if the bookmark is on the same HTML page, and saving the output renders as one long page.

I suspect the answer to question 2 is no, for the same reason (unless anyone else has a nifty bit of javascript to do the job, if it's possible).

Please, put your hat back on now, or your head may get cold (brrrrr) :)

Best regards,

MF.

[bdybldr]

Sorry to hear.Ã,  Sounds like a possible future enhancement.Ã,  Thanks again.