Microsoft Dynamics NAV 2009: Professional Reporting电子书

Microsoft Dynamics NAV 2009: Professional Reporting

Table of Contents

Microsoft Dynamics NAV 2009: Professional Reporting

Credits

About the Author

Acknowledgement

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers and more

Why Subscribe?

Free Access for Packt account holders

Instant Updates on New Packt Books

Preface

What this book covers

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the example code

Errata

Piracy

Questions

1. Charts and Dimensions

Role Centers

Charts

Chart panes

Limitations of chart panes

Chart parts

Chart security

Chart performance

Reports

List reports

Test reports

Posting reports

Transaction reports

Document reports

Other reports

Printing reports

Determining print report settings

Printer selection

Report selections

Creating reports without development tools

What are dimensions?

Global

Shortcut

Budget

Where are dimensions set up?

Dimensions and dimension values

Dimension values

Dimension combinations

Default dimensions

View posted dimension information

Analysing financial information using dimensions

Dimension-based reports

Summary

2. Creating a Report in the Classic Client

The Report Designer

Using the report wizard

Form type report

Tabular type report

Label type report

Creating a simple List report

Sorting and grouping data in a report

Sections in a classic report

Controls

Triggers

What happens when a report runs?

How is a data item processed?

Properties in a report

Adding color to a classic report

What is a ProcessingOnly report?

Creating an Excel-like layout for a report

Printing a report to Excel

What is so special about the Excel Buffer table (370)?

Report functions

Summary

3. Creating Role Tailored Reports

The optional enhanced layout

Why you cannot call it Reporting Services

Difference between RDL and RDLC?

Printed reports versus online reports

Creating your first enhanced report

What's happening?

Adding formatting, grouping, sorting, and filtering to a report

Report creation workflow

Using multiple data items

Using the Create Layout Suggestion option

Changing the template

Making a report available in the Role Tailored client

Limitations of enhanced report design in Dynamics NAV 2009

Summary

4. Visualization Methods

Report items

Common report item properties

Text box

List data regions

Document Outline

What is the List control used for?

Undo/Redo

Matrix boxes

More advanced matrix techniques

Using colors in a matrix

Green bar matrix

Chart data regions

Adding images to your report

Expanding/collapsing report sections

Interactive sorting

Using the document map

Linking reports

Bookmark links

Hyperlinks

Filtering a report

Filtering a page

Multi-column reports

Headers and footers

Expressions

The Fields collection

The Globals collection

The ReportItems collection

The User collection

Functions

Useful tips and techniques

Use a title, page numbers, and show applied filters

Using rectangles, lines, and images

Adding a report border

Tracking report usage

Checking on empty datasets

Using a report layout setup table

Blanking properties

Pagination

Use rectangles

Give everything a proper name

Test, test, and test

Summary

5. Developing Specific Reports

Document reports

The number of copies option

Displaying data-bound information in the header

Working with addresses in reports

Displaying the current page and copy number

TOP X reports

Creating a TOP X table

Creating a TOP X chart

Using the wizard

Adding KPIs and conditional formatting

Simulating data bars

Simulating spark lines

Implementing conditional formatting

Choosing the right colors

Summary

6. Other Reporting and Business Intelligence Tools

Knowing your data and database

Dynamics NAV database design

How is the Dynamics NAV database created in SQL Server?

Relations and foreign keys

Using an Entity Relationship model

Reporting Services

Using Report Builder

Using BIDS

Comparing RDL and RDLC

Using Microsoft Excel with Dynamics NAV

Excel Data Mining Add In

PowerPivot

Business Intelligence and NAV

Business Analytics

The advantage of having a BI solution

Summary

7. A View of the Future

Dynamics NAV 7 and beyond

Jet Reports Express

RDLC mandatory and 2008 integration

Section designer replaced with an extended data item designer

Dynamics NAV and SharePoint

Dynamics NAV in the cloud

What will SQL Server do?

Project Crescent

BISM

Summary

Index