[ B E N E F I T S ] Reduce the learning curve for creating reports Microsoft SQL Server Reporting Services offer eight reports for Sales, Purchasing, and Manufacturing analyses that work with both the Microsoft Dynamics GP sample database and your organizational data, making it easy for users to learn how they can quickly build reports and manipulate information. Tailor reports to your organizational needs Use the sample reports either as-is or as templates for designing new reports. With customizable report templates at hand, your decision makers and employees can easily and efficiently take full advantage of SQL Server Reporting Services for Sales, Purchasing, and Manufacturing analyses. Quickly access SQL reports from within Microsoft Dynamics GP Maintain one-click access to the reports you use most often by storing them in a personalized My Reports list within Microsoft Dynamics GP. Integrated architecture supports a range of common data sources Reports integrates with OLE DB and the Open Database Connectivity (ODBC) interface, as well as with multiple output formats such as those used by familiar Web browsers and Microsoft Office System applications. Leverage existing IT capabilities Using Microsoft Visual Studio .NET and the Microsoft .NET Framework, developers can leverage the capabilities of their existing information systems and connect to custom data sources, produce additional output formats, and deliver to a variety of devices. Build on your current system capabilities Using the familiar, widely-used Microsoft Office Excel 2003 interface, you can get even new employees up to speed quickly, without extensive training.

Seamless integration gives you the freedom to extend data formats and access SQL reports from within Microsoft DynamicsT GP, to share across your organization.

Microsoft product screenshot(s) reprinted with
permission from Microsoft Corporation.
[ click to view ]

SQL SERVER REPORTING SERVICES helps summarize your data in Web-based charts and graphs. Build reports to support specific business activities, and share vital information across your organization.

ONLINE VIEWS offer forecasting insights that are easy to share across your organization or with designated vendors or contractors.

Take Full Advantage of Microsoft SQL Server Reporting Services
SQL Server Reporting Services offer eight reports for Sales, Purchasing and Manufacturing that are designed to work with both the Microsoft Dynamics GP sample database and with your organization's data. Reports can be used out of the box or as customizable templates within the Report Designer.

• Commissions Report: Expandable views of sales commissions by territory, salesperson, and year, including views of quarterly commissions by territory.
• Customer Profitability Report: Sales, total profit, and gross margin percentage per customer for the selected year. Expandable customer ID offers a view of sales, total profit, and gross margin percentage by document number.
• Inventory Value by Site Report: Bar graph of the value of inventory by site and the total inventory value for the company. Clickable inventory site bars display Inventory value by Site. Use the Item Number Report to view items and their total value for that site.
• Item Quantity Back Order Report: Quantity of items that are back ordered, quantities allocated to purchase orders, and item quantities available for all sites.
• Open Purchase Orders Report: Purchase orders that have not been closed or canceled per vendor or for all vendors, including list views for the number, status, and date of each purchase order, assigned vendor, and line item detail.
• Open Sales Orders Report: Unposted sales orders for a range of customers, including list views for the sales order number and date, customer information, requested ship date, amount remaining, assigned salesperson, and line item detail.
• Work Center by Weeks-Employee Capacity Report: Available work centers and the employee capacity of each work center by weeks.
• Work Center by Weeks-Machine Capacity Report: Available work centers and the machine capacity of each work center by weeks.

Easy Access to Report Formats
Access reports easily from within Microsoft Dynamics GP, including one-click access from your personalized My Reports list of frequently used formats.

Drilldown Actions
Use drilldown links to open a report from within a report, such as a detailed report from a summary report. This gives key decision-makers the ability to view essential information at a glance.

Chart Options
Take advantage of report layout options such as pie-, line-, or bar-chart capabilities to highlight key information or enhance presentations.

Customized Filtering
Filter report data using either dynamic or hierarchical parameters.

Flexible Report Views
Use a collapsible report view to expand sections, reducing complex reports to manageable proportions.

Subreports
Create subreports within another report, or bind a main report to one or more subreports through a set of parameters.

Table View
This report layout option quickly presents the data in a table format for easier viewing and distribution across your business.

Microsoft SQL Server 2005
Invest in your company's future with no worries. SQL Server Reporting Services are compatible with Microsoft SQL Server 2005.
 

 Top of page