SSRS Report showing blank values but on export it is showing actual values

582 Views Asked by At

I have an report, which was working fine on my old laptope but when i use the same in my new laptop is showing blank in place of data values like image below:- enter image description here

But when i use same report after publishing on report server or i export it to excel. It shows actual values image given below.

enter image description here

What may be the reason. Please help, I checked everything like server connection, font colour, data in sql is coming fine with same query, even data is correct when we execute the query in query designer of SSRS.

Pls help, thanks in advance.

  1. I tried checking connection.
  2. Query execution in SSRS.
  3. Font & Background color properties.
2

There are 2 best solutions below

0
On

This issue is due to some screen setting issue I changed the scale from 150% to 100% and took control of my laptop from my old laptop through any desk now it is working fine for the last two days. I don't know what it did but seems like my issue is resolved.

0
On

I experienced this same issue with a report that had previously had no issues but suddenly a cell was blank on the portal page but populated on the exports (excel, pdf, etc.).

In order to resolve the issue I had to change the CanGrow setting for the cell from the previously assigned False back to the default True (even though it was previously working fine with the False setting...).

This cell also had an expression defined to assign the Color property and I found that replacing that expression with a simple color assignment also fixed the issue but since this was needed I went with the CanGrow change.