Print Page | Close Window

Why not collect some of the total area?

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=9622
Printed Date: 29 Apr 2024 at 9:19am


Topic: Why not collect some of the total area?
Posted By: koncuk
Subject: Why not collect some of the total area?
Date Posted: 06 Apr 2010 at 9:20pm
Why not collect some of the total area?

for example

Sum ({@GirisTutar}, {StokKarti.Grup})/Sum ({@GirisMiktar}, {StokKarti.Grup})

this formula not collect at report footer. Is there a method of collecting runtime time?


Replies:
Posted By: hilfy
Date Posted: 07 Apr 2010 at 5:27am
This won't collect at the report footer because it's data for a group - it will only collect at the group footer.  If you want to do a total for the report, you'll need to change the formula to:
 
Sum ( mailto:%7b@GirisTutar%7d%29/Sum - {@GirisTutar})/Sum ( mailto:%7b@GirisMiktar - {@GirisMiktar })
If you want to see a summary for each group in the report footer, you'll have to use a subreport that will run from the same tables or commands with the same parameters as your main report but will just calculate  the group totals.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window