Solved

Reporting Services - Call Report Threw Code

Posted on 2009-04-14
4
722 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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
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…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

708 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

17 Experts available now in Live!

Get 1:1 Help Now