How to allow a dynamic selection of a column for a measure in a chart,without using Variable?
Submitted by: AdministratorWe can in do it in this way. first creat a list report in which u have a calculated item in the starting.
Then creat a prompt page with a value prompt.In value prompt creat static choice of which u want to be dynamically displayed.
Let the parameter of value prompt be ?Par1? and the choices as Revenue, Cost.
Now u write the expression of the calculated item in the report page as follows, "If ?Par1?=Revenue then Revenue else Cost.
Here Revenue,Cost should b dragged from the Model Items. So now the calculated item column displays the value of the one selected in the prompt.
Now make a graph using the list report,then place the calculated item on the axis of the chart ,which u wanted to display dynamically based on ur selection.
So now if u select Revenue in the prompt then the grph will take the values for Revenue.And if u select Cost then graph will be with the values of Cost.
Let me know wether this is working good r not,for my confirmation.
Submitted by: Administrator
Then creat a prompt page with a value prompt.In value prompt creat static choice of which u want to be dynamically displayed.
Let the parameter of value prompt be ?Par1? and the choices as Revenue, Cost.
Now u write the expression of the calculated item in the report page as follows, "If ?Par1?=Revenue then Revenue else Cost.
Here Revenue,Cost should b dragged from the Model Items. So now the calculated item column displays the value of the one selected in the prompt.
Now make a graph using the list report,then place the calculated item on the axis of the chart ,which u wanted to display dynamically based on ur selection.
So now if u select Revenue in the prompt then the grph will take the values for Revenue.And if u select Cost then graph will be with the values of Cost.
Let me know wether this is working good r not,for my confirmation.
Submitted by: Administrator
Read Online Reportnet Job Interview Questions And Answers
Top Reportnet Questions
☺ | Explain What is difference between query studio and report studio? |
☺ | How to generate the cubes in framework manager? |
☺ | What is the Difference between PowerPlay transformer and power play reports? |
☺ | Explain What is the Difference between PowerPlay transformer and power play reports? |
☺ | Explain Is there any comparison available for Cognos Reportnet Vs Crystal reports? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |