Solved

C#.Net - calling a report using SSRS

Posted on 2011-03-14
3
651 Views
Last Modified: 2012-05-11
I have a created in MS SQL 2005 a report named ODC and it has 1 parameter RN.
I want to be able to programmatically call (in C#.NET) the report using SQL Server Reporting Services (SSRS).
The file should be saved to C:\reports\ and named ODC + the value of RN
Can someone provide me a simple solution
(I am a new programmer to C# using the Express version).
0
Comment
Question by:n2dweb
  • 2
3 Comments
 
LVL 1

Author Comment

by:n2dweb
ID: 35134440
This is a console application. (Not a web app) - thanks
0
 
LVL 13

Accepted Solution

by:
agarwalrahul earned 500 total points
ID: 35135777
0
 
LVL 1

Author Comment

by:n2dweb
ID: 35136337
I have created a project using the code but the web reference does not like:
            RS2005.ReportingService2005 rs;
 If I type RS2005.  then the auto complete points to references
            RS2005.ReportHistorySnapshot;
            RS2005.ReportingService2005Soap
and others. but not to RS2005.ReportingService2005

Please help
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

707 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now