Erroneous values displayed in report table

Hi All,
I've created a report the displays a snapshot of a bunch of loop data from a database table. Some of the rows contain only a PV, and the other columns (SP, Err, Out) are nulls. For the data that contains nulls, I'd like to leave blank on the report, however, what I'm seeing are random numbers

I can insert zeroes in the database table for these data instead of leaving them as null to address the problem, but what I'd like is for the report to look like this:

Thanks in advance!

How is your report actually set up? Is this a single table, a bunch of disparate text fields, or something else?

It's a single data table joined to a header tagle, multiple records per report. Here's the report query:

select i.Descr, i.LoopCode, rpt.SP, rpt.PV, rpt.Err, rpt.CV
, case rpt.PidMode when 0 then 'Manual' when 1 then 'Auto' else '' end as PidMode
from ReportTagInfo i join [9301 Loop Shift Data] rpt on i.TagId = rpt.LoopId
where i.ReportName = '9301 Loop Shift Data' and rpt.ReportDate = ? and rpt.ShiftNum = ?;

For the cells with the key values, such as @CV@, what is the Data Key Format Properties > Null Format set to? It defaults to "<N/A>".

I'm seeing are random numbers

In this case the values aren't random they are repeating the initial row from the dataset for missing values. (The first good value from the data key for that column)

1 Like

I've tried different values for the 'Null Format' property but nothing I do seems to affect the output.

Aha!!!! kvane, you pointed me in the right direction with your post. I was using '@query.CV@ using a table column as the data key. Once I changed the data key to 'query' and removed the 'query.' prefix from the 'Edit Text' property, it worked. Thank you!

1 Like