x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 14 subscribers
  • Views 633 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
4
replies
General Discussion
1k
topics
2k
replies
joshSWR

Sage 200 Report Designer - Join Not Detecting New Column in View

SUGGESTED
Posted By

On our picking list report we've got a join to an SQL view called 'SOPAdditionalChargeView' which is used to display the additional charge line for the order at the top of the picking list. Without going into too much detail I have added a column to this view in SQL management studio, and it is not showing up in report designer. 

Can anyone think of any reason this wouldn't be showing? The view has been changed on the database for the company I selected before opening report designer, but does it always look at that or would it be looking at another one? Will it only ever show the default fields?

Any advice would be greatly appreciated. Thanks Slight smile

  • 0

    Hi.

    Just adding a new column is not enough.  You need to extend the sage data model so that the report designer is aware of the new column.

    To do this you will need your sage business partner to add the column to the data model, this is only possible using the sage developer kit

  • 0
    SUGGESTED

    Hi Josh

    Just to confirm the advice given by Toby, the Sage Data Model would need to be extended to make a custom or additional field available in Report Designer and this is something that you will need to ask your Sage Business Partner for assistance with.

    I would also recommend not making any amendments to the Sage 200 databases, this could cause errors in the application and/or when attempting to upgrade your Sage 200 system.

    Regards

    Chris 

*Community Hub is the new name for Sage City