Print Page | Close Window

Help with grouping

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=8625
Printed Date: 13 May 2024 at 4:31pm


Topic: Help with grouping
Posted By: subenemi
Subject: Help with grouping
Date Posted: 13 Dec 2009 at 3:18pm

Hi guys,

Firstly, just like to let you know it is my first time EVER working with Crystal reports and need some help.

I have a report like this:

Situation One: 4
========================
Serial   Text
12345  Some text here
12345  Another one here
12345  blablabla 
23456  Text for other serial
=========================

Situation Two: 6
========================
Serial   Text
98776  Some text here
98776  Another one here
67890  blablabla 
23456  Text for other serial
23456  Text for other serial
23456  Text for other serial

But what I'd like to do is something in this way:

Situation One: 2
========================
Serial   Text
12345  Some text here
12345  Another one here
12345  blablabla 
23456  Text for other serial
=========================

Situation Two: 3
========================
Serial   Text
98776  Some text here
98776  Another one here
67890  blablabla 
23456  Text for other serial
23456  Text for other serial
23456  Text for other serial

This part of the report is inside a GroupHeaderSession and it is counting all fields existent on the resulting query for the report. I'd like to count it grouping by the Serial, for example...
What do I need to do to get this result in the end?

Many many thanks in advance....


Replies:
Posted By: lockwelle
Date Posted: 14 Dec 2009 at 6:25am
use the "distinct count" option for aggregation instead of straight Count, or are you looking to find the number of entries per serial number in a group? that would be a creating a group for serial number inside of whatever group it is in now and looking at the count for that group...count({table.field}, {group specified})
 
HTH


Print Page | Close Window