SSRS Indicator decimal value and states

We have getting issue sometime with SSRS Indicators, 

while setting numerical logic between below 0 and above 0 some decimal value skipped by the indicators (Showing blank indicator instead of Yellow Circle).

Solution:

below expression will help to make it visible even if the decimal value starts from 0.00001.

Before: 

Red Indicator Start : -1 End : -99999

Yellow Indicator Start: 0 End 0

Green Indicator Start : 1 End : 99999

After: 

Red Indicator Start : -1E-06 End : -99999

Yellow Indicator Start: 0 End 0

Green Indicator Start : 1E-05 End : 99999

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.