ok, I fixed this and it's a bit of an annoyance in how SSRS renders charts.

Turns out I have to have unique labels in the chart axis.

So as soon as...

... and just to confirm updating the incorrect column values in table using ltrim(rtrim()) DID actually work and removed the "invisible" characters

equally strange solution - one of the reference tables from which the "continent" update is derived appears to have had some invisible extra characters even though these were manually typed...

Hi, yes the group by len() was one of the first things I checked. It displays the expected (normal) result with a single length per continent.

I'll try to upload sthg...

First thing I checked.

Even did a ltrim(rtrim()) but to no avail.

Original data came via flat file and imported via SSIS.

Data Types were nvarchar but I changed these and loaded to...

I hear what you say, however the SSIS project is now running fine strangely (scheduled job at 5am ran fine, whereas manual runs yesterday failed).

Although I have SSDT VS 2013...

Hi,

I've found the SHA-256 algorithm meets my needs so far in ETL loads.

I use a C# script task within SSIS to compare hash values in the Dimension tables, which obviously...

Hi Grant,

Many thanks for replying. Yes, I had noticed Mike on LinkedIn already but was unable to mail with the account level I currently have; I'd have to upgrade.

Basically, I'm...

ok, answering my own question here and the solution was surprisingly simple.

Restart SQL Server and Reporting Server services.

After this, the rendering issues disappeared.

... just to further clarify

when I debug the report locally the report graphics display perfectly.

However, when I browse to report server and run report from SSRS homepage then some graphics...

Hi,

Thanks for post but not really as it is just a brief summary about the technology itself, nothing really about compatibility.

I'm now assuming that compatibility will not be an issue...

oh where are all the SSIS experts, or perhaps CDC experts? ... or both 🙂

All works ok now. Basically in a 3 server BI environment, we have a non-expiring non-service domain account which provides the integration service access to data in warehouse, and AD...

wakey wakey come on someone must have an idea (please!)

yes, using SSRS 2014 also and can see icon for .xls file but just white blank page for .xlsx

Poor form I say