summary including to many values

[jchev]

I'm creating a balance sheet in Crystal 2008. My source table has account, yr, credit1 and debit1(the 1s indicating the period).
I want to show the dollars for each period so I created a formula 'debit1-credit1=balance1'. I also want a summary for all banking accounts in 2012.
I tried to do this by adding suppression logic to the details 'if {?My Parameter}={GL_DATA.GL-Year}THEN FALSE ELSE TRUE' then I inserted a summary for balance1. The suppression worked but the summary added all balances for all years instead of just the one year.
Does anyone know how to prevent this?

Jen

 

[pmax9999]

Hi Jen

The problem here is that simply suppressing records will not exclude them from totals.

If the report is only for the one year, you could limit the data to just that year by adding the following to your Record Selection:

{GL_DATA.GL-Year} = {?My Parameter}

If for some reason the report needs to cover more than than 1 year, amend your {@balance} formula as follows:

If	{GL_DATA.GL-Year} = {?My Parameter}
Then	debit1 - credit1

where debit1 and credit1 are replaced by your actual fileds.

Hope this helps.
Pete.

 

[jchev]

Thank you Pete, that worked