How to get a list of SSRS schedules for subscriptions

Hi Guys,

below script gives you the list of subscription set on each and every report of SSRS.


use ReportServer

select c.Name,
c.Path,
s.StartDate,
s.NextRunTime,
s.LastRunTime,
s.EndDate,
s.RecurrenceType,
s.LastRunStatus,
s.MinutesInterval,
s.DaysInterval,
s.WeeksInterval,
s.DaysOfWeek,
s.DaysOfMonth,
s.[Month],
s.MonthlyWeek
from dbo.catalog c with (nolock)
inner join dbo.ReportSchedule rs
on rs.ReportID = c.ItemID
inner join dbo.Schedule s with (nolock)
on rs.ScheduleID = s.ScheduleID
order by s.LastRunTime desc 

If you find any difficulty then reply on the comment box.
I will revert as soon as possible.

Thanks for the reading.

Replace Zero with Blank or Dash in SSRS

Here is the solution to replace zero with the Blank(' ') or Dash(-)

select textbox and check the properties on right side pan as shown in image.

for blank use below format

''0.00;(''0.00);''

for dash use below format

''0.00;(''0.00);'-'