Jasper report Ledger Printing

My database struture

CREATE TABLE "AccountMaster" ("AccountID" INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL  UNIQUE , "AccountName" VARCHAR, "AccountType" VARCHAR, "AccountStatus" VARCHAR)

CREATE TABLE "TransactionItems" ("ItemID" INTEGER PRIMARY KEY  NOT NULL ,"AccountID" INTEGER,"TransactionID" INTEGER,"ItemType" VARCHAR,"CreditAmount" INTEGER,"DebitAmount" INTEGER,"msg1" VARCHAR,"msg2" VARCHAR)

CREATE TABLE "TransactionMaster" ("TransactionID" INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL  UNIQUE , "TransactionDate" VARCHAR NOT NULL , "Naration" VARCHAR)

Now the issue is that Basically as user is entering the data , there can be multiple accounts being debited and credited in a same transaction so when there is a transaction first a record with date n naration is entered n transaction id is gernated

Now all accounts debit n credit involved in that transaction is saved in transaction table with amount n type n transid

Now issue is i need to prepare a ledger which has to show both credit n debit that too in jasper report but i m not getting how to do it . Please help me ..

Backend= Sqlite