Integrated Crystal Reports

[QJB]

Is this something extra that must be purchased?

 

[dgillz]

No. Assuming you are using Progression, you must use the PWE (progression workflow explorer) interface, not the old beat up Progression Explorer interface.

There are really only a few reasons to use the old interface, mostly related to legacy EDI and payroll applications. You can download a document on reasons to use PWE from my website.

One caveat, if you have been using Macola for a long time, you may not see the ICRs on your menu. The Macola update process only gives new menu options to the users DEMO, GUEST and SUPERVISOR. You may need to go to visual menu builder and copy the crystal report icons from SUPERVISOR to the desired users.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[AERCIT]

I need help with a Crystal Report that was created by a former employee. Basically the report has a numeric date format both in the area where date parameters are entered for the report and then on the report itself. I just need to know how to get the dates converted to look normal. The person who created this report is unavailable and I need to know how to convert the dates ASAP so the dates are readable. When the reports were originally created, the version of Crystal was not a "Macola" version and therefore missing some functions. Any help is greatly appreciated.

Thanks!

 

[dgillz]

Numbertodate(YYYYMMDD) will work. You'll need to download and register u2ltdate.dll if you haven't already.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[NEmacGuy]

MacolaNumbertodate() will work as well, as long as the macola common files are registered correctly.

 

[AERCIT]

Thanks for the help. I did try the NumberToDate function, my apoligies for forgetting to mention that in my post. However, I didnt double check to see if the files were registered properly. When I insserted the NTD function, I get errors to in other formulas that the report uses. Any ideas on why that may be happening? Again, I appreciate all the help.

 

[dgillz]

What are the errors?

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[crystalreporting]

Sounds like the dates in the report previously were simply formatted as numbers. Now that you've changed them to be formatted as dates (by adding the NumberToDate function) any other areas of the report, or other formulas that refer to them (like in selection criteria) will be expecting a number, but getting a date instead.

If there are parameters on the date, you will need to change the parameters to be dates as well. In fact, you'll need to change any fields that refer to the dates to accomodate the new date format once you've changed it.

Note that in doing so, you may slow the report down as each record needs to be bought 'back' to Crystal to perform the NTD function before determining if it meets the selection criteria. If selection criteria is used on the raw dates (i.e. numeric dates) then Crystal can perform server side record selection and only return the selected records.

This problem goes away in Macola ES as dates are held as dates in the database (not numbers). It can also be overcome in Progression by using SQL functions but that's a whole other topic...

Peter Shirley
Macola Consultant, PA and surrounding states.

http://www.erpessentials.com