Index

A

• About This Page feature
  • about / Implementing cues and colored indicators
• array / Trans headers and footers

B

• barcodes
  • printing / Printing barcodes
• Binary Large Object (BLOB)
  • about / Optimize the usage of BLOB fields
• BLOB field usage
  • optimizing / Optimize the usage of BLOB fields
• bookmark
  • used, for creating links / Using a bookmark
• buffer table
  • using / Using placeholders
  • used, for creating dataset / Using a temporary table
• built-in layout
  • about / Built-in and custom layouts
• business chart
  • about / Business charts
  • advantages / Business charts
  • creating / Creating a business chart
  • defining / Creating a business chart
  • types / Creating a business chart
  • information, displaying / Drill down your business chart
  • user personalization, preserving / Preserving the user personalization

C

• caching
  • about / Caching
• captions and labels
  • including / Including captions and labels
  • IncludeCaption, versus FIELDCAPTION / IncludeCaption versus FIELDCAPTION
  • dataset, flattening / How is the dataset flattened?, Unrelated tables or multiple data items, without indentation, Related tables or multiple data items with indentation
• CEILING function / A fixed number of rows
• charts
  • optimizing / Using charts
• code unit
  • using / Using placeholders
• collections
  • about / Collections
  • Globals / Collections
  • User / Collections
  • Fields / Collections
  • Parameters / Collections
  • ReportItems / Collections
  • Datasets / Collections
  • Variables / Collections
• colored indicators
  • about / Colored indicators
  • setting up, URL / Colored indicators
• Common Language Specification (CLS)
  • about / Data items and columns – fields, variables, and expressions
  • URL / Data items and columns – fields, variables, and expressions
• complex expression
  • about / Simple and complex expressions
• conditional formatting
  • using / Decision functions
  • used, in report / Conditional formatting in a report
• cues and colored indicators
  • implementing / Implementing cues and colored indicators
  • activities page / A typical activities page
  • cue table / A typical cue table
• cue style objects, in Dynamics NAV
  • about / Cue style objects in Dynamics NAV
• Cue table
  • URL / A typical cue table
• custom functions
  • creating / Creating custom functions
• custom layout
  • about / Built-in and custom layouts
• Custom Numeric Format Strings
  • URL / Formatting report items

D

• dashboard
  • references / Power View, Power Map
• data analysis
  • with data bars / Analyzing your data with data bars and indicators
  • with indicators / Analyzing your data with data bars and indicators
• data model
  • building / Building the data model
  • report dataset designer, defining / Understanding the report dataset designer
  • dataset, building / Building the dataset
  • captions and labels, including / Including captions and labels
  • report triggers / Report triggers
  • defining / The data model
  • multilanguage, implementing / Implementing multilanguage
  • address formatting / Address formatting
  • logos, including / Including logos
  • No of Copies option / The No. of Copies option
  • totaling and VAT / Totaling and VAT
  • logging / Logging and No. Printed
  • No Printed / Logging and No. Printed
  • InitializeRequest / InitializeRequest
  • references / Power View
• data regions
  • about / Report items
• dataset
  • building / Building the dataset
  • data items / Data items and columns – fields, variables, and expressions
  • columns / Data items and columns – fields, variables, and expressions
  • defining / The dataset
  • techniques / The dataset
  • captions and labels / Captions and labels
  • unused columns, removing / Remove unused columns
  • unnecessary rows, avoiding / Avoid unnecessary rows
  • report totals / Report totals
  • number formatting / Number formatting
  • correct filters, applying / Applying the correct filters
  • recommendations, of Dynamics NAV / Recommendations according to the version of Dynamics NAV
  • building, alternatives / Alternatives for building a faster dataset
  • temporary table, using / Using a temporary table
  • query object, using for / Using a query object for the dataset
• data visualization
  • about / An introduction to data visualization
• date format codes
  • URL / Working with strings
• design guidelines
  • reporting / Reporting design guidelines
• document
  • defining / What is a document?
• document reports
  • about / What is a report?
• Dynamics NAV
  • reference link, for blog / Report templates
• Dynamics NAV charts
  • setup, using / Preserving the user personalization
• Dynamics NAV OData web service
  • calling / Calling a Dynamics NAV OData web service
• Dynamics NAV Team blog
  • URL / Applying the correct filters
