• reports affected by rptclc^clc in report forms and custom reports

    Custom reports and report forms in Sage 100 Contractor have been "infected" with this "field" rptclc^clc001, 002, etc. I have seen this before but not to this extent. It is massive. Has anyone else seen this before? Or know what causes this…
  • How to remove automated email reports

    Good day, I have a job cost report for several projects that was set up to auto email every week to my email. We have long since completed these jobs and moved on to new jobs. I have two questions: 1. How do I remove the old job automated report emails…
  • Report Design: Report detail area (gray box) ghosting (duplicating itself) in report

    What caused, or how can I prevent, the gray box (report detail area) in the report form from duplicating itself (ghosting), usually in the bottom right side of the report when the report is run. First thought is there is another gray box, even just a…
  • 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…
  • Selecting null values with report criteria

    I'm trying to build a report that will allow me to select job costs for a list of jobs that have no work order assigned. How do I set the criteria to select null values?
  • Report Form size restrictions

    In Sage 100 Contractor, is there a restriction on the maximum size the file can be? I have a client who set up a 20 page report form, and only 13 pages will show? Most of the pages have a bmp image of the text documents, so the document can get relatively…