Print Page | Close Window

Performing Math Functions

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=21295
Printed Date: 28 Apr 2024 at 12:50am


Topic: Performing Math Functions
Posted By: pnwhammer
Subject: Performing Math Functions
Date Posted: 23 Jan 2015 at 7:00am
Here is the situation that I am trying to resolve:
 
I currently have 3 reports that provide me with a 'count' of data
 
I would like to create a report that allows me to perform the following ...
 
  ((A Data) - (B Data + C Data))/(A Data)
 
Any help would be greatly appreciated.


Replies:
Posted By: DBlank
Date Posted: 26 Jan 2015 at 4:46am
you can put all 3 reports as sub reports into another main report and pass the values back to the main report as shared variables which can be used in the formula you desire.
Note that sub reports (SRs) are not the best solution for efficient resource use but can be effective. Depending on where a SR is placed it will run each time that section in the main report is printed/displayed. Shared variables retreiving data from sub reports must be placed in a section after the sub report executes. Suppressed SRs do not execute and therefore do not return any data. YOu can conditionally suppress them and the section they are in but to achieve that result.

Posted By: Vimal Nair
Date Posted: 27 Jan 2015 at 12:58am
Whats the kind of database you are using to fetch the data in A , B & C?

-------------
Born To Live


Print Page | Close Window