Removal of Crystal Reports in 25R1

On a technical level, is it even possible for IFS to remove Crystal?

After all, Crystal is just a web service listening to incoming requests (from IFS) and responding with a PDF file.  How can they block the existing technology?

It’s one thing to de-support a product, but it’s quite another thing to actively switch it off!!

Can someone clarify?

Has there been any updates on this topic? We are next heading to IFS 25R1 and this is a major concern when the time for 25/R2 rolls around.

Report designer is terrible. My legs can walk me forty miles also, but no one would recommend my legs as a replacement for a car.  It is a weak, user-unfriendly tool. 

Report studio seems to have a bunch of bugs and has limited functionality compared to Crystal.

Converting these reports also will solve 0.00 issues at our company. We will get the same report, we have today after spending 100s of hours converting them. 

Has anyone tried using the report rendering engine integration delivered in 25R1 with Crystal Report? 

So with this in mind are IFS offering a tool to convert all of our Crystal Reports (over 250) to another format or do we have to spend time and money developing them all again from scratch ?
All this because of a licencing matter, out of our control…. not much thought again has been given to the end customers.

Maybe IFS is offering to discount the annual license fees, for all of the time spent converting Crystal reports to other formats? Send the hours to IFS, and deduct from the bill? Is that how it works?

Allow me to try and clarify, please.

We’re not blocking anything. What we are doing in the 25R1 release (25R2 for upgrading customers) is discontinuing /sunsetting a Crystal Reports specific integration we built decades ago. This integration has simply reached end of life.

There’s always been two parts of this integration, one for operation reports (things like invoices, purchase orders and similar, reports that are part of and triggered in a standard business flow of IFS Applications / Cloud) and another one focused on what we refer to as ad-hoc reporting or quick reports (more analytical reports, things like sales statistics and similar). Any Crystal Report based operational report layouts would be based on data assembled in a format (a tabular result set) no longer used by any of our other reporting solutions, hence dated and creates an additional maintenance overhead on top of the one for the integration itself.

After careful consideration we’ve decided to stop providing this vendor specific (Crystal Reports) integration (which had reached end-of-life from a technical standpoint) and rather provide a vendor agnostic reporting engine integration capability, in addition to our out of the box reporting solutions (out of which Report Studio is the one we will focus moving forward). This vendor agnostic reporting engine integration capability is provided through the External Reports Gateway. As this is vendor agnostic it actually requires you to implement your own integration to your preferred reporting tool. Compared to using the previous out of the box Crystal Reports this is an additional step. On the other hand it caters to a much wider audience, since it can be used to integrate any tool (which of course include Crystal Reports for someone that would like to use that).

The two (the previous Crystal Reports specific and the new vendor agnostic approach) are technically different, which likely doesn’t allow you to just reuse existing Crystal Reports layouts/reports even if you implement a Crystal Reports specific integration using the External Reports Gateway, but it might be possible to reuse quite a bit of the layout and limit the efforts to adjusting to the new XML-based data source format. We’re only providing the integration point, not the actual vendor specific integrations one might decide to implement, so it all depends on how you would chose to integrate with Crystal Reports in this example.

So quite the contrary to try and block something, we’re actually opening up for being able to integrate additional reporting tools in a better way. Crystal Reports is such a tool, but there are also multiple other ones.

Just as you say, we’ve de-supported a certain part of our product. This means we no longer include and ship it in newer version (Release Updates) of the product. To continue to include de-supported things in a new version is not really feasible and not something you would see anyone doing. Already shipped product is not affected and supported throughout its lifecycle, so for an upgrading customer, that had Crystal Reports since earlier, you could go to 25R1 (the last version that contained the vendor specific Crystal Reports integration) and be supported until early 2027 when this version goes out of support. Combined with the deprecation notice period of a year this allows a total of 3 years to adapt to transition from earlier out of the box Crystal Reports integration to something else (which may very well be Crystal Reports through the External Reports Gateway if Crystal Reports is the preference).

I hope this helps sort out any misconception of us trying to block any Crystal Reports usage, as that’s not the case at all.

Thank you,

The solutions offered though are a backward step and not fit for purpose.
This still does nothing to assist businesses in having to write new reports in the solutions offered from scratch at cost and in time.

“which had reached end-of-life from a technical standpoint.”

Why? This just sounds like a standard techno gibberish answer to obscure the real motivation.

We understand there are options.  But all of these options have costs associated with them, and as far as I know IFS has not offered to help absorb these costs. 

