Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Performing Math Functions Post Reply Post New Topic
Author Message
pnwhammer
Newbie
Newbie


Joined: 19 Jan 2015
Online Status: Offline
Posts: 1
Quote pnwhammer Replybullet Topic: Performing Math Functions
    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.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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.


Edited by DBlank - 26 Jan 2015 at 4:48am
IP IP Logged
Vimal Nair
Newbie
Newbie
Avatar

Joined: 29 Dec 2014
Location: United Arab Emirates
Online Status: Offline
Posts: 26
Quote Vimal Nair Replybullet 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
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.