Sage 100

 View Only

  • 1.  Error 26 adding report to Menu

    Posted 08-04-2025 18:36

    I have a Crystal Report that is looking at a Stored Procedure to generate GL_PeriodPostingHistory data across multiple company codes.  It works great in CR designer.  When I attempt to add the report to a menu in Sage via Report Manager, I immediately get an error 26 of SY_ReportEngine.pvc when I select the report.  I'm guessing it is because the stored procedure is looking across databases, but thought I would ask here is anyone has suggestions for a work around to get this working.  Client would like to utilize Sage 100 security to allow access to the report from a menu if at all possible.  @Alnoor Cassim??



    ------------------------------
    Janna Crowther
    RKL eSolutions, LLC
    ------------------------------


  • 2.  RE: Error 26 adding report to Menu

    Posted 08-05-2025 09:25

    I just had this issue in June which was resolved as follows:

    1.    Client forgot to give the user permission for the stored procedure.
    2.    Client removed the view and created the report using the tables themselves. 
    Both reports are now running from Sage 100 Custom Reports menu successfully. 



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------



  • 3.  RE: Error 26 adding report to Menu

    Posted 08-06-2025 14:36

    Why a Stored Procedure instead of a SQL View?

    (For a multiple company query I'd typically put it into MAS_System... to avoid having to duplicate the View in multiple company codes).



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 4.  RE: Error 26 adding report to Menu

    Posted 08-06-2025 14:42

    Oh, and if your Stored Procedure is actually editing table data... know that Sage menu reports run under the SQL credentials "MAS_Reports" which is limited with read-only access to the Sage 100 databases.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 5.  RE: Error 26 adding report to Menu

    Posted 08-08-2025 15:19

    Sage has added this to their knowledgebase - Error 26 SY_ReportEngine.pvc 685 when adding custom report with SQL View to menu



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    CT
    ------------------------------



  • 6.  RE: Error 26 adding report to Menu

    Posted 08-09-2025 03:22

    So they call it it "can't" and "not supported" instead of telling you to give MAS_Reports execute permissions to the stored procedure?  



    ------------------------------
    Phil McIntosh
    Friendly Systems
    ------------------------------

    Original Message


Related Content