Value is not displaying for a new field in existing RDL

Ganesan, Geetha 96 Reputation points
2020-09-11T08:12:56.583+00:00

Here with attached a RDL.

We added a new column "Consultation medium" in the existing report. The value in this column displays, when the dataset returns value in the first row. At the same time, when value is not having the first row in the dataset, then other values in this column are not getting displayed. This report has group by option.

Tried all possible ways. We are not able to find the exact problem.

Can you please help us to get it resolve this issue.24070-opcliniclist-266400.xml

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,878 questions
0 comments No comments
{count} votes

Accepted answer
  1. Ganesan, Geetha 96 Reputation points
    2020-09-11T10:27:41.907+00:00

    Problem identified that if the value is null, the data is not getting bound in the entire column/field. We can do like this to resolve this issue

    iif(Fields!Name.Value Is Nothing, "value is NULL", "value is not NULL")

    0 comments No comments

0 additional answers

Sort by: Most helpful