Develop Ledger (Balance Sheet) Report in BIRT
Dear Fellows,
Currently, I am stuck with a report to develop a ledger balance sheet report. I have an opening balance for quantity and amount. There are some receiving and issuance transactions made on the opening balance quantity and amount. I am supposed to calculate the running balance at the end of each issuance/receiving transactions. This is more like a bank account statement for a particular month in which we have an opening balance and we make some debit and credit transactions and we are supposed to keep track of the current balance after credit/debit transactions.
My data looks like below,
**I am supposed to develop a ledger/balance sheet report as illustrated below;
**
Comments
-
I want Birt Gurus @Matthew L. . and @jfranken to please contribute
0 -
Try the following:
- Create a Data Set that retrieves all of the data.
- Drag the Data Set to the report body to create a table.
- Edit the "Issue Qty" and "Issue Amount" Data elements in the table. Change the expressions to multiply the value by -1.
- Add a group to the table (I think you will be grouping on "Item Code").
- Add two columns on the right side of the table, one for "Balance Qty" and one for "Balance Amount".
Insert an Aggregation element in the detail row in each of the new columns. Use the following settings:
- Function = "RUNNINGSUM"
- Expression = SUM the "Receipt Qty" and "Issue Qty" columns for "Balance Qty" aggregation. Expression = SUM the "Receipt Amount" and "Issue Amount" columns for "Balance Amount" aggregation
- Aggregate on the group for both.
For totals, add Aggregation elements in the group footer columns that simply SUM the rows in the column.
Warning No formatter is installed for the format ipb1 -
Dear Jeff,
I am really grateful to you. You have been so kind and generous responding threads/discussions on this excellent forum. You are an amazing resource. Stay Blessed
0
Categories
- All Categories
- 107 Developer Announcements
- 53 Articles
- 104 General Questions
- 141 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 898 Cloud Fax and Notifications
- 76 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 118 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management