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

Selection Criteria

Started by Prakash Bhai, 22 Apr 2010 05:11:21 AM

Previous topic - Next topic

Prakash Bhai

Hi,
In the main Report page i have 2 radio buttons and 2 cross tabs.
1st radio button has (Day,week,month)
And 2nd Radio button i have ( Emp & Dept)
And 1st cross tab is having Emp related data
And 2nd cross tab is having  Dept related data.

          My question is, Based on 1st radio button selection and 2nd radio button selection,desired cross tab has to appear (For eg: If i click day and emp. Emp cross tab has to come or day and dept, dept cross tab has to appear.
If u know any ans pls reply

Sreeni P

gimme some more clarification in brief

Prakash Bhai

Based on 1st and 2nd radio button prompt selection..

I need a cross tab which has day/week/month in rows and emp or dept in cols

MFGF

Hi,

as I see it, your two main options are:

a) Create one large crosstab with Day, Week and Month stacked below each other in the rows area and Emp and Dept stacked next to each other in the columns area, then conditionally hide the parts you do not wish to be visible, or
b) Create 6 crosstabs to cover each combination of Day/Week/Month and Emp/Dept, and conditionally render the appropriate one using a conditional block.

Regards,

MF.
Meep!

Prakash Bhai

Hi MF,
As per ur guidelines i am getting desired results for 1 radio button. With 2nd radio button, No change in the crosstab

MFGF

How have you coded your expression to drive the conditional rendering?
Meep!

Prakash Bhai

Hi MF,
I have used a string variable and have mentioned paramdisplayvalue('Selection criteria')
And based on this, I have created static variables...

MFGF

Sorry - that doesn't really tell me what you have done.

Your expression will need to take account of the values set by the parameters from both radio button prompts, and set the outcome appropriately.  You can then use this outcome to drive the conditional block (or conditional hiding).

MF.
Meep!