Advanced Report Studio - Dynamic Grouping
Excercise:
Here we have a Report --> Country, Year, City, Sales Amount, Sales Quantity.
We need to give an option to the user to Dynamically Change the Primary Group to Country or Year.
Steps:
1- Create a Report with Country, Year, City, Sales Amount,Sales Quantity.
2- Create a Static Prompt (?Choice?) on the Report Prompt Page.
3- Specify the Static Choices: Country / Year
4- Specify a Default Choice --> Country
5- Goto Report Page
6- Create two Query Calculations
Group-1: if(?Choice? = 'Country') then ([Country]) else ([Year])
Group-2: if(?Choice? = 'Country') then ([Year]) else ([Country])
7- Change the Header Text for Group-1 or Group-2.
8- Hide Country and Year Columns.
9- Run the Report.
SO THATS IT.....
--
Excercise:
Here we have a Report --> Country, Year, City, Sales Amount, Sales Quantity.
We need to give an option to the user to Dynamically Change the Primary Group to Country or Year.
Steps:
1- Create a Report with Country, Year, City, Sales Amount,Sales Quantity.
2- Create a Static Prompt (?Choice?) on the Report Prompt Page.
3- Specify the Static Choices: Country / Year
4- Specify a Default Choice --> Country
5- Goto Report Page
6- Create two Query Calculations
Group-1: if(?Choice? = 'Country') then ([Country]) else ([Year])
Group-2: if(?Choice? = 'Country') then ([Year]) else ([Country])
7- Change the Header Text for Group-1 or Group-2.
8- Hide Country and Year Columns.
9- Run the Report.
SO THATS IT.....
--
Thanks and Regards,
Bharati DW Consultancy
cell:+91-7738300984
website: http://bharaticonsultancy.in/
The secret in education lies in respecting the student!
No comments:
Post a Comment