I added another field to my Select statement that populates the dataset for my report. This field is NOT an actual field in my database table.

I added the LSS field to my select like this

SUM(CASE KILSHEET.Contract WHEN 1 THEN ((TOT_CARC_WEIGHT / 100) * 1.75) ELSE 0 END) AS LSS

I can't get this field to show up in my report database fields even after verifying the database. Is this because verify database looks at the physical database rather than the select that populates the dataset?

How can I get the LSS field to appear in the list so it can be used.

Also, the select runs perfect in QA. It returns the correct data.