SOLVED - tabs/buttons to toggle a collection of reports.

[Ixhers]

Hi all.

I am quite new to Cognos and put to the job to convert several reports from another system.

So first of all i want to extend my apoligies if I opened a new thread on something already existing.
But i have been browsing various forums and the web as a whole for a solution i still haven't found.

I have 3 reports, (crosstabs), which are the same except from a created dataitem with a case function.
To the different cases I have set variables to be able to show the connected text values in the crosstabs.

Eg.
Report 1
Measurement; Location Type
Grouped on Rack
Row: Y-coord
Column: X-coord.

Report 2
Measurement; Location Status
Grouped on Rack
Row: Y-coord
Column: X-coord.

Report 3
Measurement; Location Zone
Grouped on Rack
Row: Y-coord
Column: X-coord.

What I want to do is simply to have a header with 3 tabs/buttons where i can toggle between the reports,
This without having to reload each report as they are quite extensive.

Later i want to put a collected report on a separate tab with the 3 reports on the same page.
This based on rack selection selected in one of the 3 reports. I.e. click a rack and get a collected view.

I am not able to use Active reports, (not enabled for us), so this has to be done with a Drill-through somehow?
I've tried several solutions found on various sites, but nothing seems to be working.

Any help would be much appriciated.

Brgs / Rob

[navissar]

Rob,
Thanks you for giving me a chance to show off! A while back I developed an easy-to-use, easy-to-maintain tab solution for Cognos reports, to be used by our developers.
The attached rar has a text file containing the XML of a report. Restore it. Follow the 5-steps directions in the word document, and you'll have your tabbed report.
Good luck, feel free to come up with any questions!

[CognosPaul]

I see I have some competition with the clever JS widgets. I've got my eye on you Mr. Avissar!

That being said, you could also use this technique with a master/detail to set up a nice database driven menu system.

[Ixhers]

Thanks you for giving me a chance to show off!

I won't let you off that easy.  ;)

I took a look at what you suggested, and it looks brilliant, exactly what I was looking for.
However, It doesn't work as intended with the crosstabs I want inserted.

Using a regular crosstab works.
But the ones I use is a sectioned one with a workaround to measure text values.

Regarding the section;
The tabs stops working when I add a second row item.
Here I got Rack, Y-Coord. And it is the same issue regardless if I have it sectioned or not.

Regarding the measurements;
The values I want as measurements are text values.
To go around this I have a case statement, converting the text values to numeric values.
I then added a string variable to get the output in the report as text values again.

The created dataitem converting letters to numbers works.
But when i add the variable to flip them back to letters, i get an error message.

On a sidenote;
I tried to enter a list, (3 columns only), that didn't work either.


Brgs / Rob

[navissar]

Hey! You're raining on my parade for no reason! :)

OK, one step after another. I'm guessing that when you break your Xtab to sections, it produces more than 20 rows, thus pushing the rest of the items below the first HTML page, creating a "next page" link at the bottom and breaking the tabs completely. I guess the same goes for your list. That's to be expected: In order for the tabs to work, all tabbed objects have to be loaded in the same page.
So, what you want to do is go to run->run options and put in a number big enough for your needs under rows per page. When you finally are done with the report, you can set this setting via the report's properties.

Regarding your variable issue, I've tried something roughly the same and couldn't find anything wrong. Maybe if you told me what is the error you get....
See screenshot attached as proof! :)

[Ixhers]

Oh, I would never!  :D

Of course you were right, the row limit was the cause for the tabs not working.

As for the variables, i probably messed up somewhere.
Deleted them and remade it all, works like a charm now.


Can't thank you enough.


Brgs / Rob

[navissar]

No problem.
Hey, if you've styled your tabs differently than the "Default" of my solution, I'd love to see a screenshot.

[Ixhers]

Only changed the colors/fonts a little.
Will probably revise this later, had to get this running quick so I can proceed with various other reports on my table.  :o

But here is a screenie to show I got it right.  ;)

(mousepointer is hovering over the leftmost button)

Brgs / Rob

[navissar]

Cool!