SQL Server Performance

Runtime problem with RS

Discussion in 'SQL Server Reporting Services' started by applearner, Jun 23, 2004.

  1. applearner New Member

    HI

    I am new to RS. I want to pass a select statement to RS from ASP page at runtime. I am working on search page in ASP. I want to show a report, depands on search creteria. In the design time I don't know what are the columns are going to show.
  2. BabuYb New Member

    1. Create a parameter (ex myQuery) with default value that would return all fixed columns and dynamic columns named something like Col1, Col2 ... (Use data-field AS Col1)

    2. In the data tab type the expression = Parameter!myQuery.

    3. You should now be able to all the fields returned by the default parameter value.

    4. The rest should be easy from ASP.

Share This Page