web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Crystal Reports upgrad...
Microsoft Dynamics SL (Archived)

Crystal Reports upgrade gotchas

(1) ShareShare
ReportReport
Posted on by Bruce.T 459

Hi,

While testing our SL7 to SL2015CU2 upgrade we have noted a number of Crystal report issues (see below). As Crystal 2008 used in SL2015 is several versions old we have not been able to find any documentation of the differences or gotchas we will need to resolve. Does anyone have anything they can share?

Some of the changes/issues we have encountered are

- Numbers must now be passed without delimiters ie 9 not '9'

- Dates must be delimited with # eg #31/01/2017#

- {} required around database fields

We are also trying to better understand why we get this error when the dates are at the beginning of the select parameters but if we move these to the end the error does not occur.

Crystal2.PNG   Crystal1.PNG

Any help/guidance would be appreciated.

*This post is locked for comments

I have the same question (0)
  • David Callery Profile Picture
    David Callery 1,141 on at
    RE: Crystal Reports upgrade gotchas

    Don't know if this helps but I have upgraded to CU2 which has compromised some reports.  I have some custom reports using views that were running fine in SL2015 CU1 and when the update of CU2 was applied, the templates for selecting some parameters did not work.  When I looked at the report, all appeared fine but when I looked at the source view in Crystal, all of the data properties were set to "string"  Looking at the original view in the database, those properties are correct as Integer, Date, etc.

    In my investigation, this is noted as a Crystal issue and the only way I have gotten around it was to redo the report.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans