SSRS / SSAS Params Passing thru DOTNET

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)

SSRS / SSAS Params Passing thru DOTNET

Author

Topic

pavan_crm
Starting Member

7 Posts

Posted - 2009-02-26 : 01:18:17

Hi All

I've got a SSRS report that has been created over an MDX query. The MDX query looks some thing like this


SELECT NON EMPTY { [Measures].[Leaves Denied], [Measures].[Leaves Appr], [Measures].[Leaves] } ON COLUMNS, 
 NON EMPTY { ([Department].[Department].[Department].ALLMEMBERS * [Reject Reason].[Reject Reason].[Reject Reason].ALLMEMBERS * [Employee].[Employee].[Location].ALLMEMBERS * [Employee].[Employee Region].[Parent Region Code].ALLMEMBERS * [Employee Type].[EmployeeType].[Employee Type].ALLMEMBERS ) } 
 DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS 
 FROM ( SELECT ( STRTOSET(@EmployeeEmployee, CONSTRAINED) ) ON COLUMNS FROM [EMP]) 
 CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

Now I've call the report from my .NET application. However, when passsing parameters for the @EmployeeEmployee it says parameter not passed. However, when debugging I've seen that the param name is retrieved at the execution and the param value has been set and assing to the RS serveive variable

But still i get the error that the param @EmployeeEmployee is not assigned.

What is that I'm doing wrong?

Pls. Help

Thnx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources