Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: How to caculate opening balances Post Reply Post New Topic
Author Message
Noel
Newbie
Newbie


Joined: 17 Oct 2011
Online Status: Offline
Posts: 2
Quote Noel Replybullet Topic: How to caculate opening balances
    Posted: 17 Oct 2011 at 10:27pm
Hi All
 
I have an accounts  table with following fields :Date, Particulars, Debit, Credit which displays data correctly in Crystal Reports. I also have a parameter in crystal where the user enters the from-to date range.
 
I now need to place an Opening Balance in the report on one line, based on the data range which the user enters. So lets say the user enters the date range as 5th October to 18th October, the opening balance should calculate (all credits minus debits) upto 5th October and this amount will be the Opening Balance.
 
Rgds
Noel  
 
 
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 18 Oct 2011 at 3:36am
first thought is to have a subreport that runs from the beginning of time to the start date...pass the result back as a shared variable and go from there.  The subreport would basically be your current report with all the parameters linked to the main reports parameters, just hard code the start and link your start to the subreports stop.
 
It's a thought
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.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.