Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: CrystalReports
Hi All
 
My doubt is regarding with grouping in crystal report. I have four tables a,b,c,d The primary key of table a is in b,c, and d .I want to create a report of this tables .I want to display details like
 
Table a's details
b_Items
details in b corresponding to a's id
c-Equipment
details in c corresponding to a's id
d-Expense
details in d corresponding to a's id
 
I used group concept .Grouped by using a's Id.but there is only one detail section coming while grouping .if i placed heading (b-items) section in the header and "details in b corresponding to a's id" in the detail section .How could i place remaining things in my report.i mean c-Equipment,d-Expense.there may be more than one or two items in each section of b_items,c-Equipment,d-expense.How to list Sub items below the main head one another. Please give a solution to solve this.
 
Thanks in Advance
Amrutha
Posted 16-Apr-12 23:12pm
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Hi all
 
I Used Sub Report in crystal report to get this result
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Hi Amrutha
After adding grouping of "a" u will find only one details section. but u may create other sub sections by
Right Click on details section ->Insert section below
and now u two details section are added in your report
1.details(a)
2.details(b)
and so..
u may add more sub section using this.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 365
1 _Amy 265
2 Richard Deeming 250
3 Nirav Prabtani 248
4 CHill60 195
0 _Amy 110
1 Maciej Los 90
2 OriginalGriff 85
3 Mehdi Gholam 80
4 Sergey Alexandrovich Kryukov 75


Advertise | Privacy | Mobile
Web02 | 2.8.140721.1 | Last Updated 30 May 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100