Sage 100

 View Only
  • 1.  Getting the report Description to print on the standard Sage report

    Posted 09-15-2025 17:46

    Client asked an interesting question.  She has various saved report settings that are used.  Is there a report variable to could be used in the Crystal report to print the description on the report?  See below.



    ------------------------------
    Jeff Schwenk
    Owner
    Bottomline Software, Inc.
    Waynesboro VA
    (540) 221-4444

    Improving bottom lines for over 25 years!
    ------------------------------


  • 2.  RE: Getting the report Description to print on the standard Sage report

    Posted 09-15-2025 18:44

    Possibly via Special Fields in Crystal?:



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



  • 3.  RE: Getting the report Description to print on the standard Sage report

    Posted 09-16-2025 12:43

    Special fields are specific to Crystal reports. The description that Jeff is referring to is the description in Sage 100. If anything, it would be passed as a formula field but I have not seen it in any existing form so I would highly doubt it. You could add the table to the form, but I do not think there is anything indicating the setting being used. You would have to hardcode the setting name (if that is the case just hardcode the description unless it changes a lot or if you may use the exact same form for different settings).



    ------------------------------
    Todd Martin
    MBA Business Software
    https://www.mbabsi.com
    ------------------------------



  • 4.  RE: Getting the report Description to print on the standard Sage report

    Posted 09-16-2025 13:25

    Not the "Description" you asked about, but you could parse the File Path and Name to get the Report Setting. 



    ------------------------------
    Eric Lunceford
    First Mate Business Solutions
    Oklahoma City, OK
    877-880-8960
    ------------------------------



  • 5.  RE: Getting the report Description to print on the standard Sage report

    Posted 09-16-2025 13:59

    True and with that you could link or do a subreport to get the description from Sage.



    ------------------------------
    Todd Martin
    MBA Business Software
    https://www.mbabsi.com
    ------------------------------



  • 6.  RE: Getting the report Description to print on the standard Sage report

    Posted 09-16-2025 14:33

    I don't know of any way to do what you ask.

    If the report settings don't have their own Crystal Report, the easiest solution would be a text parameter that they enter / choose when printing.

    If there is a custom report per setting, just hard-code the description into the report.



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



  • 7.  RE: Getting the report Description to print on the standard Sage report

    Posted 09-16-2025 18:36

    Above I was thinking maybe the report desc was present in summary info (file menu in Crystal), and therefore possibly available via Special Fields. 



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



  • 8.  RE: Getting the report Description to print on the standard Sage report

    Posted 09-17-2025 19:04

    OK I tested and yes you can do it with a sub report. 

    Create a formula "ReportSettings" to get just the folder that the rpt file is in

    // Formula: ReportFolderName
    Local StringVar fullpath := Filename;
    Local NumberVar lastSlash := InStrRev(fullpath, "\");
    Local NumberVar prevSlash := InStrRev(Left(fullpath, lastSlash - 1), "\");
    
    Mid(fullpath, prevSlash + 1, lastSlash - prevSlash - 1)

    Then create a sub report to SY_ReportSetting. In my test I did a select expert for these fields and hardcoded the values.

    CompanyKey

    ModuleCode

    ReportID

    I suppressed detail that had a value in the workstationName field. The default name doesn't have any value in this field. Just note that the workstation can have different descriptions.If you want the specific workstation description for that setting, that will be a little harder.

    Then did a sub report link from the formula "ReportSettings" to the field ReportSetting

     

    I had to see if it could be done and it can.



    ------------------------------
    Todd Martin
    MBA Business Software
    https://www.mbabsi.com
    ------------------------------



  • 9.  RE: Getting the report Description to print on the standard Sage report

    Posted 09-16-2025 20:04

    Say "Not with native code but we could code an enhancement to do that and expect a cost starting at $1,200 which is generally a minimum development fee". 96.9% of users will say "oh, it's not that big a deal".

    Then you hit them with suggesting that you hard code it into the report and they will gladly accept that lesser cost alternative...



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