Help adding a database field to report - not working

[o9z1]

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.

[Chrissy]

I have noticed in some of my reports (Oracle db) that when I have a sum it doesn't show up in my report. I have to change it to a char and then it shows up.

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

Just an idea...

[o9z1]

I tried that with no luck

[jggtz]

Try :
1.- If you have all the nedded elements, add a new formula in the report that makes your desired calculations
Or
2.- If it doesn' affect your project, add the field to your physical database,
Or
3.- Change the way you define the report's data source