Hi ​@SAGROUP ,
we have upgraded to 25R1 recently (remote deployment of IFS Cloud) and I can confirm Crystal Reports are still working as before, we have been testing the reports and they are rendered properly.
We are also using CR because of 1 feature not being available in IFS report studio today, therefore we have created case to IFS to enhance the functionality. Hopefully they can deliver before next release update. Fortunately we don’t have too many reports with CR layout but I understand concerns. 
Hope this helps.

Did you ever get any answers to these important questions?

Hi ​@rsczerowski,

in a summary what my colleagues we found out, in:

• 25R1 - CR is still supported
• 25R2 - not supported, necessery to prepare customer for it (lots of customers created CR by themselves) and tell them that CR have to be re-done, possible to use:
  • Report studio (not possible to redone on customer side / developer must do it)
  • Report designer (but I would choose report studion, it is possbile in future IFS could cancel this tool as well because of report studio)
  • 3rd party reporting - in “detail” described in technical documentation under: Reporting and Analysis Guide /Reporting /Operational Reporting /Report Design /Operational Reports / 3rd Party Reporting see the link to the main page: https://docs.ifs.com/techdocs/25r1/

The result is that Crystal Report will be obsolete in 25R2, so if you purchased it for your customer, write your IFS manager to:

• stop paying for CR in future
• in case of imlementation / upgrade to get the money back because customer will not be able to use it!

Regards

Nicole Valentine

Report studio can be done by the customer, but it is at this point an inferior tool with many weaknesses. We are starting to use it, and at this point I see it as report designer, 2.0. This package would have been fairly decent back in 2005, but that was some 20 years ago.

Maybe instead of trend chasing the latest AI hype, IFS, should focus a little but more on tools that are a backbone of the system at any company.

The report studio layout conversion tool is incredibly weak also. Looks like that was thrown in for the sales staff, to make the claim that those can be converted automatically. Technically yes, so great talking point for the team there,  but it has failed to even properly convert the most basic report designer forms, out of the box… From IFS. It could not even handle the reminder form properly.

Hi If you want this meesage to get to IFS you have to use @ and add IFS and choose from various options. I am also partnert that s angry but we can put together at least summary of both tools and add what is missing, hoping they would incorporate it, if we put it on Idead wall or “shout” here how bad it is and nothing will happen ...

I have heard rumours now that IFS have delayed the removal of Crystal until 26R2.  It is still listed in the deprecaction log for 25r2.

However I have checked the Core files for 25.2.0 and i can see that the CRYSTL component is still included.  The tables also have the 25R2 preparation scripts for EBR.  It would not make sense to have done the work to include these if the component was being removed.

Can we have a comment from IFS on these rumours.  It would at least delay a headache for a massive number of customers.

An early Christmas gift for the Crystal community - yes, Crystal Reports support is being temporarily reintroduced/reinstated into IFS Cloud 25R2. It was not part of the GA release, we’re in the middle of the work of reintroducing through a Service Update (SU).

We’re not in a position yet to confirm the exact SU (it won’t be SU2, but we might be able to make SU3) - we will have to come back on the exact SU.

The Crystal support will remain in 26R1 and then be removed in 26R2. This revised timeline gives everyone an additional year to transition off Crystal, it also provides an IFS Cloud version (26R1) where you will have both Crystal Support, the IFS QuickSight report functionality, plus layouts in Report Studio format for standard operational reports in the same version to enable side-by-side development/verification.

This does not mean the current Crystal Reports integration isn’t going away, so the transition still needs to be made, but it gives everyone a total of 2 + 2 years (time from deprecation announcement until removal + 24 months of support) to make the transition compared to the earlier 1 + 2 years.

Thank You Martin, It is really appreciated in our project, in the energy sector. It will certainly be used!

Sorry, thanks for the confirmation Martin, but can you clarify how that would work with the 25R2 EBR Changes?

https://docs.ifs.com/techdocs/25r2/060_development/025_operational_reporting/230_ebr_preparations_reporting/#overview

All Operational Reports were made 25R2 compliant meaning the RDF Files no longer write to any _RPT table, i.e. they don’t create any result set accessible from the associated _REP views. (whether INFO_SERVICES or any of the other dedicated _RPT Result Set Tables)

So it’s all well and good that we can have a Crystal integration back in working condition, but what views are we supposed to query to get the actual result set data to display in the reports then ?

I can confirm that for instance, in my 25R2 instance right now, if I print something that previously definitely had a result set, those result sets no longer get created in the database, and the RPI package has been changed to no longer include any of the INSERT INTO statements.
 

Or does the work RnD doing to reactivate Crystal support include changing all Operational Reports back to having some sort of result set data creation, in an EBR compliant way?
 

If re-activating Crystal Support does not include such work, then it’s probably not very useful as I’m sure most people here use those _REP views to query from Crystal, so most of our reports would no longer output any data anyways ?