Dynamics Gp Partner Newsflash: Crystal Reports For Great Plains

Home | Computers-and-Technology | Software

Crystal Reports are popular, even considering the fact that you can deploy preset or develop new free reports in Microsoft SQL Server Reporting Services or SSRS. Crystal Reports designer is very traditional tool and there are a lot of CR designers and IT professionals, who are very comfortable to support Crystal Reports for Microsoft Dynamics GP former Great Plains. In this small publication we would like to give you highlights on Crystal Reports Design and Deployment for Dynamics GP via remote web sessions, or remote desktop connections USA and Canada nationwide:

1.Dynamics GP tables structure and DB platform. Great Plains Dynamics GP, starting with version 8.0 is available on Microsoft SQL Server only. GP 8.0 was compatible with SQL 2000 (or MSDE) and GP 9.0 and 10.0 is compatible with both: Microsoft SQL Server 2000/MSDE and Microsoft SQL Server 2005/MS SQL Express. To review Dynamics GP business processes data flow and tables structure you can install Dynamics GP SDK from CD #2 or simply look the structure in GP interface: Dynamics GP->Tools->Resource Description->Tables/Forms/Fields

2.Dynamics GP Crystal Reports design best practices. If you are making first steps with CR, you should review report design wizard, however this approach is not recommended for production reports. In production, Crystal Report should be based off SQL Server Stored Procedure (where CR automatically maps procedure parameters into report parameters, plus you have unlimited power of temporary tables where direct select statement and unionizing do not help), or SQL view. Dynamics GP company and system databases allow you to add custom objects, such as SQL stored procedure or custom SQL view

3.Crystal Reports niche. In Great Plains Dynamics GP you typically deploy Crystal Reports where you are building industry specific reports: Sales by product/salesperson/region/class, to give you good example. If you are looking for strictly financial reports: P&L, Balance Sheet, Statement of Cash Flow consider FRx, CR is not the best choice

About the Author:
Andrew Karasev, Alba Spectrum LLC, help@albaspectrum.com 1-866-528-0577, http://www.albaspectrum.com. Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta. Information portal: http://www.pegasplanet.com We serve you USA and Canada nationwide from our Dynamics GP call center: California, Illinois, New York, Florida, Minnesota, New Jersey, North and South Carolina, Georgia, Louisiana, Texas, Ontario, Quebec

Article Originally Published On: http://www.articlesnatch.com

Tags: Dynamics GP

Related....

Videos...

Recent Software Articles

Iskysoft Updates -1080p Output Video For New Ipad(ipad 3), Apple Tv 3 By: Lorin Young | May 31st 2012 - iSkysoft today released two new updates for its iMedia Converter for Mac and iMedia Converter Deluxe for Mac

DVD to iPad 3 Converter for Mac

Convert DVD to iPad 3 mac

How To View, Edit, And Fill Word, Excel Document In Asp.net Application Or Java Web Application By: Nancy Stewart | May 31st 2012 - As we know, it's impossible to view, edit Microsoft Office documents directly on Web pages for many years. But Aceoffix can do that for you. Without installing Office at the server side, web developers can easily embed and call Office in web pages.

Create Your Video Sharing Service Like Youtube Using Joomla Youtheme By: Nancycatherine | May 31st 2012 - With the success of YouTube, similar online video sharing website has popped up like mushrooms, taking the media world by storm.

Boost Your Web Traffic & Revenue With Wordpress Review Plugin By: Henry William | May 31st 2012 - One of the best ways of making money online is by reviewing products and services. Most often, before a consumer decides to pay for a good or a service, they will always search for expert or consumer review in order to learn how the product works, and what they sho ...

Review Writer

Review Software

WordPress Commenting Tool

Ruby On Rails Platform Setup By: Annie | May 31st 2012 - To program most Ruby programs, Ruby on Rails programmer / developer needs virtually only two things: a basic text editor and a Ruby interpreter (usually MRI). Developing Rails applications might involve quite a few more tools. The following is a list of things a pr ...

Ruby on rails developers

Ruby on rails programmers

Best Practices For Custom Application Development By: christa joe | May 31st 2012 - Custom applications help businesses to deploy software technology in their operational processes, according to their needs and requirements. This helps to optimize and manage the functional and operational expertise.

Custom Application development

software development

Mobile Application Development India & Its Extensions. By: Victor Parker | May 31st 2012 - Mobilization flexibility has reached the seventh sky in terms of latest technology. The various mobile applications have been invented for better compatibility and easily used by the users. IT sector has emphasized on Mobile application development which has enhanc ...

Mobile application development India

Open Source Technology Services India & Its Benefits To E-business. By: Victor Parker | May 31st 2012 - In simple words open source refers technologies which are independent to users. It has given the vast platform to the IT solutions. This product is highly recommended in the market and it is more powerful than other commercially products available. It has changed t ...

Open source technology company India

Perfect Online Data Visualization With Html5 (javascript) Gauges? By: Tatyana Ufimskaya | May 31st 2012 - Online data visualization is very popular nowadays since it offers such advantages as getting data in real time and access from any location and device. More and more companies move their information monitoring and dashboard apps to web. And here they face some pro ...

html5 gauges

javascript gauges

Take Care Of Your Lifeline"��! By: eScan Antivirus | May 31st 2012 - When we say the advancement of technology has influenced humanity in the various aspects of life that governs almost all acts of man out of some of the few important inventions, I find Credit Cards as the prominent.

Anti-Phishing Working Group

Anti-Virus

Cyber Crime

Cyber Terrorism

Comments

Still can't find what you are looking for? Search for it!

Site Navigation: