Friday, June 12, 2009

Run Crystal Report in Dynamics GP Using VBA

Dear All,

I was a long time since my last post, that was due to my engagement in managing 3 concurrent projects in two different countries, now I am back with this interesting article.

Allot of GP developers used to ask how to run Crystal Report from GP, all the answers were to use Report Designer Component (RDC) for dexterity along with ReportView.exe and proceed, this is not an easy task to be done if you are not dexterity expert.

In this article I have created a .Net based application that view any crystal report using parameters passed through files.

Now to implement this solution you will need to follow steps below:

1. Download and unzip "Crystal Reports Viewer.zip" from the link below:

http://dynamicsinnovations.com/blog/Crystal%20Reports%20Viewer.zip

2. Run "GP Crystal Reports Viewer Setup\setup.exe" to start the installation.

Note: Crystal Report Runtime files and .Net framework should be installed on the client machine, if it's not then you might need to read files under "CrystalReports" and "dotnetfx" folders.

3. Import "CustomerCard.Package" from Dynamics GP Menu >> Tools >> Customize >> Customization Maintenance.

4. Modify the VBA code to fit your needs.

Please don't hesitate to post your comments.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com/
http://mohdaoud.blogspot.com/

8 comments:

Anonymous said...

Greetings! Many thanks for the post. We shall give a try!

Best regards,

James Keep, PMP
Crystal Reports Certified Consultant (CRCC)

A said...

That's quite an impressive list of certifications you have, Mohammad! Crystal Report scheduler has really gone a long way since its inception.

Anonymous said...

Mohammad!

Thanks for the very good blog. However, when I am trying to attach this component, it is giving me error of VBA cannot be initialized. Can you please tell me what I have done wrong.

Please note that I have already change the VBA as per my requirement.

Regards
Sajid Hakeem

Sajid Hakeem said...

Mohammad!

Thanks for the very good blog. However, when I am trying to attach this component, it is giving me error of VBA cannot be initialized. Can you please tell me what I have done wrong.

Please note that I have already change the VBA as per my requirement.

Regards
Sajid Hakeem

Anonymous said...

Hi,

I try to test your script for, but it gives me error message the file Temp not found in C:\drive,.

Can you give me more explication for this, because i have some Crystal report to integrated to GP2010.

Thank you.

Aissam.

ArsalanMKhan said...

The TEMP folder is hidden.. ;)

workboy53 said...


It is said that the Roman emperor Nero liked to watch gladiator fights with emeralds. These, however, appear to have worked rather like mirrors.


Crystal Custom
Promotional Sunglasses
Promo Sunglasses
Personalized sunglasses
Customized sunglasses


Unknown said...

Hi,

Greetings!!!

I am calling crystal report from MS dynamics GP using dexterity code and it is working fine with GP10. But same code is not work with GP2016 & Gp2018 So in this case it is require to install higher version on .net framework and Crystal Reports run time files ?

If it is require then please send me link for those files so I can download from the net.

Thanks & Regards,
Tanuja

Related Posts:

Related Posts with Thumbnails