How to create a crystal report opening and closing balance

Question

0.00/5 (No votes)

See more:

how to create a Credit And Debit amount report with start a opeing balance on top of report and center shows all given date range credit and debite details and in the footer last closing balance

Table

Date_Tran	credit	debit
2/2/2019	5000	
3/3/2019		5000
5/3/2019	25000	
10/3/2019	30000	
11/3/2019	40000

selected date range two different

select date	
from	to
3/3/2019	11/3/2019

then crystal report result

	result		
	opeing balance	5000	CR
			
date	creadit	debit	
3/3/2019		5000	
5/3/2019	25000		
10/3/2019	30000		
11/3/2019	40000		
			
			
closing balance	95000	CR

What I have tried:

	result		
	opeing balance	5000	CR
			
date	creadit	debit	
3/3/2019		5000	
5/3/2019	25000		
10/3/2019	30000		
11/3/2019	40000		
			
			
closing balance	95000	CR

Posted 25-Sep-19 23:04pm

irfanansari

Updated 26-Sep-19 6:16am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Gerry Schmitz · Answer 1 · 2019-09-26T06:16:00

Solution 1

"Control break" on "period". The "sum" of the previous period(s) is the closing balance of that period, which is the opening balance of the following period, etc.

Posted 26-Sep-19 6:16am

Gerry Schmitz

Comments

irfanansari 27-Sep-19 7:51am

but how tell process
select VouDt, InvId,
(select sum(Qty) from inv where VouDt< i.VouDt) as OpnQty,
sum(Qty) as Qty,
(select sum(Qty) from inv where VouDt< i.VouDt)- sum(Qty) as ClsQty
from Inv as i
where voudt >= '2012-04-01' and vouDt<='2012-04-30' -- filter date here it's for april-2012
group by InvId,VouDt i already use but how in report