sql server reporting services: Conditionally hiding column in matrix -- sql server reporting services

Conditionally hiding column in matrix

davidbr93 NO[at]SPAM yahoo.com
8/31/2004 11:12:10 AM

sql server reporting services:

I have a matrix with the following format

Date
Month RowGroup1 Group2 Amount

I have month in the rows because I want to page on month when
exporting to excel in order to produce a new sheet. This seem to work
ok except for the following.

1. I'm passing in a date range (7/1/2004 - 8/31/2004) When the report
is displayed, I correctly get a report paged by month but the date
column shows all date between 7/1 and 8/31 on both sheets, regardless
of having a value in the amount field. So for July all August dates
are displayed and for July all August values are displayed. Can I
hide dates where the amount is null or missing?

2. When I export to excel the individual sheets are called sheet1,
sheet2... Is there a way to give the name of each sheet the
corresponding month value?

Thanks for your assistance?

Re: Conditionally hiding column in matrix

Chris Hays [MSFT]
8/31/2004 1:12:59 PM

Rather than putting the month in the matrix, put the matrix in a list which
groups by month.

You cannot control the Excel sheet names in the current version.

--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
[quoted text, click to view]