Microsoft Dynamics NAV 2015 Professional Reporting电子书

Microsoft Dynamics NAV 2015 Professional Reporting

Table of Contents

Microsoft Dynamics NAV 2015 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

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the color images of this book

Errata

Piracy

Questions

1. How Do I Start to Create a Report?

What is a report?

The request page

The report viewer

Report development phases

The data model phase

The layout phase

The testing phase

Report development tools

What do I use to develop the data model?

How do I create the report layout?

Built-in and custom layouts

Building the data model

Understanding the report dataset designer

Building the dataset

Data items and columns – fields, variables, and expressions

Including captions and labels

IncludeCaption versus FIELDCAPTION

How is the dataset flattened?

Unrelated tables or multiple data items, without indentation

Related tables or multiple data items with indentation

Report triggers

What happens when a report runs?

The report trigger sequence

What is a ProcessingOnly report?

Creating the layout

Visual Studio versus Report Builder

Creating a simple layout in Report Builder

Report Builder features

Wizards for prototyping

Creating a simple layout in Visual Studio

Visual Studio features

Report formatting, toolbars, and document outline

Building and testing the layout

Testing pagination and layout in different rendering extensions

Testing the report in different clients – Windows, Web, and tablet

Reporting design guidelines

The request page

The report description

The report creation workflow

Summary

2. Getting Started with the Tablix

Report items

Everything is a Tablix

The Document Outline

Changing the name of a Tablix

List versus Table versus Matrix

Filtering and sorting

How can I implement filters?

How can I implement sorting?

Interactive sorting

Grouping

How can I implement grouping?

Adding a parent-child group to a Tablix

How do I implement expand/collapse?

Adding an adjacent group to a Tablix

Formatting report items

Using placeholders

Important properties – CanGrow and CanShrink

Example – create an item dashboard report

Summary

3. Expressions

Using expressions for properties

The expression language

Simple and complex expressions

Symbols used in expression placeholders

Collections

Understanding the scope of an expression

Creating custom functions

Typical expression examples

Working with dates

Working with strings

Decision functions

Generating page breaks in code

Repeating a column header on every page

Example – the green-bar-matrix

Summary

4. Data Visualization Techniques

An introduction to data visualization

Recipes to implement top x filtering

Conditional formatting in a report

Analyzing your data with data bars and indicators

Using Sparklines to visualize trends

Learning how to visualize information with gauges, maps, and charts

Using gauges

Using charts

Using maps

Summary

5. Document Reports

What is a document?

The data model

Implementing multilanguage

Address formatting

Including logos

The No. of Copies option

Totaling and VAT

Logging and No. Printed

InitializeRequest

The layout

Filtering the dataset

Working with headers and footers

GetData and SetData explained

Declaring the global variable and functions

Implementing the Get and Set functions

Alternative solutions – the mini-document

How do I implement page x of y?

Summary

6. Tips and Tricks

Report pagination

Show a footer or header on the last page

Place at the bottom

A fixed number of rows

Trans headers and footers

Creating links

Using a filter

Using a bookmark

Using the GETURL() function

Using internal bookmarks

Printing barcodes

Report templates

Using a report setup table

Report logging

The fixed header problem

Summary

7. Performance Optimization Techniques

Performance recommendations

The dataset

Captions and labels

Remove unused columns

Optimize the usage of BLOB fields

Variables and setup information

Avoid unnecessary rows

Report totals

Number formatting

Applying the correct filters

Recommendations according to the version of Dynamics NAV

The layout

Print layout versus print preview

Avoid conditional visibility on a big dataset

Best practices when visualizing information

Expressions in the page header or footer

Complex grouping and aggregate functions

Optimization for the chosen rendering format

Report design guidelines

Implementing hotfixes and rollup updates

Alternatives for building a faster dataset

Using a temporary table

Using a query object for the dataset

Summary

8. Word Report Layouts

Introducing the Word report layout

Creating a Word report layout

Formatting the Word report layout

Repeating a table header

Using Word templates

Optimizing your dataset for Word reports

Managing report layouts

Custom layouts

Editing a Custom RDLC layout

The report execution flow

The Word report execution flow

At design time

At runtime

Managing layouts in code

Scheduling reports

Summary

9. Power BI

Dynamics NAV web services

Using Excel

Power Pivot

Activating Power Pivot in Excel

Building a Power Pivot data model

Importing data into Power Pivot

Creating relations in the Power Pivot data model

Power View

Power Map

Power Query

Power BI Designer

PowerBI.com

Summary

10. Reporting Services

What are Reporting Services?

Installation and configuration

Creating a report in SSRS

Using SQL Server Data Tools

Publishing a report project

Implementing reusability

Shared data sources and datasets

Shared report parts

Creating functions

Using stored procedures

Calling a Dynamics NAV OData web service

The next step

Caching

Subscribing or scheduling

Summary

11. Charts in Dynamics NAV

The generic chart designer

Text management

Show any list as a chart

Business charts

Creating a business chart

Drill down your business chart

Preserving the user personalization

Implementing cues and colored indicators

A typical activities page

A typical cue table

Colored indicators

Cue style objects in Dynamics NAV

Summary

Index