SSRS schedule details

SSRS Subscription

          The Report server database will store the SSRS schedule information. This database has the complete information about the report scheduled and its related information like the job through which the report got invoked. The status of the Job and when it got executed. This information is helpful to track the SSRS Report subscription information. 
USE ReportServer
RC.Name AS ReportName
, RS.LastStatus
, RS.LastRunTime
, RS.[Description]
ReportServer..[Catalog] RC
JOIN ReportServer..Subscriptions RS ON RC.ItemID = RS.Report_OID
JOIN ReportServer..ReportSchedule RSS ON RC.ItemID = RSS.ReportID
AND RSS.SubscriptionID = RS.SubscriptionID
SSRS schedule details was last modified: October 1st, 2017 by Justin Antony

How to pass the SSRS report parameter through URL ?

SSRS report parameter through URL

http:///ReportServer/Pages/ReportViewer.aspx?%2f%2f%2fReportName;rs:Command=Render&Parameter=<Parameter Value>

— Note it is ReportServer and not reports.

How to pass the SSRS report parameter through URL ? was last modified: February 21st, 2017 by Justin Antony