Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 YTD and multivalued Time Parameter SSRS 2005

Author  Topic 

apocalyptica
Starting Member

3 Posts

Posted - 2009-02-11 : 03:28:49
Hello,

I hope anyone can help me, because I didn't find anywhere a solution.

I want to include a YTD value into a textbox of a table. I have a calculated member:

SUM(YTD([Datum].[Kalenderjahr - Monat].CurrentMember), [Measures].[Gesamt (Ist)])

In the Data tab I get the correct figures, but not in the report. The Field expression is:

Sum(Fields!YTD.Value)

I get the correct figures only if I choose just one month via Time parameter. When I choose more than one month, I get strange figures.

Does anyone have a hint?

apo
   

- Advertisement -