Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Summary with Dates and Amounts Post Reply Post New Topic
<< Prev  Page  of 2
Author Message
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 28 Mar 2011 at 11:17am
Not sure I understand what you are asking
IP IP Logged
shefe
Groupie
Groupie


Joined: 09 Feb 2008
Online Status: Offline
Posts: 48
Quote shefe Replybullet Posted: 28 Mar 2011 at 12:01pm
So i have this 2 criteria formulas which works perfectly thanks to you. I only displays students who owe money in our current fiscal year which is what i wanted..  @Fiscal Debtor= """ if {AccountActivity.Transaction date} in DateTime (2010, 07, 01, 00, 00, 00) to DateTime (2011, 06, 30, 00, 00, 00) and {AccountActivity.Transaction type}="Charge"then 1 else 0 """"
the other one is @Sorter= """" if {AccountActivity.Transaction type}="Charge" then {AccountActivity.Extended amount} else if {AccountActivity.Transaction type}="Payment" then {AccountActivity.Extended amount}*(-1) else
if {AccountActivity.Transaction type}="Credit" then {AccountActivity.Extended amount}*(-1) else 0 """"

So right now if i was to delete the group formula under edit selection formula which is
""Sum ({@Fiscal Debtor},{AccountActivity.Full/organization name}) >= 1.00 and Sum ({@Sorter}, {AccountActivity.Full/organization name}) >= $1.00""

I get everybody that owes  us money from 2002 until today but if i go back and apply that group formula then i get students who owes money from july 7/2010 until today, which is fine.  What i wanted to setup multiple groups or separate groups which groups or sorts the student that owe us money per fiscal years

so fiscal year 2011, they owe us $23,000
fiscal year 2011, they owe us $17,000
fiscal year 2002, they owe us $34,000


IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 29 Mar 2011 at 4:06am
do you mean that
1.you want to be able to have a run time param that selects which FY to look at or
2. do you want to see what each student owes each FY or 
3.you want to see the last value that a student owed in their last fy?


Edited by DBlank - 29 Mar 2011 at 4:10am
IP IP Logged
shefe
Groupie
Groupie


Joined: 09 Feb 2008
Online Status: Offline
Posts: 48
Quote shefe Replybullet Posted: 29 Mar 2011 at 5:02am
Thanks for your reply
I want to see what each student owes each FY

and it will be nice  to see a run time parameter that selects which FY to look but not necessary though 
IP IP Logged
shefe
Groupie
Groupie


Joined: 09 Feb 2008
Online Status: Offline
Posts: 48
Quote shefe Replybullet Posted: 05 Apr 2011 at 6:21pm
Anyone help please
IP IP Logged
<< Prev  Page  of 2
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