cancel
Showing results for 
Search instead for 
Did you mean: 

SBO - Document editing - Calculated column

Former Member
0 Kudos
132

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 ?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Thanks a lot Marco !

Former Member
0 Kudos

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.