you can design crystal reports that allow the user to actively choose how records you want to display in the report.
you have report with column like Customer ID,Customer Sales and you wand to modify the report based on choice grouping the Customer and Group by Country
Process:
1.Create Parameter Filed
2.Add Values like Group By Customer and Group By Country-these values you can see when you refresh the report-it will prompt with these values
3.Create New Formula like if {Group Name}=Group By Customer then Customer Field else Country Field
4.Create Group based on the created formula
you have report with column like Customer ID,Customer Sales and you wand to modify the report based on choice grouping the Customer and Group by Country
Process:
1.Create Parameter Filed
2.Add Values like Group By Customer and Group By Country-these values you can see when you refresh the report-it will prompt with these values
3.Create New Formula like if {Group Name}=Group By Customer then Customer Field else Country Field
4.Create Group based on the created formula
No comments:
Post a Comment