?
Solved

asp.net reportviewer stored procedure

Posted on 2013-12-11
7
Medium Priority
?
841 Views
Last Modified: 2014-02-16
Can somebody please tell me step by step how to add a report service project to my asp.net solution. The report should be based on the results of my stored procedure so will have parameters that it passes and then displays the result set.

Seems like a straightforward request but I can't find anything on internet which specifically deals with this.

Using VS 2010 asp.net c# and sql server express 2008 R2
0
Comment
Question by:Paulmc999
[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
  • 4
  • 2
7 Comments
 
LVL 40

Expert Comment

by:lcohan
ID: 39712429
SSRS reports are available as an URL on the report server. You add reports to an asp.net application by hyper-linking to them and please see more details here:

http://codebetter.com/petervanooijen/2005/11/15/using-sql-reporting-services-in-an-asp-net-application-with-some-notes-on-report-parameters/
0
 
LVL 2

Author Comment

by:Paulmc999
ID: 39712825
Is there a more recent article and one that displays the screenshots...they will not display.

I am awware of the report server route but can you tell me categorical that what I want to do is impossible ie call a stored procedure and populate the reportviewer with the results??
0
 
LVL 9

Expert Comment

by:QuinnDex
ID: 39713325
In the tableadapter configuration wizard, choose the commande type : Use existing stored procedures (for more information go to the MSDN : TableAdapter Configuration Wizard
0
Tutorials alone can't teach real engineering

So we built better training tools.

-Hands-on Labs
-Instructor Mentoring
-Scenario-Based Tests
-Dedicated Cloud Servers

All at your fingertips. What are you waiting for?

 
LVL 2

Author Comment

by:Paulmc999
ID: 39713533
I already found that myself but it doesn't show me how to actually use the tableadapter and how it connects with reportviewer. Anybody got a step by step approach?
0
 
LVL 9

Expert Comment

by:QuinnDex
ID: 39714504
sorry at work at the moment so have tried to find you something you can see, try this

http://www.youtube.com/watch?v=rvikG8evRfI
0
 
LVL 2

Accepted Solution

by:
Paulmc999 earned 0 total points
ID: 39849747
OK Guys I found this book "Clientside Reporting in VS c#" by Apress. Its old but it helped me to do this.
0
 
LVL 2

Author Closing Comment

by:Paulmc999
ID: 39862447
It was the step by step I requested and although a bit out of date I was able to figure it out.
0

Featured Post

Independent Software Vendors: 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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

764 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