I used the select expert to exclude a code that starts with "9928". That worked out fine. Then I ran my report and selected the code field to perform a Grand Total Count. For some reason the the total count is higher than what I have counted in the report? Does anybody have any suggestions?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Grand Total Count for my report is inaccurate
- Thread starter KZOG
- Start date
synapsevampire
Programmer
What are these 2 counts that differ?
I'd suggest that you post what you did and how you did it rather than text descriptions.
If you're just getting a grand total of the rows, test the value you're getting from the grand total vs. a formula containing totalrecordcount.
Otherwise state how the numbers differ, and how you arrived at them. You might even post the Crystal version.
-k
I'd suggest that you post what you did and how you did it rather than text descriptions.
If you're just getting a grand total of the rows, test the value you're getting from the grand total vs. a formula containing totalrecordcount.
Otherwise state how the numbers differ, and how you arrived at them. You might even post the Crystal version.
-k
If your Grand Total is a running total, you can place it in the detail line as a diagnostic, to see where it gets unexpectedly updated.
If your own estimate is based on detail lines, are there detail lines that are not shown but might be counted?
Madawc Williams
East Anglia, Great Britain
If your own estimate is based on detail lines, are there detail lines that are not shown but might be counted?
Madawc Williams
East Anglia, Great Britain
Are you conditionally suppressing certain records ?
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
- Thread starter
- #5
Here is my example:
CPT Code description
1234 xyz
4567 qrs
7895 tuv
1234 xyz
Grand Total = 15 as you can see I show only 4 codes.
I have the detail section suppressed.
I have two groups
1. Group Header #1 = MPVisit.Acct# - A
2. Group Header #2 = CPTCode.CPT - A (The cpt code field and the description field are sitting in the Group Header #2 section)
The Grand total is in the Report Footer.
I am on Crystal 7.
CPT Code description
1234 xyz
4567 qrs
7895 tuv
1234 xyz
Grand Total = 15 as you can see I show only 4 codes.
I have the detail section suppressed.
I have two groups
1. Group Header #1 = MPVisit.Acct# - A
2. Group Header #2 = CPTCode.CPT - A (The cpt code field and the description field are sitting in the Group Header #2 section)
The Grand total is in the Report Footer.
I am on Crystal 7.
If you do not suppress the detail section, do you see 15 individual records? If so, 15 is the result you would expect for a simple count summary. These types of summaries evalaute on every field, even if the data is suppressed.
Insert a running total count field, evaluate once per group on the CPT code, and use it instead of the simple count summary.
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
Insert a running total count field, evaluate once per group on the CPT code, and use it instead of the simple count summary.
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
- Thread starter
- #7
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question