x Want to participate? Join the group to interact

  • How to Use Query Input in a Calculated Field

    I want to show the beginning balance based on a starting date of a check date range in the report query. How would the value from the query field be used? Example: I want to show a running total of accrued vacation hours from each pay period. I need…

  • Where are formulas being used

    I am trying to find out if there is a PSQL query or a report that I can run that will show me where formulas are being used - or if they are. So, if a formula is being used, is it used in another formula, report, etc. I have 100's of formulas & reports…

  • RE: EEO1 Report

    Hi Mitesh, You can get this information for your report by creating and running a query in 5-2-1 Employees . For instructions on how to build and use query, please see article ID 37118 in the Sage Knowledgebase by logging into the Sage Customer Portal…

  • Crystal and command queries

    At a loss. Trying to build a command query in Crystal taking the sequence plus one to get the linked entry. It seems you cannot calculate in a Crystal query against a key/index field??? I can apply the same logic on a numeric field that is not an index…

*Community Hub is the new name for Sage City