Solved

Reporting Services - Call Report Threw Code

Posted on 2009-04-14
4
725 Views
Last Modified: 2012-05-06
Is there a way that i can call a reporting services report threw asp.net to email out a pdf file of the report.  i know this can be done using the interface, but i want to do it in vb code.  is this possible?

thanks
0
Comment
Question by:Fraser_Admin
  • 2
  • 2
4 Comments
 
LVL 8

Expert Comment

by:OBonio
ID: 24140268
Is this SSRS 2005?  If so, you can use the web services that are installed in the virtual directory to execute reports to various formats.

I'm not sure how it is done with SSRS 2008 as they have removed the dependancy on IIS, so may have removed  the web service support.....
0
 

Author Comment

by:Fraser_Admin
ID: 24140560
no its 2005 but someday maybe 2008  is there a way you can do it in a sp inside sql server.  i could always do it that way.
0
 

Author Comment

by:Fraser_Admin
ID: 24141369
This is what I'm trying to do...

I have a report that i need user/database interaction with.  i want the user to decide when to send out the batch of reports, not a specific schedule (as with subscriptions).

ie. threw sql server is there a way i can store all information in a table and then have the user execute a job which will go threw the table, for each record, generate the pdf report based on the parameters set in the table and send an email with the generated pdf file (based on an email address, which is also stored in the row).

i could do it in asp.net but i really don't understand this web services stuff and am having a hard time getting started with it.  my sqlserver and web ap are on two separate machines so i don't see how to have the web service link to another machine without hard coding the machine name.  also, i can't seem to get my head around how to add a web reference to the web service.

I AM LOST!!!!

Thanks in advance.
0
 
LVL 8

Accepted Solution

by:
OBonio earned 500 total points
ID: 24146063
This may be of interest, though it uses the web service approach.

http://www.codeproject.com/KB/reporting-services/ssrs_pdf.aspx

There may be a way of hacking the Reporting Services database (it has its own DB too) to get it to run a report, but I wouldn't recommend it.  Who knows what it really does under the hood?  Web services is the best approach here as it encapsulates what SSRS is doing.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

932 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

12 Experts available now in Live!

Get 1:1 Help Now