• Crystal Reports 2016 error in custom report after Sage 100 2021.6 update

    First time in 12 years that the report I maintain is getting an error. Failed to retrieve data from the database. Details: s0000:[ProvideX][ODBC Driver][PVKIO]Data page header contains invalid record offset information. [Database Vendor Code: 109…
  • Crystal Report Page Layout not previewing any width greater than 8.5"

    I created a Sales Report in Crystal Reports 2016 that has 20 columns of Summary and then those 20 columns have sub-reports that I have linked to provide the Details by simply clicking on the hyper-link of the Sub_Report name. I added the Sales Report…
  • Is an "Enforced Both Inner Join" type supported by the SOTAMAS90 ODBC DSN?

    I seem to recall a Sage KB that indicated there were only 3 Join Types supported by Sage (MAS, back in the day). Inner Join, Left Outer and something else. I don't recall hearing about the "Enforced" setting. I ask because we have a client who are very…
  • Report Writing - Record shows multiple times

    I have pretty limited knowledge/experience with Sage or report writing but I'm currently working on recreating non-modifiable System Report 4-1-3-21 so I can add "account" as a selection criteria. I was able to recreate the calculated fields and I am…
  • Custom Report keeps asking me to convert....

    I created a custom report and have been trying to add it to the Sales/Custom Reports. I done this on many other reports in our system and have had no problems. In this case I have added the report to the menu, but every time i launch the report it will…