x Want to participate? Join the group to interact

  • Configuration Options on View

    Hi Everyone, We would like to create a view with schemabinding option. Anybody Knows if it is possible to do with the .cfg file? Create View xxxxxx with schemabinding As SELECT .... Release: 2022R2 Thanks!

  • Legend in SEI chart showing duplicates from the column's description

    Hi, I was wondering if anyone else had a similar issue when building graphical view on SEI. On the screenshot bellow, for each product category on the legend I get duplicates of the column's description. Thanks in advance for your help. Tar…

  • Views wont accept like statement

    Why cant sage handle LIKE in the views? Has anybody found a way around this?

  • Performance of View / Class Representations in Landing Page widgets

    I'm looking for some guidance and suggestions on best practices for custom data retrieval sets in landing pages. I have a fairly computation intensive View (GESAVW) that I've created that I want to layer into a landing page widget. The context of the…

  • Use of X3 SQL Views in Import/Export Templates!

    Idea about being able to use X3 Views in Export templates do come up with limitations of only 8 Tables. Re, Victor

  • Using a wild card when creating a View in X3

    Hi I am trying to create a view in X3 using the following code SELECT TOP (100) PERCENT ga.CCE_4 AS BPCINV, a2.TEXTE_0 AS BPCNAM, SUM(ga.AMTLED_0 * ga.SNS_0) AS NETAMTNOT FROM FOLDERNAME.GACCENTRYD AS gd WITH (nolock) INNER JOIN FOLDERNAME.GACCOUNT…

  • Views in Crystal Reports for update 9

    Hello, Does anyone know if it's not possible anymore to add views in Crystal Reports for update 9? In Crystal after picking the folder, it doesn't show the option for views anymore. Can anyone help on this? Best regards, Nuno Roque

*Community Hub is the new name for Sage City