Get filtered data from SSRS

Question

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

reportViewer.ServerReport.SetParameters(ReportParameters)

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?

 

Answer 1

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

Answer 2

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?