Skip to Content
0
Former Member
Apr 23, 2009 at 01:21 PM

Exact formulae to show columns as per the parameters in subreport

19 Views

Hi All,

I have a subreport which has 4 columns.

First column gives me the no of bats sold in year 2000

second column gives me the no of bats sold in year 2001

Third column gives me the no of bats sold in year 2002

And fourth column gives me the number of bats tht are in production that means they are not sold in any year.

For this report I have a patameter on year in my main report, after selecting this the user will get info on how many bats were sold on each year. Add to this the user also want to display the bats that are in production.

If i select 2001 in my parameter I will get the bats sold in 2001 and this will not give me anything for the fourth column and so on. But I want to display the bats sold and the bats in production all the time.

Can anyone suggest me what to do in this situation.

Thanks

Robinn