Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Version XI - Crosstab Post Reply Post New Topic
Author Message
hottest
Newbie
Newbie


Joined: 14 Sep 2012
Online Status: Offline
Posts: 2
Quote hottest Replybullet Topic: Version XI - Crosstab
     Posted: 14 Sep 2012 at 8:50am

Hi there!

I'm new to this forum and i need help whith crystal reports XI.
 
The issue is that in each cell i have 3 amount (a1,a2,a3).
In the summary fields i need to add another amount which is a1 divided by a3. Of course, it'll be changing from cell to cell. The crosstab is dynamic dependending of year and month.
If you need more info. plase ask for it.
Help me anyone, please! 
 
 
 
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 17 Sep 2012 at 9:32pm
Hi
 
Insert any number field as amount (a4) and suppress it for all cells accept summaries.
 
Now in Summaris right click on a1 total go in Format Field --Suppress --Formula editor and give the following formula :
 
Whileprintingrecords;
numbervar a1:=Currentfieldvalue;
false;
 
Right click on a3 summary and go in Format Field--Suppress--Formula editor and write the following formula
 
Whileprintingrecords;
numbervar a3:=Currentfieldvalue;
false
 
Now right click on  summary of a4 and go in format field --Common Tab--Display String--Formula editor and write the following formula
 
Whileprintingrecords;
Numbervar a1;
numbervar a3;
if a3 <> 0 then
Currentfieldvalue := a1/a3
else
0
 
 
 

 
 
Thanks,
Sastry
IP IP Logged
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