-- Reporting range limits tests

select * from tbReport with(nolock) where ReportID = 1110

-- TEST with different report limits
update tbReport set DayRangeLimit = null where ReportID = 1110

update tbReport set DayRangeLimit = 5 where ReportID = 1110

update tbReport set DayRangeLimit = 185 where ReportID = 1110

-- TEST with different defaults

select * from tbReportParameter with(nolock) where ReportID = 1110

update tbReportParameter set DefaultValue = null where ReportID = 1110 and ParameterTypeEnum = 137 -- no default > system (14 days)

update tbReportParameter set DefaultValue = 0 where ReportID = 1110 and ParameterTypeEnum = 137 -- Today

update tbReportParameter set DefaultValue = 90 where ReportID = 1110 and ParameterTypeEnum = 137 -- days


-- TEST with different reports too:

