Passing Parameters to Report Models (SQL 2005) | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Passing Parameters to Report Models (SQL 2005)

I am trying to create an Ad Hoc Report Model in SQL Report Services 2005. I need to pass a parameter to the data source for the report model via a URL. I have been able to do this in a report without a problem but can’t seem to find how to set the data source for the report model to accept a parameter. MSDN talks about Paramater Objects in Model Designer but doesn’t say where to go to set these values. Any ideas would be helpful. Thanks Bill
Hi You have to add parameter to datasoure using @ symbol like (WHERE [email protected] AND [email protected]) To assign report parameter values to Datasource prarameter goto Dataset — Edit Mode —> Parameteres Name value
@GEN(datasource Parameter) =Parameters!GEN.Value(Report Parameter)
Thanks & Regards
Mathivanan K
Great work may have to pass through these stages – ridicule, opposition, and then acceptance. Each man who thinks ahead of his time will probably be greatly misunderstood.- vivekananda
Not sure I follow this – when you create a report model project (via the BI interface) you first create a datasource, then a data source view. In the data source view you can create a query for a table in the view but it will not allow you to add a dynamic parameter.
]]>