[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 897
  • Last Modified:

asp.net reportviewer stored procedure

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
Paulmc999
Asked:
Paulmc999
  • 4
  • 2
1 Solution
 
lcohanDatabase AnalystCommented:
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
 
Paulmc999Author Commented:
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
 
QuinnDexCommented:
In the tableadapter configuration wizard, choose the commande type : Use existing stored procedures (for more information go to the MSDN : TableAdapter Configuration Wizard
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
Paulmc999Author Commented:
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
 
QuinnDexCommented:
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
 
Paulmc999Author Commented:
OK Guys I found this book "Clientside Reporting in VS c#" by Apress. Its old but it helped me to do this.
0
 
Paulmc999Author Commented:
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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now