Get filtered data from SSRS RRS feed

  • 问题

  • I'm using ReportViewer control to show server report on web page. I set report parameters with the following code:


    Now I can get the report. In this report, there are columns like userid,company,register date ect.

    My question is how can I get the distinct userid and company to pass them to the other page?


    2011年11月15日 6:04


  • you need  another report for this.

    can't get that from parameters.must be a new sql like :select distinct userid from table.

    family as water
    2011年11月15日 9:36
  • Thank you Stone.

    In my project, there are almost 100  differnt reports which include same column named userid . Is there a easy way to get userid list from report?

    2011年11月15日 10:00