Ideas for Acumatica

Feedback processing: We do not reply to all messages, but we do read them, analyze them, and work to improve Acumatica based on the feedback we receive. Ideas and comments may not appear immediately. Some legitimate ideas are flagged as spam and will be added when we review the spam folders.
Content: This portal is for product ideas and feedback only. If you need customer service assistance, contact your Acumatica Support Partner, submit a support case, or get assistance from community resources: LinkedIn Group or StackOverflow
No Reliance: Information is maintained on a best-efforts basis and may be changed without notice. Acumatica cannot guarantee the accuracy of the information provided or guarantee completion of features/ideas described on this portal.

Better Error Repoting in Report Designer

RD is horrible for error reporting.  It gives no clue where the error is.  It does little or no validation in RD itself.  You have to wait to run the report for it to blow up.  This is a perfect example.  How  the heck can you debug this?

Incorrect syntax near ')'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near ')'.

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace: 

[SqlException (0x80131904): Incorrect syntax near ')'.]
   PX.Common.Async.Process(String uniqueKey, Method`1 method, Int64 waitTimeout) +418
   PX.Reports.Web.WebReport.Render(HttpResponse response, String format, Int32 pageNumber, Boolean refresh, Boolean isAttacment) +1326
   PX.Reports.Web.PageOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +298
   PX.Reports.Web.HttpHandler.System.Web.IHttpHandler.ProcessRequest(HttpContext context) +237
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +508
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +92
  • Guest
  • Oct 15 2015
  • Future consideration
  • Attach files
  • Vladimir Panchenko commented
    January 31, 2019 20:41

    Sorry for the late answer and thank you very much for your feedback.

    As you may know, now we have the preview, and it validates the SQL statements, but it will show you the same error message. We will try to improve it in the future.

  • Guest commented
    October 15, 2015 13:49

    As long as the preview validates the SQL statements RD generates.

  • Gabriel Michaud commented
    October 15, 2015 13:15

    I think this idea also goes hand in hand with the ability to preview reports - would help to quickly try things when making changes to reports.