• Dynamics NAV versions
  • URL / Recommendations according to the version of Dynamics NAV
• Dynamics NAV web services
  • about / Dynamics NAV web services
  • URL / Dynamics NAV web services

E

• entity relationship (ER) model
  • about / The data model phase
• ESRI shape file
  • selecting / Using maps
• Excel
  • using / Using Excel
  • Power Pivot, activating / Activating Power Pivot in Excel
• expression examples
  • about / Typical expression examples
  • working, with dates / Working with dates
  • working, with strings / Working with strings
  • decision functions / Decision functions
  • page breaks, generating in code / Generating page breaks in code
  • column header, repeating on every page / Repeating a column header on every page
• expression language
  • defining / The expression language
  • rules / The expression language
• expression placeholders
  • symbols, using / Symbols used in expression placeholders
• expressions
  • using, for properties / Using expressions for properties
  • expression language / The expression language

F

• FIELDCAPTION function
  • about / Implementing multilanguage
• filter
  • used, for creating links / Using a filter
• filtering
  • about / Filtering and sorting
• filters
  • implementing / How can I implement filters?
  • properties / How can I implement filters?
  • reference link / Using a filter
• fixed header problem
  • about / The fixed header problem
• FLOOR function / A fixed number of rows
• Format() function
  • URL / Working with strings

G

• generic chart designer
  • about / The generic chart designer
  • text management / Text management
  • list, displaying as chart / Show any list as a chart
• Get function
  • implementing / Implementing the Get and Set functions
• GETURL() function
  • used, for creating links / Using the GETURL() function
• global variable and functions
  • declaring / Declaring the global variable and functions
• green-bar-matrix example
  • defining / Example – the green-bar-matrix
• green-bar effect
  • about / Decision functions
• grouping
  • about / Grouping
  • implementing / How can I implement grouping?
  • parent-child group, adding to Tablix / Adding a parent-child group to a Tablix
  • expand/collapse, implementing / How do I implement expand/collapse?
  • adjacent group, adding to Tablix / Adding an adjacent group to a Tablix

H

• headers and footers
  • working with / Working with headers and footers
  • GetData, defining / GetData and SetData explained
  • SetData, defining / GetData and SetData explained
• hotfixes
  • implementing / Implementing hotfixes and rollup updates
• HTML tags
  • about / Using placeholders

I

• information, visualizing
  • defining / Learning how to visualize information with gauges, maps, and charts
  • gauges, using / Using gauges
  • charts, using / Using charts
  • maps, using / Using maps
• internal bookmarks
  • used, for creating links / Using internal bookmarks
• Item Dashboard Report
  • creating / Example – create an item dashboard report

J

• Jet Reports Express
  • URL / Creating a Word report layout
• Jet Reports website
  • URL / Optimizing your dataset for Word reports

L

• layout
  • creating / Creating the layout
  • Visual Studio, versus Report Builder / Visual Studio versus Report Builder
  • creating, in Report Builder / Creating a simple layout in Report Builder
  • creating, in Visual Studio / Creating a simple layout in Visual Studio
  • building / Building and testing the layout
  • testing / Building and testing the layout
  • about / The layout
  • dataset, filtering / Filtering the dataset
  • headers and footers, working with / Working with headers and footers
  • page x of y, implementing / How do I implement page x of y?
  • defining / The layout
  • print layout, versus print preview / Print layout versus print preview
  • conditional visibility, avoiding on big dataset / Avoid conditional visibility on a big dataset
  • visualizing information, best practices / Best practices when visualizing information
  • expressions, in page header or footer / Expressions in the page header or footer
  • complex grouping / Complex grouping and aggregate functions
  • aggregate functions / Complex grouping and aggregate functions
  • optimization, for rendering format / Optimization for the chosen rendering format
  • report design guidelines / Report design guidelines
• layouts
  • managing, in code / Managing layouts in code
• license file
  • about / Using a temporary table
• links
  • creating / Creating links
  • creating, filter used / Using a filter
  • creating, bookmark used / Using a bookmark
  • creating, GETURL() function used / Using the GETURL() function
  • creating, internal bookmarks used / Using internal bookmarks
• List
  • versus Table / List versus Table versus Matrix
  • versus Matrix / List versus Table versus Matrix

M

