Dwayne Starkey
Top achievements
Rank 1
Rank 1
Dwayne Starkey
asked on 04 May 2010, 02:21 PM
I am trying to build a report that can be used for (lets says) 50 clients to be used via the web. How can I get the report to auto filter the results by using a session"id"?
For xample : If Client 1 logs in and runs the report, I only want Client 1 information to show.
I cannot seem to find any documentation on this, can someone point me in the right direct or would someone have directions on how to implement this?
I have tried adding the session varible below, I also added a parameter from the front end that was named the same but still no success.
For xample : If Client 1 logs in and runs the report, I only want Client 1 information to show.
I cannot seem to find any documentation on this, can someone point me in the right direct or would someone have directions on how to implement this?
I have tried adding the session varible below, I also added a parameter from the front end that was named the same but still no success.
| rpt = New ClassReports.PurchaseItemstoDate |
| rpt.ReportParameters(0).Value = Session("role") |
| ReportViewer1.Report = rpt |
1 Answer, 1 is accepted
0
Dwayne Starkey
Top achievements
Rank 1
Rank 1
answered on 04 May 2010, 05:07 PM
Figured it out.... The reporting parameters were not setup correctly within the report. Once this was setup correctly (= Parameters.ID.Value) my posted code worked fine.