Hi, I'm having trouble in the report designer, maybe someone can help me ? I have created an SQL view in the database and tried to display it in the report, but only 1 data appears in the report, even though when I query select in the database there is a lot of data that appears.
Best answer by RohitRattan88
Dear
About the SQL View DACs:
Please note that we do not support the use of SQL Views.
Also if the application would like to be certified (ISV Certification) then ISV Certification does not allow the use of SQL Views.
You could define a projection DAC to mimic sql view:
+5Dear
About the SQL View DACs:
Please note that we do not support the use of SQL Views.
Also if the application would like to be certified (ISV Certification) then ISV Certification does not allow the use of SQL Views.
You could define a projection DAC to mimic sql view:
+5Please pay attention to
For basic checks on whether your SQL view is configured right, you can try comparing to this old Technical Tuesday post about how to bind SQL Views to DACs:
https://www.acumatica.com/blog/technical-tuesday-report-from-sql-view/
Or maybe this AUGForums post from an AcuConnect 2023 talk:
https://www.augforums.com/acuconnect2023/
My guess from your description is you may need to confirm that the attributes of your view are correct (IE: did it generate a primary key?)
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
