Michael McDonald CPA ~ Sage 100 Consulting
For all your Sage 100 needs: Installation | Training | Support |       Contact us
  • About Us
  • Sage 100 Modules
  • Contact Us
  • Blog
  • Support

Add a User ID of the Person Printing a Crystal Report form to the Form

8/19/2015

 
First, make sure you are allowing the Sage 100 system to pass the User ID value (of the user printing a report or form) for most regular reports, so that Crystal Report formulas in those reports can take advantage of them.

To do this, open Library Master, Main menu, and Company Maintenance.  On the Preferences tab, select the option "Print User Logon on Reports."  Next, if you are working with Crystal Report forms that do not have formulas to take advantage of the User ID value being passed, you will need to make an edit. 

For example, the following two formulas can be added to each form as follows (making sure to select Basic Syntax and not Crystal Syntax, when editing):

PrintedByUser
FORMULA=""

UserLogon
FORMULA="User Logon: "+{@PrintedByUser}

Place the UserLogon formula into the area on the report or form where you wish the User ID to display after the words "User Logon:".

          Updates

    Check here for updates to the Sage 100 Software.

    Archives

    December 2018
    April 2018
    December 2017
    December 2016
    May 2016
    August 2015
    May 2015
    November 2014
    September 2014
    January 2014
    December 2013
    September 2013
    April 2013

    Categories

    All
    Crystal Reports
    Payroll
    Payroll - 941 Form
    Sage 100 ERP 2014
    Sage Conference
    Sage Intelligence
    UIA Changes
    Year End Updates
    Year-End Updates

    RSS Feed

Powered by Create your own unique website with customizable templates.