Help needed for Trial Balance

[kuzman]

Hi Crystal people,

I am trying to create a Trial Balance Report, I am having a problem about my balance sections.
I am displaying an beginning balance,displaying net change which calculates debits and credits, summing the detail and displaying the sum of the net change and an ending balance for 12 accounting periods for one year . My problem is I would like to use the ending balance as the opening balance in a new period . What would be the way to solve tis problem, should I use variables, I tried using Previous function but because I had to use this function with formula field It did not work.
My version is 7 by the way and my report basically looks like

Group 1 : Accounting Period
Group 2 : Account NO --this field also calculates Beginning Balance, Sum of Net Change, and Ending Balance

Thank you for the help

 

[kenhamady]

You are going to need to use a variable that gets assigned at the appropriate time. The FAQ on running totals shows some good examples of assigning and reseting variables. While you aren't doing a running total, your code will look alot like the 3-formula technique. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[yagnik3128]

Yes,
The running total is the right way for it.
I have tried it successfully.

But if u can help me in this problem.

My some client want the trial balance in T Format.

i.e.

Date Particulars credit | Date Particulars Debit

Is there any solution directly in Crystal report 7.0 ?

 

[kenhamady]

Duplicate the fields on both sides of the T, so that they print twice for each record. Now suppress the right side fields with a condition like:

{type} = "Credit"

Do the opposite condition on the left.
That way only one side will print at a time. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[yagnik3128]

Yes I get it....

When i am giving the trial balance with only accounts, its ok.
But if i want to insert group on account group & then the account detail like...

Particulars credit |Particulars Debit
-------------------------------|----------------------------
Sundry Creditors |Bank Accounts
P Yagnik 4,500/- | ICICI bank 5,600/-
Y Yagnik 7,900/- |Cash Accounts
-------------- | Cash 1,200/-
12,400/- |Sundry Debtors
Partners | R Shah 400/-
M Desai 1,00,000/- | C Desai 2,980/-
| ------------
| 14,380/-

Is there any solution directly in Crystal report 7.0 ?

 

[kenhamady]

I am not sure what you mean, but you could also split the GF into A and B. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.