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:
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)
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!