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

each radio button for each separate report

Started by haripali, 29 Apr 2009 11:55:28 PM

Previous topic - Next topic

haripali

I have to create radio buttons like a,b,c,d. if user select 'a' radio button then report1
will open,if user select 'b' radio button then report2 will open & so on.

Has anybody has done this. Please guide me.
haripali@gmail.com

david.stachon

...that's a really silly requirement.

Why don't they just use Cognos Connection the way it's meant to be used?

...i.e you select report A, report A runs, you select report B, report B run....etc.

arsinghani

Do you want the radio button within Cognos connection or your report.

In case its within the report there might be issues with prompts if all 4 reports use the same prompts as filters then i recon you make 4 reports show/hide using Javascript. Let me know if that is the Case i'll try to get the JScript 4 u.

johnpenna

Dont use Javascript as you will have problems in later versions of Cognos 8.

We use Conditional Formatting....This works great

We have a Report with a prompt. If you select Main, then all the report will be shown. If you select Subsection then only certain pages are shown..They hide the pages using a simple Yes or No Selection.

I have enclosed some screen prints to help...You should be able to modify this to do what your looking for.

Hope this helps
John




hrk551

Hi JohnPenna,
Hope I am not wrong but your idea works good if there are only 2 reports i.e report A, report B .. for this you can select Yes or No in Conditional block and set a block variable but he is asking for 4 reports ... or can we do it for as many reports we like?

Knowledge base as an example to show Chart,List,Crosstab with just three buttons which ever button u click then that displays. hope you can implement the same for REPORT A,B,C,D......( this is using Java Script)

Thank you

dumbell

If it is like 4 subreports in a report i.e. 4 pages in a report and you want to selectively show the subreports in runmode, below are the simple steps. No javascript needed.


-Drag 4 value prompts having parameter1 thru parameter4 as parameters into prompt page.
-Make prompts optional. (this is for multiselect).
If this is not done, you can select only one subreport.
-Change them into radiobutton.
-Make static choice for each of the 4 prompts. Use and display of each static choice should be same as name of the page ie name of the subreport.
-In the condition explorer, declare 4 boolean variables.
In report expression, for 4 of them declare below statement. x is for 1,2,3,4.
Paramdisplayvalue('parameterx') IS NOT NULL
-Lastly, assign these boolean variables to pages respectively as 'render variable'

Let me knowm how it goes, haripali



david.stachon

As far as good practice goes, these are two rules of thumb:

1) Configure over code.

Out of the box, there is no way to configure a radio button to "run" a report. Yes, you can do so with Javascript, or you can simulate this action using render variables etc (as described above) ....but, why would you want to? ...you could configure (versus code) something that meets the requirements using portlets in Cognos Connection. (i.e. with a cognos viewer and content explorer)

2) Reconcile business requirements to technical capabilities

Before making promises to the business regarding functionality, you must understand what the product can do. This is literally the top BI product in the world, and it is very expensive...thus "out-the-box" should meet 99% of typical BI requirements without having to jump through hoops. Does the business REALLY require running a report with a radio button? ....likely not. Understand the requirement, then choose the path of least resistance in the tool (which takes us back to point 1)

johnpenna

We have this working in 8.3..using variables and not javascript

You have to use check boxes and not radio boxes.

You can do either single or multiple Pages..

I have enclosed the 8.3 report specification.

Open it from Clipboard and it works.

This will work up to 9 pages...

ParamValue('Parameter1') contains '1'


For more than 9 pages you would have to use a defined variable

At present we say :-

ParamValue('Parameter1') contains '1'

If theres more than 9 pages then on the 10 this will pick up page 1 again

So its better to use the following variable..



e.g
page1 = A001
Page2 = A002

Good luck!! ;D