Report Settings in SSRS - How can we make this setting [Do not timeout Report] be selected in All reports
-
Please see attached
I have over 600 reports and I am looking for a way to make this setting selected for all reports ?
Anyway I can do it via T-SQL ? -
From the Report Manager URL, go to Site Settings, select General on the left (that would be the default).
Towards the lower part of the page on the right, there is the Report Timeout settings where you can select do not timeout report.Sue
- Sue_H - Friday, January 13, 2017 11:18 AM
Sue:
This is the HOME screen I don't see anything that says "SITE SETTINGS"
- mw112009 - Friday, January 13, 2017 11:34 AMSue_H - Friday, January 13, 2017 11:18 AM
Sue:
This is the HOME screen I don't see anything that says "SITE SETTINGS"Permissions. Right click on your browser and Run As Administrator to open the Report Manager URL
Sue
- Sue_H - Friday, January 13, 2017 11:38 AMmw112009 - Friday, January 13, 2017 11:34 AMSue_H - Friday, January 13, 2017 11:18 AM
Sue:
This is the HOME screen I don't see anything that says "SITE SETTINGS"Permissions. Right click on your browser and Run As Administrator to open the Report Manager URL
Sue
Sue:
The picture below explains... I ran as the Administrator.... So Internet Explorer opens and I don't see anything other than what I saw before ( I mean I don't see "Site Settings" ) -
And are you an administrator on that Report Server? Only administrators will see Site Settings. Here is the MS documentation on this - copy and paste as it's not letting me insert a link right now for some reason:
https://msdn.microsoft.com/en-us/library/ms181194(v=sql.110).aspx
Sue - Sue_H - Friday, January 13, 2017 12:29 PM
Worked.. They added me as an administrator ..... Thanks ( See pic below )
One more question:
When I open a report and go to subscriptions I do not see the users subscriptions. I believe this is a security issue as well.
Hope you can help -
That is all you will see from Report Manager for subscriptions so it's not a security issue on the report site.
If you want to view subscriptions, you need to query the tables in the ReportServer database on whatever server it points to. That would be listed in the Reporting Services Configuration if you don't know which server.
In the ReportServer database, there is a subscription table. That's what you want to view all or others subscriptions. And the it depends on what you want to see. Just to get a basic list you can use something like this:SELECT c.UserName,b.SubscriptionID,a.ItemID ReportID,
a.Path,a.Name ReportName
FROM Subscriptions b
INNER JOIN Catalog a
on a.ItemID=b.Report_OID
INNER JOIN Users c
on b.OwnerID=c.UserIDIf you need a bit more information about the subscription details, you could use something like this:
SELECT cat.path AS ReportServerPath,
own.username AS SubscriptionCreatedBy,
jb.date_created AS SubscriptionCreatedOn,
mod.username AS SubscriptionModifiedBy,
sub.ModifiedDate AS SubscriptionModifiedOn,
sub.Description AS SubscriptionDescription,
sub.EventType AS SubscriptionType,
CASE
WHEN PATINDEX('%Recurrence%', sub.MatchData) > 0THEN 'Recurring'
ELSE 'One Off'
END AS ScheduleType,
sch.LastRunTime AS SubscriptionLastRun
FROM msdb.dbo.sysjobs jb
INNER JOIN dbo.Schedule sch
ON jb.name = CAST(sch.scheduleid AS VARCHAR(40))
INNER JOIN dbo.Subscriptions sub
ON sch.eventdata = sub.subscriptionid
INNER JOIN dbo.Catalog cat
ON sub.Report_OID = cat.ItemID
INNER JOIN dbo.Users own
ON sub.OwnerID = own.UserID
INNER JOIN dbo.Users mod
ON sub.ModifiedByID = mod.UserIDThat should get you started.
Sue
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply