Consulting services
Intellitec Methodology
Industry Solutions
Gold Certified
Need a Dynamics Partner?
click here
Product offerings
Microsoft CRM
Microsoft CRM Online
Microsoft Dynamics SL
Microsoft Dynamics GP
Cloud Services
3rd Party Products
Success Stories
Springpoint Senior Living
standardized financial management
Dogfish Head Craft Brewery
microbrewer sees explosive growth
Penske Racing
drives success with Dynamics SL
CTI
improved billing cycle
Certified Microsoft Dynamics Consultants
Microsoft Dynamics GP Version 10.0
(Formerly Great Plains)
Dynamics GP SQL Reporting Services
No matter how carefully and accurately you enter and post transactions, without reports, your accounting data is of limited value. When stored in Microsoft SQL Server data tables, your data is something like books in a library that don’t seem to be stored in a clear order and whose titles are in code. Microsoft Dynamics GP provides a number of ways to quickly access your data in useable formats, in addition to giving you multiple ways of designing the exact reports you need. Here is some background information on how reports work in Microsoft Dynamics GP.
The following information refers to Report Writer reports. Report Writer is a tool that is included with Microsoft Dynamics GP. You also can install the SQL Reporting Services reports, which use the reporting tool for the SQL Server database. See the System Setup Guide for information about installing SQL Reporting Services reports.
While a report might appear to be a simple listing of numbers and some text, reports are made up of two parts that work together to present information in a useful form.
A report layout determines the type of information that can be included on that report, as well as where each piece of information appears on the page. The report layout does not specify sorting criteria or ranges of information, such as accounts, inventory items, or customers. That information is specified in a report option, which can be saved and reused to make printing reports that show specific information, sorted in specific ways, fast and easy to print.
You can create as many report options for a report layout as you need, but Microsoft Dynamics GP comes with many report layouts and report options already defined. To see examples of some predefined reports that have been printed using the sample data, refer to the sample reports.
When you create a new report or modify an existing report, that report layout is stored in the reports dictionary. The reports dictionary is created when Report Writer is accessed for the first time. All the reports you modify or create with Report Writer are stored in the reports dictionary.
In addition to Report Writer or SQL Reporting Services reports, you can use Crystal Reports for Microsoft Dynamics GP to design new reports for Microsoft Dynamics GP data using the industry standard Seagate Crystal Reports.
Request more information about Intellitec Solutions and Microsoft Dynamics GP.