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!
VBBRettAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
I don't think you can resolve this in Crystal.

How are you calculating the count?
If it is a summary you may be able to suppress based on the value.

mlmcc
0
VBBRettAuthor Commented:
I am calculating the count like the following.

I have a field from the database called Start_Date

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?

         -
0
mlmccCommented:
Is the count in a formula or a summary function?

Open the select expert and see if the count field is available inthe list of report fields.
If it is
Select it
Choose =
enter 5

See if it filters correctly.

If that works you can create a parameter and use it in place of the 5 int he select expert.

If you need a range you may have to use a little more complex formula

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

VBBRettAuthor Commented:
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!
0
mlmccCommented:
Please let us know if that method solves the issue.

mlmcc
0
mlmccCommented:
Glad i could help

mlmcc
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.