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


Prologic Corporation said...

This is a good article & good site.Thank you for sharing this article. It is help us following categorize:
healthcare, e commerce, programming, multi platform,inventory management, cloud-based solutions, it consulting, retail, manufacturing, CRM, technology means, digital supply chain management, Delivering high-quality service for your business applications,
Solutions for all Industries,
Getting your applications talking is the key to better business processes,
Rapid web services solutions for real business problems,
Web-based Corporate Document Management System,
Outsourcing Solution,
Financial and Operations Business Intelligence Solution,

Our address:
2002 Timberloch Place, Suite 200
The Woodlands, TX 77380
281-364-1799

prologic-corp

Related Posts:

Related Posts with Thumbnails