Solved

Reporting Services - Call Report Threw Code

Posted on 2009-04-14
4
731 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

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…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

624 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