Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Crystal Reports Parameter Prompting and Group or SubGroup Values

Posted on 2007-03-20
6
Medium Priority
?
368 Views
Last Modified: 2012-08-14
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!
0
Comment
Question by:VBBRett
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 18756799
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
 

Author Comment

by:VBBRett
ID: 18756994
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
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 18757846
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
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 

Author Comment

by:VBBRett
ID: 18758672
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
 
LVL 101

Expert Comment

by:mlmcc
ID: 18759256
Please let us know if that method solves the issue.

mlmcc
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 18851328
Glad i could help

mlmcc
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question