This is a migrated thread and some comments may be shown as answers.

How to Implement web sessions into Reporting

1 Answer 33 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Dwayne Starkey
Top achievements
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.

 rpt = New ClassReports.PurchaseItemstoDate  
                rpt.ReportParameters(0).Value = Session("role")  
                ReportViewer1.Report = rpt 

1 Answer, 1 is accepted

Sort by
0
Dwayne Starkey
Top achievements
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.
Tags
General Discussions
Asked by
Dwayne Starkey
Top achievements
Rank 1
Answers by
Dwayne Starkey
Top achievements
Rank 1
Share this question
or