The way I'd personanlly do this is the send that parameter in the query that fills the dataset. So in theory you return only 50% of the data everytime.

Then in the report you have 1 colum for debit and 1 for credit.

Just hide the column you don't need depending on the parameter value.