Crystal Reports Parameter Prompting and Group or SubGroup Values

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!

I take that and run a distinct count of Start_Date which is grouped under the following

Area
-Region
-State
-City
-Location Name - Under location name, I got the distinct count of the date. There would be records underneath Location name sorted by date which would describe issues that happened. How would I run a parameter so that my users can see a number range from 1 number of dates anywhere all the way up to 100 dates numbered if need be?

Actually, I think I figured out what I need to do. I am making a copy of the table in a different view and joining the table with itself. After that, I only extracted what I need from one of the tables and I used all the fields from the original table. After I join everything properly, I should be able to use the count for what I need. So it appears that if your query sucks, so will your report..LOL!

Featured Post

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Crystal Reports: 5 Tests for Top Performance
It is complete, your masterpiece report. Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways.
…

Hello everyone,
Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8.
We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…

This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg).
If you're looking for how to monitor bandwidth using netflow or packet s…

Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…