Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 369
  • Last Modified:

Group by in crystal reports 8.5

I want report like this

City:tehran      University:sharif        occupation:eng Computer
   NAME      |     LASTNAME    |  ADDRESS   |  TELL
   sh               mehr          teh         123
   a                 z            teh         456

City:tehran      University:sharif        occupation:eng electronic

   NAME      |     LASTNAME    |  ADDRESS   |  TELL
   sae               kar          teh         851

i must use grouping but i dont know group by in crystal reports
pleas help me
shiva mehr
1 Solution
Hi Shivamehr,
 I am writting ab Crystal report 8.0
 You can make use of "Using Crystal report Expert" which will give lots of option to make a report.
 another way is
Put "occupation", city and University in Page Hrader and make "occupation" field as group By.
 Also you can directly write Broup by in "Database-- Show SQL Query" field.

try out.

Looks like you need 3 groups.

Open the report
Select Insert Group
group on City
Select Insert group
group on university
Select Insert Group
group on occupation
Use the Occupation group header for the
header lines
Suppress the other group headers



Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now