x Want to participate? Join the group to interact

  • Why is my custom report using "or" for the selection criteria?

    I have multiple selection criteria for my report but instead of pulling data that fits all selection criteria it is pulling in all data that fits any of them. I know there is a box that says enable or logic but it is not checked and even if I do check…

  • Sage 100 Contractor Modify Report - Define Selection Criteria - Enable 'Or' logic

    When modifying a report, there is an option to enable 'or' logic in the selection criteria. I'm having a hard time setting this up and wanted to see if anyone has had success with this.

  • can in-list be used with {variable[N]}?

    In Report Writer, Sage 100 Contractor, is there a way to use the selection criteria "in list" with a variable like {variable[N]}? In this case, I am using {Job Number[N]} to select Job Number in SQL statement where job number is not in the Primary Table…

*Community Hub is the new name for Sage City