Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: Main Report And Its Subreport Post Reply Post New Topic
Author Message
hamadforever
Newbie
Newbie
Avatar

Joined: 22 Aug 2011
Location: Pakistan
Online Status: Offline
Posts: 5
Quote hamadforever Replybullet Topic: Main Report And Its Subreport
    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
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet 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
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.031 seconds.