Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Complicated grouping... Post Reply Post New Topic
Author Message
Jayahar
Newbie
Newbie
Avatar

Joined: 02 Nov 2009
Location: United States
Online Status: Offline
Posts: 1
Quote Jayahar Replybullet Topic: Complicated grouping...
    Posted: 02 Nov 2009 at 10:29am

Hello All,

I am facing a scenario where I have to do a complex grouping. The following is the scenario...
 
1. Group list of people by their birthday.
2. Then Group them by FirstName.(Also list all the people with the same Firstname in Italics, even if their birthday does not fall under this group. Also do not repeat those records under their birthday group).
 
Eg:-
 
 

                               Name                                 BirthDay

                        ------------                                 ----------- 

Jan 2009

            Jake

            ====

                        Jake Taylor                                Jan 10

                        Jake Chandler                            Feb 23

            Kelly

            ====

                        Kelly George                              Jan 11

 

Feb 2009

 

Amanda

=====

            Amanda Swann                          Feb 08

Wolf

            ====

 

                        Wolf Blitzer                                Feb 11

 
 
 
in this example Jake Chandler's birth day falls in Feb, but he had to go in Jan because of the Name grouping...
 
Any input is appreciated.
 
Thanks,
Jay
 
 
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 03 Nov 2009 at 6:47am
so you are really grouping first by name then be birthdate and italicizing the second-nth occurance of a name.
 
the grouping is now simple, italicizing is only slightly more complex.
I would use a variable in a formula.
GH:
shared booleanvar disp:=false;
""//to hide the false
 
I would create a second detail section and suppress it, I would place this formula in it
Details b:
shared booleanvar disp:=true;
 
in the format section of the name cell, font tab, for the style, I would place in the 'x-1' button:
shared booleanvar disp;
if disp then
  crItalics //I think, the formula will tell you
else
  crNormal  //again reference the formula
 
 
all done.  Should work
 
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.016 seconds.