Last Row in a Group Total
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15334
Printed Date: 05 May 2024 at 12:36am
Topic: Last Row in a Group Total
Posted By: angarakiran777
Subject: Last Row in a Group Total
Date Posted: 10 Jan 2012 at 4:47pm
Hi,
I designed a report in CR9 and grouped accordingly by supplier/product/order no.
I want the total for the balance qty.
ABC <- Group 1 (Supplier)
i10 <- Group 2 (Product)
PO-1 <- Group 3 (Order No)
PR No Date Cust PO Qty Rec Balance
----------------------------------------<- Details
PR-1 29/11/2011 79600 30000 6963 23037
PR-2 22/12/2011 81441 30000 6000 17037
PR-3 29/12/2011 81636 30000 6000 11037
PR-4 09/01/2011 82116 30000 9500 1537 (Balance)
PR-5 04/10/2011 78012 30000 16000 14000 (Balance)
-----------------------------------------------
(1537+14000)=15537 (Required)
Please help me very urgent...
thank you,
|
|