... ,a.[Status]
,a.[ByteCount]
,a.[RowCount]
FROM [ReportServer].[dbo].[ExecutionLog] a
INNER JOIN [ReportServer].[dbo].[Catalog] b
ON a.ReportID = b.ItemID
The Top 5 Most ...
... do this:
On the server, open the XML file: C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\RsReportServer.config
Set the recycle time to 0: 0
Restart the ...
... following image:
Cycle through each static object and set FixedData to False (ensure all items are set to false or it will error):
Save and test on the ReportServer.
Background:
If you ...
...
Analyzing the report through the ReportServer databases (internal auditing) only showed how long the SQL query would take to recover the data and present it in a report, which would average about ...
... to the ReportServer.
Hover the mouse cursor over it and click on the dropdown arrow to its right
Select "Manage" in the dropdown menu
Select "Data Sources" in the left menu
Specify a "custom data ...
... work on your reporting server as well. I'm using the database "ReportServer".
select * from
(
SELECT TOP 1
c.[Name] AS [ReportName]
, e.[ReportID] AS [ReportID]
, e.[TimeStart] AS [TimeStamp]
, ...
... enough and always saying 0 seconds was just confusing the end-user...
Workaround #1
Although I'm convinced of a solution considering the ReportServer database will be able to tell you how many ...
... the report (default is True)
http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render &rc:Toolbar=False
To hide just the parameters (default is True) ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.