SQL Server Performance

Passing Parameters to Report Models (SQL 2005)

Discussion in 'SQL Server Reporting Services' started by bwalkertn, Jan 16, 2006.

  1. bwalkertn New Member

    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
  2. mkmathi New Member

    Hi

    You have to add parameter to datasoure using @ symbol like (WHERE fil.gen=@GEN AND fil.cnt=@CNT)

    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

  3. bwalkertn New Member

    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.

Share This Page