Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Reporting Services - Call Report Threw Code

Posted on 2009-04-14
4
Medium Priority
?
735 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 2000 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

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

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

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

916 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