If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Report navigation by my self

Started by nugget, 28 Apr 2009 08:22:53 AM

Previous topic - Next topic

nugget

hi folks,

did anybody know how i can build my own page navigation via html-objects in a report?
if i create more then one page maybe four or five pages in my report, cognos creates a pagenavigation on the bottom of the report. but this navigation gives only the abbility to jump to the first, next, previous and last page. but i want a navigation which has the abbility to jump directly to page 3 for example. 

i disable the cognos navigation with the following html-code:

<style type="text/css">
table.pageControls {
display: none;
}
</style>


now i would build by own navigation with html-object but i dont know how i can navigate to a page like page 3

please help me ;D

vij

hi nugget ,

Do you  want to use Prompt to nevigate across the pages ??

if yes its possible by that.

regards,
vij
:)



angela

You might be able to do it with bookmarks.  The trouble as I see it is that you'd have to force certain rows to be on certain pages.  Page 1 might then contain a list with rows 1-20, Page with rows 21-40, etc.  Then place the bookmark objects on each page and use a drillthrough (on a text item) to direct a user to the required bookmark.

I can't imagine how you'd use just one list to direct users to certain rows.  Hmm, perhaps if you had rownumber in the query and forced the list to retrieve it (the Properties property) you could then unlock the report and put the bookmark next to the first value in the list, and change its property from Text to Data Item Value: RowNumber.

I'm not an expert on Bookmarks but I think it's possible.

nugget

hi anglea thx for your reply,

i dont want to use one list for different pages. Every page has his own list with different informations. i try to explain my problem:

at the moment i have build a tab navigation in my report where users can choose which information should be displayed. over this solution i can combine multiple reports (which use the same package) to one. or i can display informations of one report in multiple ways without creating drillthrough reports for every way. its easy to administrate. i read documents from cognos where cognos show how to build a tabnavigation. they use javascript in there solution. My Solution is without javascript just standart cognos reportstudio onboard objects. So its compatible to further cognos updates.

here is what i do:

First i created a query the name of the query is "Navigation".
in this query i add one dataelement for each tab i want.

for example:
i would five Tabs in my navigation so i added five dataelements. i named the dataelements as Tab1,Tab2,Tab3,Tab4 and Tab5. then i filled each dataelement with a string 'Tab1','Tab2','Tab3','Tab4' and 'Tab5'.

Next i created a list. the query for this list is "Navigation". in this list i input five textelements (one per column). These textelements show the text which will displayed in each tab. 

i defined a prompt with the parameter "TabToShow". then i add static values for the prompt. the static values are the same as the strings in the dataelemts in the query "Navigation" (Tab1, Tab2, Tab3, Tab4 and Tab5)

then i add a variable (type: stingvariable (not bool)) with the name "Var_Navigation". The specification of this variable are: ParamValue('pTabToShow'). The values of this variable are Tab1, Tab2, Tab3, Tab4 and Tab5 too.

then i created for each tab a block. so in this example i create five block. each block gets the stylevariable "Var_Navigation" and type of box none. (in german reportstudio the option called "Typ der Box")

in these blocks i put the reportinformations for the users (list,crosstab or whatever).

then i saved the report.

now i have to say which block should be displayed if a user klick on a tab. so i marked the first column of the Navigation-List and set a drillthrough to the report it self. for the parameter "TabToShow" i set the dataelement "Tab1". in the condition explorer i clicked on "Tab1" and selected the first block and change the option type of box to block. this step i did for every column in the Navigation-List.

at last i set the prompt for the parameter "TabToShow" to invisible because the users should navigation with the tabs.

that is the conecpt how my tabnavigation works. i hope you understand what i tried to explain ;-).
in german its a lot easier for me.

i attached a screenshot of one of my reports where i used this navigation. show how it can look if you are femiliar with this technique, reportstudio and css.
in this screenshot i have a two level tabnavigation. i deleted all the values you have to excuse


Now my Problem:
With my Tab-Solution the user see only the information he selected over the tab. but in reportstudi all the information and navigation stuff is on one page. in a few reports i have so much information on one page that working with reportstudio is very slow. that suxx :-)

i tried to add one site for every tab with the site explorer and allocate the informations to these sites. it works the performance of report studio is good if i do this. but now i have the problem that i dont know how i can navigate to a site with my tabs. thats the point where i need help FROM YOU ;-)

angela

I have no idea how to do what you're asking.  Your original request mentioned navigating within one report but this last message indicates you have several reports.  The method I use to deal with that is to create a portal as attached.  The documentation for pagelets (tabs) is pretty good if I recall.