Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Retrieve history snapshot with soap api - sql2008

 
   Database Help (Home) -> Programming RSS
Next:  SQL 2000 Agent running but not working Error 1425..  
Author Message
Scott

External


Since: Oct 07, 2008
Posts: 5



(Msg. 1) Posted: Thu Mar 26, 2009 2:00 pm
Post subject: Retrieve history snapshot with soap api - sql2008
Archived from groups: microsoft>public>sqlserver>programming (more info?)

I have an application the will retrieve and render reports using the soap
api. This all works fine. I can also get a list of history snapshots.
However, there are no methods available to load and render history snapshots.
I have tried to go directly to the Reporting Services database for the
snapshots but have been unable to get the data. I believe they are in the
Segment table Content column. I can see the actual XML report definition
(UTF8 encoding) but cannot determine the correct ChunkType for the compiled
report. Also, looking at other ChunkType data I can't determine how to
convert what is in the database to a report I can render or otherwise return
to the client.

Has anyone been successful at getting history snapshots programmatically
rather than in the browser. I don't understand why Microsoft does not let us
get the snapshots through the SOAP API.
--
Scott Norberg

 >> Stay informed about: Retrieve history snapshot with soap api - sql2008 
Back to top
Login to vote
Charles Wang [MSFT]

External


Since: Apr 18, 2008
Posts: 268



(Msg. 2) Posted: Fri Mar 27, 2009 1:25 am
Post subject: RE: Retrieve history snapshot with soap api - sql2008 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi Scott,
Welcome to Microsoft MSDN Managed Newsgroup Services.

I understand that you would like to use SOAP API to load and render history
snapshot.
If I have misunderstood, please let me know.

I think that the methods ReportExecutionService.LoadReport and
ReportExecutionService.Render should help. Please refer to the following
articles:
ReportExecutionService.LoadReport Method
http://msdn.microsoft.com/en-us/library/microsoft.wssux.reportingservicesweb
service.rsexecutionservice2005.reportexecutionservice.loadreport(SQL.90).asp
x
ReportExecutionService.Render Method
http://msdn.microsoft.com/en-us/library/microsoft.wssux.reportingservicesweb
service.rsexecutionservice2005.reportexecutionservice.render(SQL.90).aspx

Hope this helps. Please do not hesitate to let me know if you have any
other questions or concerns.

Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg.RemoveThis@microsoft.com.
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial

response from the community or a Microsoft Support Engineer within 2
business day is

acceptable. Please note that each follow up response may take approximately
2 business days

as the support professional working with you may need further investigation
to reach the

most efficient resolution. The offering is not appropriate for situations
that require

urgent, real-time or phone-based interactions. Issues of this nature are
best handled

working with a dedicated Microsoft Support Engineer by contacting Microsoft
Customer

Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx.
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

 >> Stay informed about: Retrieve history snapshot with soap api - sql2008 
Back to top
Login to vote
Charles Wang [MSFT]

External


Since: Apr 18, 2008
Posts: 268



(Msg. 3) Posted: Thu Apr 02, 2009 4:25 am
Post subject: RE: Retrieve history snapshot with soap api - sql2008 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Based on Scott's email response to me, I would like to clarify Scott's
resolution to the community on this issue. Scott was using .Net 3.5 and
using a Service Reference vs. a Web Reference. When using the Service
Reference you must use ReportExecutionServiceSoapClient rather than
ReportExecutionService and it does not have a LoadReport(reportPath,
historyID) method.

Here is how Scott solved the problem:
ReportExecutionServiceSoapClient rs = new
ReportExecutionServiceSoapClient();
loadRequest = new LoadReport2Request(trustHeader, reportName, historyID);
loadResponse = new LoadReport2Response(execHeader, serverInfoHeader,
execInfo);
loadResponse = rs.LoadReport2(loadRequest);

Thank you Scott for sharing your resolution with us.

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg.RemoveThis@microsoft.com.
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
 >> Stay informed about: Retrieve history snapshot with soap api - sql2008 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Sql2008 HierarchyID - Hi all... just a quick question for those who are lucky enough to be playing around with Sql2008 yet... The new HierarchyID datatype, will this datatype automatically prevent the possibility of endless recursion? That is, will it prevent a node in the...

History of data for documents - Hello, I have following situation: CREATE TABLE [dbo].[Address] ( <font color=purple> ; [Id] uniqueidentifier ROWGUIDCOL NOT NULL ,</font> <font color=purple> ; [CityId] [uniqueidentifier] NOT NULL ,</font> &lt...

table modification history - Hi, what is the command to see who changed/modified a table/sp last? any historial modification trail command? Thansk

Relational "history," ala, data-audit trail - Long story short: small company, 1 technical called upon to perform several roles. I've created a web-site allowing users to edit/insert/delete records. There are 8 tables involved here. The DB is relational. I have the task now of creating a site that..

Selecting job history information from sysjobhistory in msdb - Hi all, using SQL 2000 When selecting "message" column from "sysjobhistory" table, doesn't contain the entire error message compared to the job history option, from right clicking on a certain job under SQL Server Agent - Jobs. For...
   Database Help (Home) -> Programming All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]