Sage 100

I have a client on Sage 100 Advanced v2021 with a custom report that is giving this error 88 when running from the Sage Custom Reports menu but it runs fine directly from Crystal. This happens for multiple users. I found a similar write up from Sage pointing to the Sy_reportsetting.m4t table but that didn't seem to be the issue. Other reports run fine from Sage.

I have tried the following:

1. Deleted report from menu and added it back with a different name.
2. In Crystal, cleared any 'old' datasource paths from the report.
3. In Crystal, refreshed the datasource connection.
4. In Windows, changed the default printer.
5. I did NOT reinstall the workstation since this is happening for multiple users and other reports are fine, I didn't think it applied.

Any ideas before I get Sage involved and/or recreate the report?

Thanks!

------------------------------
Dawn Kulbacki
Capitol Computer Systems, Inc.
------------------------------

You said you changed the default Windows printer - is that the printer they're printing to?  What happens if you preview?

------------------------------
Beth Bowers
Dog Mom, first and foremost. The rest is all just necessary to keep the dogs in biscuits.
(269) 358-0989
------------------------------

There was a parameter but it was a string, that error @David Overholt was thinking of relates to numeric parameters.  I removed all parameters and selection criteria and still had the error whether I printed or previewed.

I ended up recreating the report, added it to the menu and it works.  There must have been corruption somewhere.  Luckily it was a crosstab, so didn't take much to redo it.

Thanks for the suggestions!

------------------------------
Dawn Kulbacki
Capitol Computer Systems, Inc.
------------------------------

Original Message:
Sent: 05-29-2025 13:52
From: Beth Bowers
Subject: Error 88 SY_ReportEngine.pvc statement 683

You said you changed the default Windows printer - is that the printer they're printing to?  What happens if you preview?

------------------------------
Beth Bowers
Dog Mom, first and foremost. The rest is all just necessary to keep the dogs in biscuits.
(269) 358-0989
------------------------------

Original Message:
Sent: 5/29/2025 2:55:00 PM
From: Dawn Kulbacki
Subject: RE: Error 88 SY_ReportEngine.pvc statement 683

There was a parameter but it was a string, that error @David Overholt was thinking of relates to numeric parameters.  I removed all parameters and selection criteria and still had the error whether I printed or previewed.

I ended up recreating the report, added it to the menu and it works.  There must have been corruption somewhere.  Luckily it was a crosstab, so didn't take much to redo it.

Thanks for the suggestions!

------------------------------
Dawn Kulbacki
Capitol Computer Systems, Inc.
------------------------------