Welcome to the Sage X3 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros from around the globe.
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!
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…
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…
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