CODEWITHSUNDEEP
sql-serverreporting-servicesssrs-2008-r2
Nyra
Nyra

Reputation: 897

SSRS Duplicating Date Values Within Rows

I have an SSRS package, and within it, the dates are being duplicated across the columns. For example,

select [demographic columns], hireDate, transferDate, promotionDate
from userTable
where [conditions are met]

In my SSMS query window, sample results would be something like:

 12345 | John | Doe | 01-15-2013 |    null    |    null
 23456 | Jane | Doe | 12-12-2012 | 03-15-2014 |    null
 74883 | Test | Doe | 02-05-2014 | 06-06-2016 | 05-22-2015

However, when I run the exact same query in SSRS, or call the same query via stored proc to my SSRS package, I get duplicated date values in any date fields like below (SSRS converts the nulls to whitespace*); also it seems to take the first date (in my queries my first row's first date is 4-14-2017, and that date is everywhere, almost as though the date is cached for the entire report:

 12345 | John | Doe | 01-15-2013 |            |  
 23456 | Jane | Doe | 12-12-2012 | 12-12-2012 |      
 74883 | Test | Doe | 02-05-2014 | 02-05-2014 | 02-05-2014

Has anyone seen this behavior before?

Upvotes: 0

Views: 117

Answers (1)

ZLK
ZLK

Reputation: 2874

As mentioned in the comments, the only reason I could think for behaviour like that in SSRS is if there's some expression modifying the column, so looking through anything of the expressions that might modify the column should give you your answer.

Upvotes: 1

Related Questions