Solved

Summary field In Crystal Reports XI produces wrong result

Posted on 2006-06-23
11
321 Views
Last Modified: 2012-05-05
I am developing a report which is grouped on a formula field @Route which is composed of two database fields (Origin and destination) separated by a space. I have inserted a summary field into the Group Footer which counts the database field PONumber (which exists in the detail section). However the summary field is coming out wrongly. It shows the same number for each @Route group. The Detail section in the report is suppressed. Any ideas of what I can try to fix this?
0
Comment
Question by:JamesJMcDonnell
  • 5
  • 5
11 Comments
 
LVL 28

Expert Comment

by:bdreed35
ID: 16968042
If you unsuppress the details, are there defintely different numbers of records per Route?
Is your summary field using distinct count or another summary type rather than count?
0
 
LVL 22

Accepted Solution

by:
Ido Millet earned 500 total points
ID: 16968078
I suspect your summary is a formula that looks like:  
Count({PONumber})
This would give you a Grant Total and hence would be the same anywhere you place it on the report.

You need to change it to:
Count({PONumber}, {@Route})
which would give you the Count by Route.

- Ido

0
 

Author Comment

by:JamesJMcDonnell
ID: 16970214
Hi bdreed35, my summary field did look like Count({PONumber}) but when I changed it to Count({PONumber}, {@Route}) I got the same results. There are different numbers of records per route and they appear when the suppression on the detail section is lifted.

0
 
LVL 22

Expert Comment

by:Ido Millet
ID: 16971139
That comment (about the required syntaxt for the summary formula) was from me.
 In what section did you place the summary formula?  Are you sure it is in GF1 or GH1 (it should NOT be in RF1 or RH1)?

- Ido

0
 

Author Comment

by:JamesJMcDonnell
ID: 16975670
It's in GF1
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
LVL 22

Expert Comment

by:Ido Millet
ID: 16975686
Copy & Paste to show us the @Route formula.

Copy & Paste to show us the summary formula.

Are you 100% sure you are grouping, at levcel 1,  on the @Route formula.
0
 

Author Comment

by:JamesJMcDonnell
ID: 16982221
Route formula:
{Transit Analysis PO Details.OriginName} + ' ' + {Transit Analysis PO Details.DestinationName}

summary formula:
Count({Transit Analysis PO Details.PONum}, {@Route})

The Group Name field is @Route and the summary formula is in GF1
0
 
LVL 22

Expert Comment

by:Ido Millet
ID: 16983846
What is the number you get?

What should be some of the numbers you get (in different Group Footers)?
0
 

Author Comment

by:JamesJMcDonnell
ID: 16986093
The report is parameterised and for the widest range of values I get 5, 5, 5 for three different routes when I should get 3,1,1. The

For Month June 2006 I get 3,3,3 when I should get 1,1,1

For Month July 2006 I get 2 for one of the routes, which is correct
0
 
LVL 22

Expert Comment

by:Ido Millet
ID: 16986140
Given that 5 matches the grand count of the 1st case, and 3 matches the grand count of the 2nd case, I suspect you didn't update the formula you are showing according to the instructions we gave.

You may have created a new formula according to the instructions, but you are still showing the old formula.

Cheers,
- Ido
0
 

Author Comment

by:JamesJMcDonnell
ID: 16986189
Actually I had used earlier version of the report (as the current version had a temporary error) which did not have the {@Route} bit in the summary formula.
When I tried later with the current version I discovered that it is working properly now and that I had used a certain other parameter and not realised that there would be fewer records (duh!) So thanks for your help Ido as the inclusion of {@Route} was what was needed.
0

Featured Post

Highfive Gives IT Their Time Back

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!

Join & Write a Comment

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…
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…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

758 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now