Sage 100

 View Only

  • 1.  Crystal Report based on Stored Procedure

    Posted 09-21-2020 18:44
    Anyone ever have issues with bringing a Crystal Report based on a stored procedure into a Custom Reports menu in Sage 100?  The report runs fine in Crystal.  It has two parameters that come from the stored procedure and another parameter from within the Crystal report itself.  When launching from the Sage 100 UI, the message pops up stating the report needs to be converted to the latest version.  It's immediately after clicking OK that this error appears.  "The following error occurred when attempting to connect....the table could not be found."

    Any ideas?

    ------------------------------
    Rob Neal
    ------------------------------


  • 2.  RE: Crystal Report based on Stored Procedure

    Posted 09-21-2020 20:48
    Have you tried going to File, Summary Info and putting "Converted to version x.xx" (where x.xx is the running version of Sage 100) in the keywords field?

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------



  • 3.  RE: Crystal Report based on Stored Procedure

    Posted 09-22-2020 08:42
    Table could not be found is sometimes associated with permissions.  Same results when running Sage as admin from the shortcut?

    ------------------------------
    alan niergarth
    Velosio LLC
    ------------------------------



  • 4.  RE: Crystal Report based on Stored Procedure

    Posted 09-22-2020 08:52
    Does the account that's running the Sage service have rights to execute the stored procedure?

    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------



  • 5.  RE: Crystal Report based on Stored Procedure

    Posted 09-22-2020 10:35
    Edited by Kevin Moyes 09-22-2020 10:35
    I'd think it would be MAS_Reports that needs the permissions... (assuming it is a Premium system).

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

    Original Message


  • 6.  RE: Crystal Report based on Stored Procedure

    Posted 09-22-2020 13:47

    Thanks @Kevin Moyes.   It was the MAS_Reports user.  And yes, it's Premium.  This ability to use SP's for Crystal Reports opens up a lot of doors.  Never knew it was possible. 

    Thanks again everyone!  @Phil McIntosh  @alan niergarth @Steve Iwanowski​

    ​​​​

    ------------------------------
    Rob Neal
    ------------------------------

    Original Message


Related Content