Writing Code
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Writing Code
Message Icon Topic: Do calculation by month Post Reply Post New Topic
Author Message
jeff79
Newbie
Newbie
Avatar

Joined: 02 Mar 2011
Location: Malaysia
Online Status: Offline
Posts: 1
Quote jeff79 Replybullet Topic: Do calculation by month
    Posted: 06 Mar 2011 at 3:07pm
Hi,

I am new here, need help from expert to solve the calculation of the report below.....

Need to find out what is the formula to calculate each month figure at the report bottom

P/S. All the figure show at the column below are hiding by formula, which only show the figure belonging to their month.

Date                          Mar                      Feb                    Before Feb
01.01.2011                                                                      1,000.00
03.01.2011                                                                      5,000.00
10.01.2011                                                                      2,250.00
10.02.2011                                          2,500.00
15.02.2011                                             900.00
25.02.2011                                         14,250.00
30.02.2011                                              250.00
01.03.2011            2,100.00
15.03.2011            2,100.00
16.03.2011            1,100.00

----------------------------------------------------------------------------------------
Total                   

Thanks.

   
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 16 Mar 2011 at 3:48am
if you know the columns, or at least the max number of columns that can be displayed, you can create variables and using the same logic for hiding, you can increment the variables.  Then at the end of the report you can display the variables.
 
HTH
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.016 seconds.