Main Report And Its Subreport
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=14159
Printed Date: 03 May 2025 at 8:26pm
Topic: Main Report And Its Subreport
Posted By: hamadforever
Subject: Main Report And Its Subreport
Date Posted: 22 Aug 2011 at 11:28pm
Hello Readers. I've to make a Customer's Invoice report
which first shows all the invoices of specific customer with specified dates in the following manner
CustomerName
Customer 1
Inv# Grand Total IvnDate
1-2011 15000 01-Jan-2011
6-2011 30000 01-Jan-2011
35-2011 35000 02-Jan-2011
now once these records are shown first i then want to display the detail of each invoice after the first above pulled records end.
Detail for Inv# 1-2011
Product Qty Rate Total
Product1 5 20 100
Product2 6 15 90
--------------------------------------------------
Detail for Inv# 6-2011
Product Qty Rate Total
Product6 10 20 200
Product7 15 10 150
--------------------------------------------------
Detail for Inv# 35-2011
Product Qty Rate Total
Product6 10 20 200
Product7 15 10 150
for this to achieve i have an idea i.e. to use subreport for detail of each invoice and group our main report by invoice # and link main and subreport via saleid (Primary key)
till here the data pulled is accurate but it doesn't display as my client wants mentioned above.
I am looking forward to your guidance
Thanks in advance.
-------------
Hamad Salahuddin
http://www.et.com.pk
Elite Technologies, Abbottabad Pakistan
|
Replies:
Posted By: hilfy
Date Posted: 23 Aug 2011 at 3:44am
|
I would do the first part as a subreport in the report header and then put the details in the main report.
-Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
|