How to view multi records from one table in crystal reports

See more:

VB

SQL

CrystalReports

I am making an accounting based erp software based on ms sql. now I am working on reports and in reports I am working on ledger.

What I am doing is, I wrote a insert code in every accounts module which update my ledger database with all entries and in crystal reports I am filtering it.

Now the issue is I have some entries as debit and some credit but in crystal reports i put parameter for debit account and it showing me debit entries only...because I can not add more then one parameter I guess.

Now what I need is, is there any possibility that I can view all records related to my search suppose I want to see all entries only related to CASH IN HAND and it show me all entries of it from ledger table .

Please guide me with this . that will be a great help

Tried nothing special

What I have tried:

I tried nothing except i am able to view the debit entries only of specific account by below code

{ledgerdetails.Accountnamedr} = {?tran}