• Matrix
  • versus List / List versus Table versus Matrix
  • versus Table / List versus Table versus Matrix
• Microsoft report and user interface design guidelines
  • URL / Report design guidelines
• mini-document
  • about / Alternative solutions – the mini-document

N

• Notepad
  • URL / Remove unused columns
• Notepad++
  • URL / Remove unused columns

O

• objects
  • URL / Creating a business chart
  • defining / Cue style objects in Dynamics NAV
• OData web services
  • references / Power BI Designer

P

• pagination and layout
  • testing, in different rendering extensions / Testing pagination and layout in different rendering extensions
• performance recommendations
  • about / Performance recommendations
  • dataset, creating / The dataset
  • layout / The layout
• PowerBI.com
  • about / PowerBI.com
  • URL / PowerBI.com
• Power BI and Q&A
  • references / PowerBI.com
• Power BI Designer
  • about / Power BI Designer
  • URL / Power BI Designer
• Power Map
  • about / Power Map
• Power Pivot
  • defining / Power Pivot
  • activating, in Excel / Activating Power Pivot in Excel
  • data model, building / Building a Power Pivot data model
  • data, importing into / Importing data into Power Pivot
  • relations, creating / Creating relations in the Power Pivot data model
• Power Pivot Excel data model
  • URL / Creating relations in the Power Pivot data model
• Power Query
  • about / Power Query
• Power View
  • about / Power View
• print support
  • URL / The report viewer
• ProcessingOnly report
  • defining / What is a ProcessingOnly report?

Q

• Query Execution Plan (QEP)
  • about / Using stored procedures
• Query object
  • URL / Importing data into Power Pivot

R

• recipes
  • used, for implementing top x filtering / Recipes to implement top x filtering
• report
  • about / What is a report?
  • request page / The request page
  • viewer / The report viewer
  • testing, in different clients / Testing the report in different clients – Windows, Web, and tablet
  • creating, in SSRS / Creating a report in SSRS
  • creating / The next step
• Report Builder
  • layout, creating / Creating a simple layout in Report Builder
  • features / Report Builder features
  • wizards, for prototyping / Wizards for prototyping
• Report creation workflow
  • about / The report creation workflow
• Report Description
  • about / The report description
• report design guidelines
  • URL / Reporting design guidelines
• report development phases
  • about / Report development phases
  • data model phase / The data model phase
  • layout phase / The layout phase
  • testing phase / The testing phase
• report development tools
  • about / Report development tools
  • data model, developing / What do I use to develop the data model?
  • report layout, creating / How do I create the report layout?
• report execution flow
  • about / The report execution flow
  • Word report execution flow / The Word report execution flow
• Reporting Services
  • about / What are Reporting Services?
  • URL / Installation and configuration
• reporting user
  • using / Creating a report in SSRS
• Report items
  • formatting / Formatting report items
  • placeholders, using / Using placeholders
  • Cangrow property / Important properties – CanGrow and CanShrink
  • CanShrink property / Important properties – CanGrow and CanShrink
• report items
  • defining / Report items, Shared report parts
• report layouts
  • managing / Managing report layouts
  • Custom Layouts button, selecting / Custom layouts
  • Custom RDLC layout, editing / Editing a Custom RDLC layout
• report logging
  • about / Report logging
• Report Manager
  • about / Installation and configuration
  • URL / Installation and configuration, Creating a report in SSRS
• report pagination
  • about / Report pagination
• reports
  • scheduling / Scheduling reports
• report server
  • installing / Installation and configuration
  • configuring / Installation and configuration
• Report Server
  • URL / Creating a report in SSRS
• Report Server Project Template
  • URL / Using SQL Server Data Tools
• report setup table
  • using / Using a report setup table
• report templates
  • about / Report templates
• Report Totals Buffer
  • about / Alternative solutions – the mini-document
• report triggers
  • about / Report triggers
  • report, running / What happens when a report runs?
  • sequence / The report trigger sequence
• request page
  • about / The request page
• reusability
  • implementing / Implementing reusability
  • shared data sources / Shared data sources and datasets
  • datasets / Shared data sources and datasets
  • shared report parts / Shared report parts
  • functions, creating / Creating functions
  • stored procedures, using / Using stored procedures
• reusable custom functions
  • about / Creating custom functions
• Roles and Profiles
  • URL / Business charts
