Print Page | Close Window

Create Balance sheet Report

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=153
Printed Date: 19 May 2024 at 9:37pm


Topic: Create Balance sheet Report
Posted By: dummies
Subject: Create Balance sheet Report
Date Posted: 24 Jan 2007 at 5:39pm
hiii All,

i am a newbie in Crystal report, now i wanna to create a balance sheet report for my accounting software.

the report contain 3 major column for each account, that is Beginning balance, mutation(change) and ending balance. Each column depends on their normal balance.

i have some table, that is account table n transaction table (like a journal)

u can see the simple report, below this text

Account   beginning bal    mutation           ending bal
                Debit | Credit   Debit | Credit    Debit | Credit 
Bank          500        -        100      -           600       -
Tax            100        -           -        50         50         -
income         -         1000    50      100         -         1050


Note:
in Beginnin & ending bal, the value's position depend on the normal balance


Any body have an idea?
or have some experience to create a balance sheet?
or have an example, please reply me.
Thanks.

Regards,
Harry


-------------
CR newbie



Print Page | Close Window