Maximo Open Forum

 View Only

 Crystal Report Writer MAS

  • Reporting
Keith Henderson's profile image
Keith Henderson posted 11-20-2025 14:29

Good afternoon all

I'm working out the details to move to MAS 9.

We use Crystal Report Writer to run all our billing reports.

Is there any issues with Crystal Report Writer and MAS 9?

Much Thanks

D Keith Henderson

Steven Shull's profile image
Steven Shull

I assume you're talking about the legacy ERI (External Report Integration) concept where you run Crystal Reports from within the Maximo UI interface? If so, I would proactively open a support case with IBM to confirm if this is still supported in MAS. 

I'm not aware of anyone using it with MAS. While at least most of the files still seem to exist in the install, that doesn't mean it's still supported. There were so many changes in MAS, and the changes keep coming like Java 17 in 9.1. If they are not actively supporting the integration it's likely to have broken with one of the updates. 

Keith Henderson's profile image
Keith Henderson

Thanks Steven, good information.

Sorry I was lite on details.

Crystal Report (CR) installed local

Request 8 hour access to Maximo database (SQL Server) via Naviam portal. 

Open CR local, open CR report to run, using the CR embedded connection to SQL Server

Run report. 

I see no reason why this would break with MAS. 

My understanding is the processing platform (Dockers) is changing not database storage. 

I do understand S3 will be utilized for various file system operations (file uploads etc), but not DB structures, I think.

Thanks again

Steven Shull's profile image
Steven Shull

I’m not a crystal expert but there are some data type changes of columns (datetime to datetime2, text to varchar(max), etc.) for SQL server customers. These may require some changes in the report. For example, datetime let you add numbers to it directly. EX: reportdate+7 would add 7 days to the reportdate field. You must use the dateadd function with datetime2 columns. Worth mentioning that getdate() returns a datetime object so you can still use it with that. 

As with all upgrades, there are also schema changes with new tables, columns, etc. Unless you intend to take advantage of some of these features (like qualifications on a work order), I can’t think of a good example where this would impact you. 

The high level concept of running a report outside of Maximo though is not impacted because of MAS.