Opt In (Do Not Edit Here)

Showing posts with label Crystal Report. Show all posts
Showing posts with label Crystal Report. Show all posts

Dec 30, 2013

Crystal Reports: Grouping Pattern





          In this Article we are going see how to make a Grouping in Crystal Report to display data in particular pattern.




Aim: To group the data to be displayed in Crystal Report in following pattern.


FieldTitle1:
          RelatedField1
          RelatedField2

FieldTitle2:
          RelatedField1

FieldTitle3:
          RelatedField1
          RelatedField2
          RelatedField3
          RelatedField4
                  
 
 













                                            
 Description:
          Displaying data into Grouped form can be useful in areas where we need to show common data grouped under the same category.    E.g. Grouping of data by Country, City, Status, etc.


Procedure:
          We can achieve the intended result in two ways...

a)   Set the Group By property while selecting the DataTable and other Fields to place into the desired Crystal Report as follows.

                                   
Figure 1

         

b)   If we do not set the Group By property using case (a), then we need to add the Group Name Fields manually in our Crystal Report as follows.

Path: Field Explorer à Group Name Fields à Group Expert

                                Figure - 2 
 Figure 2


          Now, arrange the required fields on Crystal Report as follows…

                  
               Figure -3        
 Figure 3


Intended Result:

                                                                                 
Figure - 4
Figure 4




Summary: Here we learn how to Group the particular fields on Crystal Report using wizards.
           



All Rights Reserved. 2014 Copyright SIMPLITONA

Powered By Blogger | Published By Gooyaabi Templates Designed By : BloggerMotion

Top