Skip to Content
author's profile photo
Former Member

SBO - Document editing - Calculated column

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 ?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Apr 16, 2004 at 07:05 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Apr 19, 2004 at 07:22 AM

    Thanks a lot Marco !

    Add comment
    10|10000 characters needed characters exceeded