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 Studio Reports

Started by srinu1253, 26 Apr 2011 04:37:52 AM

Previous topic - Next topic

srinu1253

I have a List Report with Value Prompts in the Report page
Since the data or Number of Records are high in number

My Client is asking when he run the report he should only see balnk or Zero columns and data should chane as per the Prmpt Selection.


Any inputs on this issue will be more helpful.

Arsenal

hmm, not sure I'm understanding the question but if you just want a blank report on the first/landing run, then just set the prompts to have a default selection (propertis pane after selecting the prompt) of something you know for sure does not exist on the DB
Do it for all the prompts and you'll get your blank report and the user can then pick the correct prompt values, rerun and see the appropriate report

bvk.cognoise

#2
Hi srinu1253,

do you want show columns dynamically based on prompt selection? or
do you want to show data based on prompt selection?

can u please tel me it clearly?

thanks
bvk
Regards
BVK

srinu1253

do you want show columns dynamically based on prompt selection

bvk.cognoise

#4
Hi srinu,

to show columns dynamically based on prompt selection you have to create new new query calculation.

for eg: if you have product line,product type,product name,revenue dataitems
            if want to show revenue based on prompt selection

1st step:

>create a value prompt in prompt page
>to create a value prompt go to prompt page,then drag a value prompt into prompt page from insertable objects
>donot assign any use value ,and display value.
>just finish it after dragging it from insertable objects(infirst stem)
>then select that value prompt ,in properties pane select STATIC CHOICE option
>there click add * symbole
>add use value as 1 and disply value as PRODUCT LINE
>add use value as 2 and disply value as PRODUCT TYPE
>add use value as 1 and disply value as  PRODUCT NAME
>then click ok

2nd step:

>drag a quer calculation into report beside revenue or into query
>in the query calculation  expression window give expression as follows

case
when parameter(drag parameter from parameter tab)=1 then [PRODUCT LINE](drag it from quer items)
when parameter(drag parameter from parameter tab)=2 then [PRODUCT TYPE](drag it from quer items)
when parameter(drag parameter from parameter tab)=3 then [PRODUCT NAME](drag it from quer items)
END


finally expression looks like this

case
when parameter=1 then [PRODUCT LINE]
when parameter=2 then [PRODUCT TYPE]
when parameter=3 then [PRODUCT NAME]
END


then click ok

now run the report

thanks
bvk

Regards
BVK