sql server reporting services: Accessing old reports -- sql server reporting services

You're in the

sql server reporting services

group:

Accessing old reports

GaryDean
6/17/2006 5:17:02 PM

sql server reporting services:

Once I get reports archived in History, it there a way I can get a pointer
of some kind to the report so I can store it in a database to facilitate
subsequent retrieval?

--
Regards,
Gary Blakely

RE: Accessing old reports

weilu NO[at]SPAM online.microsoft.com
6/19/2006 5:43:14 AM

Hi Gary,

Thank you for your posting!

From your description, my understanding of this issue is: You want to view
the Report History. If I misunderstood your concern, please feel free to
let me know.

You could access the report history via URL:

For example:
http://server/reportserver?/SampleReports/Company
Sales&rs:Snapshot=2003-04-07T13:40:02

Also, you could manage the reporting history in the Report Manager and SQL
Management Studio (If you are using SQL Reporting Services 2005.)

Here is the article for your reference:

Managing Report History
http://msdn2.microsoft.com/en-us/library/ms155849.aspx

Hope this will be helpful!

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Re: Accessing old reports

GaryDean
6/19/2006 8:59:02 AM

Wei Lu,
Thanks for the response and that article will do me a lot of good.

However, I don't think we want the users accessing reporting services
directly. I was hoping to be able to have a "pointer" to a snapshot in
history and store that pointer in a database where it is related to other
data. the user would then be able to get old reports via the metaphor of
our application - they wouldn't even be aware of Reporting Services.

I have a wrox book on ssrs that says I can get a snapshot report by
specifying:
http://server/virtualroot?[/pathinfo]&rs:snapshot=snapshotid
where snapshotid is the time and date stamp of when the report was created.
But the book stops there and I can't imagine getting a time stamp back that
would match the millisecond the report was created.

Am I making sense?

--
Regards,
Gary Blakely
[quoted text, click to view]

Re: Accessing old reports

weilu NO[at]SPAM online.microsoft.com
6/20/2006 12:00:00 AM

Hi Gary,

Thank you for your update.

The information you get from the book is right. In my post, I provide the
method of Accessing the snapshot via URL, it's what exactly the book
refered.

My understanding of your request is, you want to use the URL in your
application and you want to get all the Snapshots which your report
related. If I misunderstood your concern, please feel free to let me know.

I assume you are using Reporting Services 2005.

Here is a sample query text to get the Snapshots and combine it to an URL
from the Report Server database:

USE ReportServer
GO

SELECT 'http://localhost/reportserver?'+C.Path +
'&rs:Snapshot='+CONVERT(nvarchar(50),H.SnapshotDate,126),

C.Name,H.SnapshotDataID,H.SnapshotDate FROM dbo.Catalog C inner join
dbo.History H

on C.ItemID = H.ReportID Where C.Name = '<YOUR REPORT Name>'

Hope this will be helpful!

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Re: Accessing old reports

GaryDean
6/20/2006 8:23:22 AM

Well, I'll play around with that but...

I know I can retrieve a history report if I know the EXACT timestamp. I'm
worried that the time between when I redirected to a url to produce the
report and the time when SSRS actually produced the report might be a couple
of milliseconds off and therefore my timestamp would not match that of the
report.
Gary

[quoted text, click to view]

Re: Accessing old reports

weilu NO[at]SPAM online.microsoft.com
6/21/2006 12:00:00 AM

Hi Gary,

Thank you for the update.

I would like to know how achieve the report. Once you create a report
snapshot, you could use the statement I provided in the previous post to
query it from the database.

Would you please post the method you use to achieve the report?

Thank you!

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Re: Accessing old reports

GaryDean
6/21/2006 4:51:51 PM

Wei,
I'm new to SSRS (always used Crystal before) and I have just managed to
produce it via url. So, I don't have a method yet where I archive the
report. (I have a new post that is going in that direction but I'm having
permissions problems there).

The docs and the wrox book I have are good for showing how to design reports
but, IMHO, they are lacking in management and rendering.

--
Regards,
Gary Blakely
[quoted text, click to view]

Re: Accessing old reports

weilu NO[at]SPAM online.microsoft.com
6/22/2006 8:03:32 AM

Hi Gary,

I think the SQL Books Online is a great material for you to start SQL
Reporting Services.

To create the Report Snapshot, you need to do the following:

1. Access report manager via url:

http://servername/reports

2. Navigate to the report you want to achive.

3. In the History page, click New Snapshot button.

Here is the article for your reference.

Creating, Modifying, and Deleting Snapshots in Report History
http://msdn2.microsoft.com/en-us/library/ms156325.aspx

How to: Create and Delete History Snapshots (Management Studio)
http://msdn2.microsoft.com/en-us/library/ms156360.aspx

How to: Create, View, and Delete History Snapshots (Report Manager)
http://msdn2.microsoft.com/en-us/library/ms156310.aspx

Hope this information will be helpful for you!

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Re: Accessing old reports

TinMan
6/22/2006 9:17:10 AM

Wei,
thanks again for all your help - please stay with me on this...

When I hit the new snapshot button for my report I get an error dialog that
says:
"Report history may not be created because the credentials used to run the
report are not stored, the report is using user-defined parameter values,
defalut report parameter values are mising, or if a linked report, the link
is no longer valid."

I think I may not be communicating clearly on this thread thus far....
I want a report added to history whenever I render it (with whatever
parameters I used at the time) then I need to get the "key" to the report so
I can re-render it, programatically, at any later time.

My problem is that when I render a report, programatically, I don't get back
any key. In other words I don't get back the snapshot ID. It's like adding
a record to a database and not getting the key back so you can never find
the record you added.

(in case this turns out to be impossible, I have another thread where I am
trying to render to a file and then I will create my own history system but
I'm having permission problems there.)
I'll play with that sql statment next.

Thanks,
Gary

[quoted text, click to view]

Re: Accessing old reports

weilu NO[at]SPAM online.microsoft.com
6/23/2006 12:00:00 AM

Hi Gary,

Thank you for the response.

I would like to know how your render the report programatically. Render the
report does not save the report in the history. The report history only
stored the snapshot you created.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Re: Accessing old reports

GaryDean
6/23/2006 8:52:01 AM

I'm rendering it via response.redirect as follows:
string URLString =
"http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fCMReports%Buyer&rs:Format=PDF&rs:Command=Render&campaignID=";
URLString += ddlCampaigns.SelectedValue;
URLString += "&campaignVersionID=";
URLString += ddlCamVersion.SelectedValue;
//URLString += "&TCR=T";
URLString += "&weekdate=";
URLString += weekDate;
URLString += "&buyerName=";
URLString += buyerName;
URLString += "&brIdentifier=";
URLString += brIdentifier;
URLString += "&nthWeek=";
URLString += nthWeek;
Response.Redirect(URLString);
The report prints just fine.
--
Regards,
Gary Blakely
[quoted text, click to view]

Re: Accessing old reports

weilu NO[at]SPAM online.microsoft.com
6/26/2006 12:00:00 AM

Hi Gary,

Thank you for your update.

As I mentioned in the previous post, when you render a report, reporting
services does not store the exection result in any place.

I think you need to achieve the PDF file by your self and you need to build
up a custom system to manage your report.

Also, I think you could consider the Reporting Services Web Services. The
Web Services provide a class libarary to get the information from the
Reporting Services.

Introducing the Report Server Web Service
http://msdn2.microsoft.com/en-us/library/ms154697(d=ide).aspx

Hope this will be helpful!

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn