Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Help with grouping Post Reply Post New Topic
Author Message
subenemi
Newbie
Newbie
Avatar

Joined: 13 Dec 2009
Location: Brazil
Online Status: Offline
Posts: 1
Quote subenemi Replybullet Topic: Help with grouping
    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....

IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.