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.
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
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
do you want show columns dynamically based on prompt selection
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