Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Reporting Services / April 2005

Tip: Looking for answers? Try searching our database.

When is snapshot history created?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bassist695 - 29 Apr 2005 18:45 GMT
In the History section of a report (in Report Manager), assuming the
report is run from a snapshot and the server is configured to store an
unlimited number, at what point do these appear in the History?

I have several reports that, even though they're run from a snapshot,
they say "There are no items to show in this view. Click Help for more
information about this page. "

I have another report, however, that is configured to create a new
snapshot every hour. I see its snapshot history.

Is snapshot history created only if more than one snapshot has been
created?

Thanks,
Mike
Daniel Reib \(MSFT\) - 30 Apr 2005 03:44 GMT
There is a checkbox on the history subtab on the Properties tab of the
report that will create a history snapshot everytime a report snapshot is
created.  Make sure that this is checked and you should start seeing history
snapshots created.

You can create history snapshots for any report, even if it is set to live
execution.  From this same tab just set up a schedule and a history snapshot
will be created everytime the schedule fires.

Signature

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

> In the History section of a report (in Report Manager), assuming the
> report is run from a snapshot and the server is configured to store an
[quoted text clipped - 12 lines]
> Thanks,
> Mike
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.