Hi, I am trying to schedule a report from Report Manager. What SSRS does is, it creates a job with the help of the SQL Agent and schedules it to the respective date. The dates are calculated as per the server local time. Report server has a table named Schedule which has an entry for the report and the...

Hi, I am using SSRS interface to create and schedule a report. The report parameters are as below... Start Date: 01/03/2008 (dd/mm/yyyy) End Date: 12/12/2009 (dd/mm/yyyy) Schedule Details: Monthly (Feb) on 29th Which means the report should not execute as 29th Feb will not appear on 2009. This date will...

When I am using select distinct I am getting these result..... rsJobWasCanceled rsInternalError rsReportParameterValueNotSet rsParameterError rsReportTimeoutExpired rsProcessingAborted rsSuccess rrRenderingError But I want to get all the possible list. Is there any master table for this? With regards