Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: suppress if record values are same Post Reply Post New Topic
Author Message
krsnapv
Newbie
Newbie


Joined: 09 Apr 2009
Location: India
Online Status: Offline
Posts: 3
Quote krsnapv Replybullet Topic: suppress if record values are same
    Posted: 01 May 2009 at 5:12am
HI,
 
I want to suppress record filed, if fild data are same/ duplicate, none of them should not show on report and instead it should show the its record count.
I hav a senario like the field values
the companies   % shared
 A                          25.0
 B                          25.0
 C                          25.0
 D                          25.0
if all % shared are equal then should show like bellow instead %
 A                          4
 B                          4
 C                          4
 D                          4
 
can you find me a solution for this
Thanks, Kris
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 01 May 2009 at 5:38am

Hi

A bit confused what is 4 is it the total record count or individual % count for companies ....
 
a bit more sample records i.e mixture of duplicate and non-duplicate records would  be better and what needs to be shown in both scenarios will also be helpful.
 
cheers
Rahul
IP IP Logged
krsnapv
Newbie
Newbie


Joined: 09 Apr 2009
Location: India
Online Status: Offline
Posts: 3
Quote krsnapv Replybullet Posted: 01 May 2009 at 6:06am
Rahul,
the i require is the records are grouped by Employee name nd 4 is the record count , check the bellow sample for better understand
        
Employeee    Comapny            %Shared
 
 Emp1
                        A                          4   
                        B                          4
                        C                          4
                        D                          4
 
                              
 Emp2
                        E                          50.0
                        F                          25.0
                        G                          25.0
                       
                                  Toatal%     100.0
 Emp3
                        H                         2  
                        A                          2
 
pls share your thoughts
Thanks,
Kris                     
 
 
 
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.033 seconds.