Prev: FIND equivalent in an SRS Expression
Next: can't hit 2008 db with ssrs2005?
From: Bink on 8 Apr 2010 14:14
In the query below, I can sucessfully return different recordsets based on a
parameter. The problem is that I need to change the "Month, Month_Name" and
"Quarter, Quarter_Name" headers to something generic like "vDate, vDate_Name"
.... Any help would be appreciated.

SELECT
NON EMPTY {[Measures].[Clm Amnt], [Measures].[Denial Detail Count]} ON
COLUMNS,
NON
EMPTY{ORDER({(iif(@TimeSlice="Quarter",[DenialPostongTimeData].[Quarter].[Quarter],[DenialPostongTimeData].[Month].[Month])
AS [Date],iif(@TimeSlice="Quarter",[DenialPostongTimeData].[Quarter
Date].[Quarter Date],[DenialPostongTimeData].[Month_Date].[Month_Date]) AS
[Date_Name])},iif(@TimeSlice="Quarter",[DenialPostongTimeData].[Quarter
Date].MEMBERVALUE,[DenialPostongTimeData].[Month_Date].MEMBERVALUE),BDESC)}
ON ROWS
FROM [Denial Detail Analysis]
 | 
Pages: 1
Prev: FIND equivalent in an SRS Expression
Next: can't hit 2008 db with ssrs2005?