Solved

Populate Report Viewer with Values from a Web Page with C#

Posted on 2012-04-03
3
333 Views
Last Modified: 2012-06-27
I have a database table with the following fields:
UserID
FirstName
LastName
City
State
Zip
Gender
Hobby

I have a web page of which this table is the data source with on the fields:
Gender
Hobby
UserID

I want to use the values on the web page to populate report viewer with all the records in the table where gender, hobby and UserID equals the values on the web page.
The report can populate with either one, two or all three of the values.

Right now these values are in one session variable (oUserSources) that is not working.

Can someone help me with this?

Thanks!
0
Comment
Question by:jordanhelen
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
ID: 37804790
You'll need to create those three report parameters on your report, then pass in the values as applicable.  You report's dataset will need to take those parameters into account.

More info: http://msdn.microsoft.com/en-us/library/ms155917.aspx

Setting the values in ASP.NET: http://stackoverflow.com/questions/3155215/how-can-i-pass-a-parameter-from-asp-net-to-ssrs-report
0
 

Author Comment

by:jordanhelen
ID: 37811877
No comments.
0
 

Author Comment

by:jordanhelen
ID: 37811878
No comments.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question