I want them to be independent columns, next to each other.

Thank you.

Thank you, this what I did

Thank you.

Argument not specified for parameterValue of Public Day(DateVlaue) As Integer

Getting an error on "DAY"

I also tried

=IIF(Format(Parameters!Start_Date.Value, "MMM") = Format(Parameters!End_Date, "MMM"), IIF(Format(Parameters!Start_Date.Value, "yyyy") = Format(Parameters!End_Date, "yyyy"), Globals!ReportName & " from " & Format(Parameters!Start_Date.Value, "dd") & " - " & Format(Parameters!End_Date.Value, "dd MMM yyyy"),...

Yes Scheme Code is s_code is the table.

what do you mean?

Thank you

declare @ToDate datetime

declare @FromDate datetime

set @FromDate = '1 Feb 2014'

set @ToDate = '28 Feb 0014'

SELECT EVENTDATE,'' AS BRANCHCD, BUSINESS_AREA, CREATE_DATE, WORK_TYPE, QUEUE, STATUS, CREATE_AGE, CATEGORYCD, DELAYREASON1, DELAYREASON2

...

I just corrected it and I get this error "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value."

It's datetime.

@BWFC

The code is this:

declare @ToDate datetime

declare @FromDate datetime

set @FromDate = '01/02/20014'

set @ToDate = '28/02/20014'

SELECT EVENTDATE,'' AS BRANCHCD, BUSINESS_AREA, CREATE_DATE, WORK_TYPE, QUEUE, STATUS, CREATE_AGE, CATEGORYCD, DELAYREASON1, DELAYREASON2

...

They are two different Code but share those similarities. I thought this code was clear because it doesn't have much Columns.