Search Results

Next Execution Date Error in SSRS 2005

Thread by: Anirban Biswas, Mar 7, 2008, 1 replies, in forum: SQL Server 2005 Reporting Services

Hi, I am trying to schedule a report from Report Manager Interface (SSRS 2005) as below: Scenario 1: Start Date: GetDate() [today] e.g:...

scheduled report next execution date.

Thread by: Anirban Biswas, Mar 7, 2008, 2 replies, in forum: SQL Server 2005 Reporting Services

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...

Leap Year calculation in SSRS

Thread by: Anirban Biswas, Feb 28, 2008, 9 replies, in forum: SQL Server 2005 Reporting Services

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:...

need to know the date format of SSRS

Thread by: Anirban Biswas, Feb 25, 2008, 4 replies, in forum: Getting Started

Hi, I have report scheduled in a SSRS. SSRS creates a job and from MSDB.DBO.SysJobActivity the Next_Scheduled_Run_Date column provides the next...

list of all status values of ExecutionLog in SSRS

Thread by: Anirban Biswas, Feb 18, 2008, 4 replies, in forum: SQL Server 2005 Reporting Services

Hi, I need to know all the possible 'Status' values of the ExecutionLog in repoting services. Is there any way to find it? presently when i am...

Left outer joins are faster than inner joins

Thread by: Anirban Biswas, Feb 14, 2008, 6 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi, I am using derieved tables and using left outer join with other tables. Can any one tell me if Left outer joins are faster than inner joins