Crystal Reports Parameter Prompting and Group or SubGroup Values
Posted on 2007-03-20
I have a report that has a counter in group heading number 5. The report is grouped by region, then by city and state and then by store location name. After the group of store location name, it list the dates of things that have gone wrong for that particular store. What I have done is taken the date field from my query and made it a distinct count value so that it can count up all the dates. This is an important value as my department wants to see how many days there were issues. This counter is not a group, but it is within a group. Now my problem is they want me to make a selection criteria or a parameter prompt so that if they want to see a location with 1 date number, then all that would be listed are locations with the count of 1. They also want a range so that if they want to see locations that have 5-10 days of dates listed, then it would have to show records that have from 5-10 days of records. Can you guys help me with my parameter selection? I am not sure how to solve this problem. I know how to make a parameter, but not one like this. Thanks!