Accounting ledger making in crystal reports

Question

5.00/5 (1 vote)

See more:

, +

How can I design a General Ledger in crystal report from sql server database?
I have these fields using C-sharp.net 2010

As shown below, there are 2 transactions for which money was received for specific purpose which appear on the receipt (DR) side eg Maintenance charges Rctamt 200 pmtant 0
,lift Maintenance Rctamt 100 pmtant 0

transno date pmtmode acctno purcode pur rctamt pmtamt
1 16/03/2011 Cash 0001 Ar001 Maintenance charges 200 0
2 16/03/2011 cash 0001 Ar002 lift Maintenance 100 0

The report should be in a way that each of the above purpose (pur) would now be a group and their amounts will be on the pmt(CR) side and Purpose should all read Cash.
Then Cash should now be a group that will show all the transactions in all the groups with their amounts on tne receipt (CR) side so that the total will be equal on both CR and DR.

AS in my example, 300

sno transdate acctno purcode pur rctamt pmtamt

Maintenance charges

1 16/03/2011 0001 Ar008 Cash 0 200

lift Maintenance

2 16/03/2011 0001 Ar008 Cash 0 100

Cash
1 16/03/2011 0001 Ar001 Maintenance charges200
2 16/03/2011 0001 Ar002 lift Maintenance 100

Total 300 300

Posted 6-Feb-12 0:09am

Shaii.J

Add a Solution

Comments

thatraja 9-Feb-12 8:29am

What happened? you rejected my answer :|

Shaii.J 11-Feb-12 5:15am

I really want to say thanks to you to sending me this link its help me to design the layout of ledger report but i did not got the exact result what i need ...

I am sorry , I dont want to reject your answer ..its by-mistakely i click to reject solution . I hav already done the layout designing of ledger reporting. now i want to do only grouping on the reports . now i hav done the group on my reports but its showing me gathering of the data in one group . this also not working as per my requriment .

But i want like this,

This is my table structure
paymode id date acc_code accountname debit_amount credit_amount
cpc 1 2/1/2012 E Cleaning exp 200 0
cpc 2 2/1/2012 A cash 0 200

cpc 3 2/1/2012 E Sundry exp 2500 0
cpc 4 2/1/2012 A Bank 0 2500

And i want report like this
--------------------------------------------------------------------------
date particular debitamt credit amount
---------------------------------------------------------------------------
1-2-2012 cashA/c
---------------
cleaning exp 200 0
Sundry exp 2500 0
-------------------------------------------------------------------------------
2700 200

1-2-2012 cleaning exp
---------------
cashA/c 0 200

-----------------------------------------------------------------------------------
200 200

1-2-2012 Sundry exp
---------------
cashA/c 0 2500

-----------------------------------------------------------------------------------
2500 2500

Thanks and regard
shayni

thatraja 11-Feb-12 5:28am

Then you may use nested Groups. For calculations check my recent answer Crystal Report formula to Calculate Balance from Credit and Debit BTW you may accept the answer again by the Accept Answer button if your question solved.

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)

thatraja · Accepted Answer · 2012-02-06T03:37:00

Solution 1

Use Groups in your report, check this
Groups in Crystal Report[^]

Posted 6-Feb-12 3:37am

thatraja