Solved

Reporting Services - Call Report Threw Code

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how the fundamental information of how to create a table.

740 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