Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: 2 date ranges in report Post Reply Post New Topic
Author Message
kreusch
Newbie
Newbie


Joined: 04 Nov 2011
Online Status: Offline
Posts: 22
Quote kreusch Replybullet Topic: 2 date ranges in report
    Posted: 23 Aug 2012 at 8:12am
I am creating a basic income statement.  I need to pull all the transactions for a specific month and the transactions for the fiscal year to date. 
 
I put in a paramater for the user to select the the date range (say 5/1/2012 to 7/31/2012).  I can easily get the fiscal year transactions but I am having trouble limiting the month ( 7/1-7/31).  I tried this formula 
 
If  Month ({GLTransactionMasterList.GLTransactionDate}) = Month (Maximum({? Date Range})) then  {GLTransactionMasterList.GLTransactionDebitAmount} 
 
The formula give me an error that a statement is expected for the red print.
 
Any help is greatly appreciated.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 23 Aug 2012 at 9:26am

I assume you mean once you pull the data for the year you mean you need to get a seperate summary for the indicated month

wher are you placing this formula?
IP IP Logged
kreusch
Newbie
Newbie


Joined: 04 Nov 2011
Online Status: Offline
Posts: 22
Quote kreusch Replybullet Posted: 24 Aug 2012 at 2:13am
Yes, I have 2 columns, one for the month total and one for the year totals.  I put the formula in the details section.  I then suppress that section b/c we are only interested in the sum of all those tranactions.  So then I sum the group to get the totals.
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.