sql server reporting services: Matrix with totals at the top and a empty row -- sql server reporting services

You're in the

sql server reporting services

group:

Matrix with totals at the top and a empty row

Reg
9/13/2004 6:21:03 PM

sql server reporting services:

Hi,

I would like to have the following,

field 1 field 2 field 3
---------------------------------------------
empty row
total 1000 1000 1000
empty row
field 4 2000 2000 2000
field 5 8000 8000 8000

Any advice on how to do that?

Re: Matrix with totals at the top and a empty row

Lev Semenets [MSFT]
9/13/2004 9:28:01 PM

Set Subtotal position to "Before" and use top and bottom padding to add
space around subtotal

--
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Re: Matrix with totals at the top and a empty row

Reg
9/14/2004 8:28:39 AM

Thanks this works.

Now just one more problem. If we use the example below, on the column
grouping(Contains Months) have an iif to check if the date is before a
parameter passed to the report. I then use either one or the other field
from the database depending on whether it is true or false.

When I then add the total it would give me the wrong value, not really sure
which value it is giving me, but it always one value from the column and not
a calculated value.

[quoted text, click to view]

Re: Matrix with totals at the top and a empty row

Lev Semenets [MSFT]
9/14/2004 9:47:31 PM

Would you like to create simple report that exhibits this problem and e-mail
it to me?

Thanks,
Lev
--
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn