SBO - Document editing - Calculated column

[Former Member]

Hello,

If i create a query with a calculated column

ex.

SELECT 'XXX' as 'test' ,T0.ItemCode, T0.ItemName FROM [dbo].[OITM] T0 FOR BROWSE

and then I generate a report from this query, the xxx column appear in the report without file and field in it's property, so when I try to save the report i get an error : translated from italian is : "there isn't the name of the file in the data field".

How can i modified the report and saved it ?

[Former Member]

Thanks a lot Marco !

[Former Member]

Hi Andrea,

you can upgrade the field "FileName" in the table "RITM"

with any value of valid table (e.g. "OITM");

SBO, ignore the value and skip the error.