• rollup updates
  • implementing / Implementing hotfixes and rollup updates
• RowNumber function / A fixed number of rows
• run and run modal
  • about / Scheduling reports

S

• scheduling
  • about / Subscribing or scheduling
• scope
  • defining / Understanding the scope of an expression
• Section Designer / Trans headers and footers
• Set function
  • implementing / Implementing the Get and Set functions
• simple expression
  • about / Simple and complex expressions
• snapshots
  • about / Caching
• sorting
  • about / Filtering and sorting
  • implementing / How can I implement sorting?
  • interactive sorting / Interactive sorting
• Sparklines
  • used, for visualizing trends / Using Sparklines to visualize trends
• SQL Server Evaluation version
  • URL / Installation and configuration
• SQL statement
  • SELECT / Using a query object for the dataset
  • FROM / Using a query object for the dataset
  • JOIN Type / Using a query object for the dataset
  • ON / Using a query object for the dataset
  • WHERE / Using a query object for the dataset
  • HAVING / Using a query object for the dataset
  • GROUP BY / Using a query object for the dataset
  • ORDER BY / Using a query object for the dataset
  • TOP / Using a query object for the dataset
• SSDT-BI
  • URL / Creating a report in SSRS
• SSRS
  • report, creating / Creating a report in SSRS
  • SQL Server Data Tools, using / Using SQL Server Data Tools
  • report project, publishing / Publishing a report project
• Standard Date and Time Format Strings
  • URL / Formatting report items
• standard reports
  • URL / What is a report?
• static and dynamic rows
  • URL / How can I implement grouping?
• static report items
  • defining / Report items
• subscribing
  • about / Subscribing or scheduling

T

• Table
  • versus Matrix / List versus Table versus Matrix
  • versus List / List versus Table versus Matrix
• table header
  • repeating / Repeating a table header
• Tablix
  • defining / Everything is a Tablix
  • Document Outline window, opening / The Document Outline
  • about / The Document Outline
  • name, changing / Changing the name of a Tablix
• TED
  • URL / Power View
• temporary table
  • disadvantage / Using a temporary table
  • about / Using a temporary table
• textbox format property
  • URL / Formatting report items
• tips and tricks, reports layouts
  • report pagination / Report pagination
  • footer or header, displaying on last page / Show a footer or header on the last page
  • information, placing in bottom of page / Place at the bottom
  • fixed number of rows / A fixed number of rows
  • transheader / Trans headers and footers
  • transfooter / Trans headers and footers
  • links, creating / Creating links
  • barcodes, printing / Printing barcodes
  • report templates / Report templates
  • report setup table, using / Using a report setup table
  • report logging / Report logging
  • fixed header problem / The fixed header problem
• top x filtering
  • implementing, recipes / Recipes to implement top x filtering
• transfooter
  • about / Trans headers and footers
• transheader
  • about / Trans headers and footers

U

• unused columns
  • variables and setup information / Variables and setup information
• User Access Control (UAC)
  • about / Creating a report in SSRS

V

• version, of Visual Studio
  • URL / Visual Studio versus Report Builder
• Visual Basic functions supported, in expressions
  • URL / The expression language
• Visual Studio
  • layout, creating / Creating a simple layout in Visual Studio
  • features / Visual Studio features
  • report formatting / Report formatting, toolbars, and document outline
  • toolbars / Report formatting, toolbars, and document outline
  • document outline / Report formatting, toolbars, and document outline

W

• Waldo
  • URL / Implementing hotfixes and rollup updates
• web service
  • about / Dynamics NAV web services
  • types / Dynamics NAV web services
  • URL / Dynamics NAV web services
• Windows Azure Marketplace
  • URL / Importing data into Power Pivot
• Word report
  • dataset, optimizing for / Optimizing your dataset for Word reports
• Word report execution flow
  • about / The Word report execution flow
  • at design time / At design time
  • at runtime / At runtime
• Word report layout
  • defining / Introducing the Word report layout
  • limitations / Introducing the Word report layout
  • advantages / Introducing the Word report layout
  • creating / Creating a Word report layout
  • formatting / Formatting the Word report layout
  • Word templates, using / Using Word templates

X

• XML data sources, querying
  • URL / Calling a Dynamics NAV OData web service

Y

• Year To Date (YTD)
  • about / Working with dates