Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Group selection Post Reply Post New Topic
Author Message
punty
Newbie
Newbie


Joined: 08 May 2008
Online Status: Offline
Posts: 5
Quote punty Replybullet Topic: Group selection
    Posted: 05 Jun 2008 at 1:17pm
I'm developing a report which has three groups. My report should do a group selection based on the condition on the summary count on the third group. Any suggestions on how to achieve this is highly appreciated.
My records will look something like this
Grp1 A
    Grp2 B
          Grp3 c  - 10(distinct count)
          Grp3 d  - 18(distinct count)
          Grp3 e  - 20(distinct count)
Grp1 X
    Grp2 Y
          Grp3 k  - 22(distinct count)
          Grp3 l  - 18(distinct count)
          Grp3 m  - 28(distinct count)
My report should display only those groups were the distinct count in any of the members in group3 has a value greater than or equal to 25..In this case my report will display only Group X, because the distinct count of group m is greater than 25.
My report should look like this.
Grp1 X
    Grp2 Y
           Grp3 k  - 22(distinct count)
           Grp3 l  - 18(distinct count)
           Grp3 m  - 28(distinct count)
 
Thanks in advance
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.027 seconds.