Index

A

• About this Report feature / Creating your first enhanced report
• About this report feature / Displaying data-bound information in the header
• ABS function / The number of copies option
• aggregate functions, datatypes
  • Avg / Functions
  • Count / Functions
  • CountDistinct / Functions
  • CountRows / Functions
  • First / Functions
  • Last / Functions
  • Max / Functions
  • Min / Functions
  • RowNumber / Functions
  • RunningValue / Functions
  • StDev / Functions
  • StDevP / Functions
  • Sum / Functions
  • Var / Functions
  • VarP / Functions
• applied filters
  • showing / Creating a TOP X reportsSort on windowTOP X table
• array variables
  • CustAddr / Working with addresses in reports
  • ShipToAddr / Working with addresses in reports
  • CompanyAddr / Working with addresses in reports
• AS IS situation / Business Intelligence and NAV
• automation / What is so special about the Excel Buffer table (370)?
• AVG function / Functions

B

• BackGroundColor property / Implementing conditional formatting
• BackgroundColour property / Common report item properties
• Backgroundcolour property / Using colors in a matrix
• BISM / BISM
• budget dimensions
  • about / Budget
• Business Intelligence
  • and Dynamics NAV / Business Intelligence and NAV
  • OLAP data model / Business Intelligence and NAV
  • SSIS / Business Intelligence and NAV
  • BA / Business Analytics
  • BA, advantages / Business Analytics
  • BA, reporting tool / Business Analytics
  • advantage / The advantage of having a BI solution

C

• '(comment) sign / Displaying data-bound information in the header
• C/AL Code button / The number of copies option
• CalcPct2 function / Adding KPIs and conditional formatting
• CalcPct function / Adding KPIs and conditional formatting
• Caption fields / Displaying data-bound information in the header
• cells
  • merging / Creating a TOP X reportsSort on windowTOP X table
• cells-in-cells technique / Green bar matrix
• chart
  • layouts / Chart parts
  • data regions / Chart data regionsmatrix boxgreen bar matrixmatrix boxadvanced techniques
  • areas / Chart data regionsmatrix boxgreen bar matrixmatrix boxadvanced techniques
  • types / Chart data regionsmatrix boxgreen bar matrixmatrix boxadvanced techniques
  • subtypes / Chart data regionsmatrix boxgreen bar matrixmatrix boxadvanced techniques
• chart, operators
  • count / Chart parts
  • sum / Chart parts
• chart, types
  • point / Chart parts
  • column / Chart parts
• chart creation
  • limitations / Chart parts
• chart definition
  • example / Chart parts
• Chart Generator Card
  • about / Chart parts
• Chart Generator Tool
  • about / Chart parts
• Chart Panes
  • about / Charts, Chart panes
  • enabling / Chart panes
  • limitations / Limitations of chart panes
• Chart Parts
  • about / Charts, Chart parts
• chart performance / Chart performance
• chart security
  • about / Chart security
  • record level security / Chart security
• Chr(177) / Working with addresses in reports
• Classic Client (CC)
  • about / Chart parts
• classic report
  • sections / Sections in a classic report
  • colour, adding to / Adding color to a classic report
• Claus / RDLC mandatory and 2008 integration
• Codeunit (Format Address) / Working with addresses in reports
• Colour property / Common report item properties
  • assigning, to / Common report item properties
• combination restriction fields
  • about / Dimension combinations
• conditional formatting
  • adding / Adding KPIs and conditional formatting
  • using / Implementing conditional formatting
  • implementing / Implementing conditional formatting
  • report code / Implementing conditional formatting
  • appropriate colors, selecting / Choosing the right colors
  • report, testing / Choosing the right colors
• controls, List report
  • text boxes / Controls
  • labels / Controls
  • shapes / Controls
  • images / Controls
  • picture boxes / Controls
• CreateBook function / What is so special about the Excel Buffer table (370)?
• Create Layout Suggestion option
  • using / Using the Create Layout Suggestion option
  • using, examples / Using the Create Layout Suggestion option
• CreateTotals() function / Creating a simple List report
• Ctrl+Alt+F1shortcut / Displaying data-bound information in the header
• Ctrl-R / Creating a simple List report
• CurrReport.BREAK function / Report functions
• CurrReport.CREATETOTALS function / Report functions
• CurrReport.PAGENO function / Report functions
• CurrReport.PREVIEW function / Report functions
• CurrReport.QUIT function / Report functions
• CurrReport.SHOWOUTPUT function / SummaryCurrReport.SHOWOUTPUT function
• CurrReport.SKIP function / Report functions
• CurrReport.TOTALSCAUSEDBY function / Report functions
• Customer table / Creating a simple List report
• Customize This Page feature / Chart parts

D

• data
  • about / Knowing your data and database
• data-bound information display, in header
  • about / Displaying data-bound information in the header
  • process, at runtime / Displaying data-bound information in the header
  • issue, solving / Displaying data-bound information in the header
  • report addresses, working with / Working with addresses in reports
  • current page, displaying / Displaying the current page and copy number
  • copy number, displaying / Displaying the current page and copy number
• database
  • about / Knowing your data and database
• database design, Dynamics NAV
  • schema / Dynamics NAV database design
  • about / Dynamics NAV database design
  • managing / Dynamics NAV database design
  • Properties window / Dynamics NAV database design
  • Table Designer window / Dynamics NAV database design
• Data Connection Wizard / Using Microsoft Excel with Dynamics NAV
• Data Item / Creating a simple List report
• DataItem / Displaying data-bound information in the header
• DataItem Execution Flow
  • visual representation / How is a data item processed?
• DataItemLink property / Sorting and grouping data in a report
• DataItemTableView property / Sorting and grouping data in a report
• DataItem triggers
  • OnPreDataItem / Triggers
  • OnAfterGetRecord / Triggers
  • OnPostDataItem / Triggers
• DataItemVarName property / The number of copies option
• DataItemView property / Sorting and grouping data in a report
• DataPerCompany / Dynamics NAV database design
• DataPerCompany property / Dynamics NAV database design
• data region control / The number of copies option
• Dataset Designer / RDLC mandatory and 2008 integration
• DataSetFieldName property / Filtering a page
• Data set name property / Displaying data-bound information in the header
• DAX / PowerPivot, BISM
• default dimensions
  • about / Default dimensions
  • specifying / Default dimensions
• Design button / Sorting and grouping data in a report
• dimension-based reports
  • about / Dimension-based reports
• dimension combinations
  • about / Dimension combinations
• dimensions
  • about / What are dimensions?, Dimensions and dimension values
  • setting up, in Dynamics NAV application / What are dimensions?
  • performance issues / Dimensions and dimension values
  • default dimensions / Default dimensions
  • financial information, analysing with / Analysing financial information using dimensions
• dimensions, types
  • global / Global
  • shortcut / Shortcut
  • budget / Budget
• dimension setup
  • accessing / Dimensions and dimension values
• dimensions set up
  • locations / Where are dimensions set up?
• dimension value
  • about / Dimension values
• dimension value combinations
  • about / Dimension combinations
• Dimension Value Combinations Matrix page
  • about / Dimension combinations
• dimension values
  • about / Dimensions and dimension values
• document map
  • using / Using theinteractive sortingspecifying document map, Linking reportdocument mapusings
• Document map label property / Using theinteractive sortingspecifying document map
• Document report
  • about / Document reports
  • examples / Document reports
• document reports
  • about / Document reports
  • number of copies option / The number of copies option
  • global variables, defining / The number of copies option
  • data-bound information, displaying in header / Displaying data-bound information in the header
• DSN Name / Using Microsoft Excel with Dynamics NAV
• Dynamics NAV
  • database design / Dynamics NAV database design
  • Microsoft Excel. using with / Comparing RDL and RDLC, Using Microsoft Excel with Dynamics NAV
  • and Business Intelligence / Business Intelligence and NAV
  • about / Dynamics NAV 7 and beyond
  • Jet Reports Express / Jet Reports Express
  • RDLC mandatory / RDLC mandatory and 2008 integration
• Dynamics NAV 7
  • section designer, replacing with extended items / Section designer replaced with an extended data item designer
  • and SharePoint / Dynamics NAV and SharePoint
  • moving, to cloud / Dynamics NAV in the cloud
  • cloud computing / Dynamics NAV in the cloud
• Dynamics NAV 2009
  • about / Role Centers
  • Classic report design, workflow / The Report Designer
• Dynamics NAV application
  • role centers / Role Centers
  • dimensions, setting up in / What are dimensions?
  • dimensions types / What are dimensions?
• Dynamics NAV database
  • creating, in SQL server / How is the Dynamics NAV database created in SQL Server?
• Dynamics NAV database, creating in SQL server
  • steps / How is the Dynamics NAV database created in SQL Server?
  • rules / How is the Dynamics NAV database created in SQL Server?
  • SQL Server database, managing / How is the Dynamics NAV database created in SQL Server?
  • relations / Relations and foreign keys
  • foreign key / Relations and foreign keys

E

• EnableExternalImages property / Adding images to your report
• EnableHyperlinks property / Filtering a page
• enhanced report design, in Dynamics NAV 2009
  • limitation / Limitations of enhanced report design in Dynamics NAV 2009
  • about / Limitations of enhanced report design in Dynamics NAV 2009
  • RDL schema versions / Limitations of enhanced report design in Dynamics NAV 2009
• examples, document reports
  • Report 206, Sales-Invoice / Document reports
  • Report 116, Statement / Document reports
  • Report 405, Order / Document reports
• examples, list reports
  • Report 101, Customer - List / List reports
  • Report 301, Vendor - List / List reports
• examples, other reports
  • Report 113, Customer/Item Sales / Other reports
  • Report 313, Vendor/Item Purchases / Other reports
  • Report 1012, Jobs per Customer / Other reports
• examples, test reports
  • Report 2, General Journal - Test / Test reports
  • Report 1005, Job Journal - Test / Test reports
• examples, transaction reports
  • Report 4, Detail Trial Balance / Transaction reports
  • Report 104, Customer - Detail Trial Bal / Transaction reports
  • Report 1007, Job - Transaction Detail / Transaction reports
• Excel-like layout, report
  • creating / Creating an Excel-like layout for a report
  • ShapeStyle property, values / Creating an Excel-like layout for a report
  • controls, overlapping / Creating an Excel-like layout for a report
  • look and feel, disadvantages / Creating an Excel-like layout for a report
  • report to Excel, printing / Printing a report to Excel
• Excel Buffer table
  • features / What is so special about the Excel Buffer table (370)?
  • automation / What is so special about the Excel Buffer table (370)?
• ExcelBuf variable / Printing a report to Excel
• expressions
  • about / Expressions
  • defining / Expressions
  • Fields collection / The Fields collection, The GlobexpressionsFields collectionals collection
  • ReportItems collection / The ReportItems collection
  • User collection / The User collection

F

• Field Menu button / Creating a simple List report
• field picker / Creating a simple List report
• Filter tab / Creating a TOP X reportsSort on windowTOP X table
• financial information
  • analysing, dimensions used / Analysing financial information using dimensions
• First() function / List data regions
• first enhanced report, creating
  • steps / Creating your first enhanced report, What's happening?
  • list, data region / What's happening?
  • table, data region / What's happening?
  • matrix, data region / What's happening?
  • chart, data region / What's happening?
  • format options, adding to report / Adding formatting, grouping, sorting, and filtering to a report
  • sorting options, adding to report / Adding formatting, grouping, sorting, and filtering to a report
  • filtering, to report / Adding formatting, grouping, sorting, and filtering to a report
  • filter, setting / Adding formatting, grouping, sorting, and filtering to a report
  • zero rows, filtering out / Adding formatting, grouping, sorting, and filtering to a report
  • format strings, list / Adding formatting, grouping, sorting, and filtering to a report
  • report creation workflow / Report creation workflow
• First function / Creating your first enhanced report
• FontFamily property / Common report item properties
• foreign key / Relations and foreign keys
• format property
  • about / Adding formatting, grouping, sorting, and filtering to a report
  • cons / Adding formatting, grouping, sorting, and filtering to a report
• functions
  • aggregate functions / Functions

G

• GETFILTER() function / Creating a TOP X reportsSort on windowTOP X table
• GETFILTERS() function / Creating a TOP X reportsSort on windowTOP X table
• Get function / Displaying data-bound information in the header, Working with addresses in reports
• global dimensions
  • about / Global
• Globals collection
  • ExecutionTime / The GlobexpressionsFields collectionals collection
  • PageNumber / The GlobexpressionsFields collectionals collection
  • TotalPages / The GlobexpressionsFields collectionals collection
  • ReportName / The GlobexpressionsFields collectionals collection
  • ReportServerURL / The GlobexpressionsFields collectionals collection
  • ReportFolder / The GlobexpressionsFields collectionals collection
• GroupHeader option / Sorting and grouping data in a report
• GroupNumber() function / Green bar matrix
• Group parameter / Displaying data-bound information in the header
• GroupTotalFields property / Sorting and grouping data in a report

H

• Hidden property / List data regions, Adding images to your report, Displaying data-bound information in the header, Creating a TOP X reportsSort on windowTOP X table
• hyperlinks
  • about / Hyperlinks
  • report, filtering / Filtering a report
  • page, filtering / Filtering a page
  • enabling / Filtering a page

I

• Iif() function / Creating a TOP X chart
• image data textbox
  • hiding / Displaying data-bound information in the header
• images, adding to report
  • about / Adding images to your report
  • properties, setting / Adding images to your report
  • MIMEType element, values / Adding images to your report
  • value elements / Adding images to your report
• Indent Dimension Values function
  • about / Dimension values
• InScope() function / Using colors in a matrix
• Insert New Section window / Creating a simple List report
• interactive sorting
  • specifying / Interactive sorting, Using theinteractive sortingspecifying document map
• international properties
  • Padding / Common report item properties
• intOutPutNo variable / The number of copies option
• int prefix / The number of copies option
• ioOfCopies variable / The number of copies option

J

• Jump to bookmark property / Bookmark links
• Jump to URL property / Filtering a page

K

• Key
  • about / Sorting and grouping data in a report
• Key property / Sorting and grouping data in a report
• KPI's
  • adding / Adding KPIs and conditional formatting
  • data bars, simulating / Simulating data bars
  • table, recreating / Simulating data bars
  • spark lines, simulating / Simulating spark lines

L

• Language property / Adding formatting, grouping, sorting, and filtering to a report
• List data region
  • defining / List data regions
  • List control,using / List data regions, What is the LiList data regiondocument outlinest control used for?
  • List properties / List data regions
  • properties, grouping / List data regions
  • properties, sorting / List data regions
  • Tab, including / List data regions
  • border, adding / List data regions
  • steps, sumarizing / List data regions
  • document outline / Document Outline, What is the LiList data regiondocument outlinest control used for?
  • Undo / Undo/Redo
  • Redo / Undo/Redo
• List report
  • about / List reports
  • examples / List reports
  • creating / Creating a simple List report
  • data, sorting / Sorting and grouping data in a report
  • data, grouping / Sorting and grouping data in a report
  • controls / Controls
  • classic report color, adding to / Adding color to a classic report
• list reports
  • triggers / Triggers
• localhost / Using Report Builder
• lvar> \ / Displaying data-bound information in the header
• lvar parameter / Displaying data-bound information in the header

M

• Maintainrelationships property / Relations and foreign keys
  • Entity Relationship (ER) Model, using / Using an Entity Relationship model
• matrix box
  • about / Matrix boxes
  • subtotal, adding to / Matrix boxes
  • matrix, dragging to / Matrix boxes
  • advanced techniques / More advanced matrix techniques, Green bar matrix, Chart data regionsmatrix boxgreen bar matrixmatrix boxadvanced techniques
  • colours, using / Using colors in a matrix
  • green bar matrix / Green bar matrix, Chart data regionsmatrix boxgreen bar matrixmatrix boxadvanced techniques
• Message() function / Displaying data-bound information in the header
• meta data
  • about / What are dimensions?
• Microsoft
  • website / Dynamics NAV database design
• Microsoft Excel
  • using, with Dynamics NAV / Comparing RDL and RDLC, Using Microsoft Excel with Dynamics NAV
• Microsoft Excel, using with Dynamics NAV
  • about / Comparing RDL and RDLC, Using Microsoft Excel with Dynamics NAV
  • Excel Data Mining Add In / Excel Data Mining Add In
  • PowerPivot / PowerPivot
  • PowerPivot, advantages / PowerPivot
  • tables, creating / PowerPivot
  • custom query, creating / PowerPivot
• MsgBox() / Displaying data-bound information in the header
• multi-column reports / Multi-column reports
  • print previewing, Print Layour using / Multi-column reports
• multiple data items
  • using / Using multiple data items
• MyVarX variable / Displaying data-bound information in the header

N

• NAV Portal / Dynamics NAV and SharePoint
• NODBC driver
  • using / Knowing your data and database
  • advantage / Knowing your data and database
• NoOfCopies variable / The number of copies option
• No PictureBox control / Displaying data-bound information in the header
• NoRows property / Checking on empty datasets

O

• Object Designer / Dynamics NAV database design
• OLA
  • references / Adding KPIs and conditional formatting
• OLAP data model
  • about / Business Intelligence and NAV
• OnAfterGetRecord() trigger / The number of copies option
• online reports
  • versus printed reports / Printed reports versus online reports
• Online transactional processing (OLTP) / Business Intelligence and NAV
• OnPreDataItem trigger / The number of copies option
• OnPreReport() trigger / Displaying data-bound information in the header
• optional enhanced layout
  • about / The optional enhanced layout
• Options tab / The number of copies option

P

• Page break at end
  • property / Displaying the current page and copy number
• Page break at end property / The number of copies option
• PagebreakatEnd property / The number of copies option
• page footers
  • about / Headers and footers
• page headers
  • about / Headers and footers
• PageSize property / Pagination
• Parent property / Use rectangles
• pk / Sorting and grouping data in a report
• PlaceInBottom property / Sections in a classic report
• posted dimension information
  • viewing / View posted dimension information
• Posting report
  • about / Posting reports
  • examples / Posting reports
• PowerPivot
  • about / PowerPivot
  • advantages, over Excel / PowerPivot
  • using, with Dynamics NAV / PowerPivot
• Preview & Filter button / PowerPivot
• printed reports
  • versus online reports / Printed reports versus online reports
• printer
  • selecting, for printing reports / Printer selection
• PrintOnEveryPage property / Sections in a classic report
• PrintOnFirstPage property / Headers and footers
• PrintOnLastPage property / Headers and footers
• PrintOnlyIfDetails property / Using multiple data items
• print report settings
  • determining / Determining print report settings
• ProcessingOnly property / What is a ProcessingOnly report?
• ProcessingOnly report
  • about / What is a ProcessingOnly report?
  • advantages / What is a ProcessingOnly report?
• Project Crescent
  • about / Project Crescent
  • screenshots / Project Crescent
• PromotedCategory property / Making a report available in the Role Tailored client
• properties, report items
  • BackgroundColour / Common report item properties
  • BackgroundImage / Common report item properties
  • BorderStyle / Common report item properties
  • BorderColour / Common report item properties
  • BorderWidth / Common report item properties
  • Padding / Common report item properties
• property, data item
  • DataItemIndent / Ptriggers, list reportsData Item processingroperties in a report
  • DataItemTable / Ptriggers, list reportsData Item processingroperties in a report
  • DataItemTableView / Ptriggers, list reportsData Item processingroperties in a report
  • DataItemLinkReference / Ptriggers, list reportsData Item processingroperties in a report
  • DataItemLink / Ptriggers, list reportsData Item processingroperties in a report
  • NewPagePerGroup / Ptriggers, list reportsData Item processingroperties in a report
  • NewPagePerRecord / Ptriggers, list reportsData Item processingroperties in a report
  • ReqFilterHeading / Ptriggers, list reportsData Item processingroperties in a report
  • ReqFilterHeadingML / Ptriggers, list reportsData Item processingroperties in a report
  • ReqFilterFields / Ptriggers, list reportsData Item processingroperties in a report
  • TotalFields / Ptriggers, list reportsData Item processingroperties in a report
  • GroupTotalFields / Ptriggers, list reportsData Item processingroperties in a report
  • CalcFields / Ptriggers, list reportsData Item processingroperties in a report
  • MaxIteration / Ptriggers, list reportsData Item processingroperties in a report
  • DataItemVarName / Ptriggers, list reportsData Item processingroperties in a report
  • PrintOnlyIfDetail / Ptriggers, list reportsData Item processingroperties in a report
• property, report
  • viewing / Ptriggers, list reportsData Item processingroperties in a report
  • ID / Ptriggers, list reportsData Item processingroperties in a report
  • Name / Ptriggers, list reportsData Item processingroperties in a report
  • Caption / Ptriggers, list reportsData Item processingroperties in a report
  • CaptionML / Ptriggers, list reportsData Item processingroperties in a report
  • ShowPrintStatus / Ptriggers, list reportsData Item processingroperties in a report
  • UseReqForm / Ptriggers, list reportsData Item processingroperties in a report
  • UseSystemPrinter / Ptriggers, list reportsData Item processingroperties in a report
  • ProcessingOnly / Ptriggers, list reportsData Item processingroperties in a report
  • TransactionType / Ptriggers, list reportsData Item processingroperties in a report
  • Description / Ptriggers, list reportsData Item processingroperties in a report
  • TopMargin / Ptriggers, list reportsData Item processingroperties in a report
  • BottomMargin / Ptriggers, list reportsData Item processingroperties in a report
  • LeftMargin / Ptriggers, list reportsData Item processingroperties in a report
  • RightMargin / Ptriggers, list reportsData Item processingroperties in a report
  • HorzGrid / Ptriggers, list reportsData Item processingroperties in a report
  • VertGrid / Ptriggers, list reportsData Item processingroperties in a report
  • Permissions / Ptriggers, list reportsData Item processingroperties in a report
  • Orientation / Ptriggers, list reportsData Item processingroperties in a report
  • PaperSize / Ptriggers, list reportsData Item processingroperties in a report
  • PaperSourceFirstPage / Ptriggers, list reportsData Item processingroperties in a report
  • PaperSourceOtherPage / Ptriggers, list reportsData Item processingroperties in a report
• property, section
  • PrintsOnEveryPage / Ptriggers, list reportsData Item processingroperties in a report
  • PlaceInBottom / Ptriggers, list reportsData Item processingroperties in a report
  • SectionWidth / Ptriggers, list reportsData Item processingroperties in a report
  • SectionHeight / Ptriggers, list reportsData Item processingroperties in a report

R

• RDL
  • about / Why you cannot call it Reporting Services
  • comparing, with RDLC / Comparing RDL and RDLC
  • advantages / Comparing RDL and RDLC
• RDLC
  • viewing / Simulating data bars
  • disadvantages / Comparing RDL and RDLC
  • advantages / Comparing RDL and RDLC
• RECORDID function / Filtering a page
• record level security / Chart security
• Refresh button / Using Microsoft Excel with Dynamics NAV
• Relative option / Chart parts
• RelativePct option / Chart parts
• REM function / Displaying the current page and copy number
• Repeat report item with data region on every page property / Displaying data-bound information in the header
• report
  • properties / Ptriggers, list reportsData Item processingroperties in a report
  • Excel-like layout, creating / Creating an Excel-like layout for a report
  • functions / Report functions
  • filtering / Filtering a report
• report.rdlc visualisation / Creating your first enhanced report
• Report Builder, SSRS
  • about / Using Report Builder
  • downloading / Using Report Builder
  • report, using / Using Report Builder
  • blank report / Using Report Builder
  • visualized/hidden areas / Using Report Builder
  • three tabs / Using Report Builder
  • using / Using Report Builder
  • Tablix data region / Using Report Builder
  • @ Sign, using for parameter creation / Using Report Builder
  • parameters, using / Using Report Builder
  • data source user / Using Report Builder
• report designer
  • about / The Report Designer
  • report wizard / Using the report wizard
• report functions
  • CurrReport.SKIP / Report functions
  • CurrReport.BREAK / Report functions
  • CurrReport.QUIT / Report functions
  • CurrReport.PREVIEW / Report functions
  • CurrReport.PAGENO / Report functions
  • CurrReport.CREATETOTALS / Report functions
  • CurrReport.TOTALSCAUSEDBY / Report functions
  • CurrReport.NEWPAGE / Report functions
  • CurrReport.SHOWOUTPUT / Report functions
• Reporting Services
  • about / Why you cannot call it Reporting Services
  • RDL, differenciating with RDLC / Difference between RDL and RDLC?
  • RDLC, differenciating with RDL / Difference between RDL and RDLC?
• report items
  • about / Report items
  • static report items / Report items
  • data regions / Report items
  • properties / Common report item properties
  • options, using / Common report item properties
• Report properties, Layout tab / Multi-column reports
• reports
  • about / Reports
  • groups / Reports
  • need for / Reports
  • other reports, examples / Other reports
  • printing / Printing reports
  • creating, without development tools / Creating reports without development tools
• reports, Dynamics NAV 2009
  • document reports / Document reports
  • TOP X reports / TOP X reports
  • KPI’s, adding / Adding KPIs and conditional formatting
  • conditional formatting / Adding KPIs and conditional formatting
  • conditional formatting, implementing / Implementing conditional formatting
• reports, types
  • list / List reports
  • test / Test reports
  • posting / Posting reports
  • transaction / Transaction reports
  • document / Document reports
• report sections
  • body / Sections in a classic report
  • header / Sections in a classic report
  • footer / Sections in a classic report
  • GroupHeader / Sections in a classic report
  • GroupFooter / Sections in a classic report
  • TransHeader / Sections in a classic report
  • TransFooter / Sections in a classic report
  • collapsing / ExpanSizing propertyding/collapsing report sections
  • expanding / ExpanSizing propertyding/collapsing report sections
  • exporting, to Excel / ExpanSizing propertyding/collapsing report sections
• Report Selections table
  • about / Report selections
  • advantages / Report selections
• reports linking
  • types / Linking reportdocument mapusings
  • bookmark links / Bookmark links
• Report triggers
  • OnInitReport / Triggers
  • OnPreReport / Triggers
  • OnPostReport / Triggers
  • OnCreateHyperlink / Triggers
  • OnHyperlink / Triggers
• report wizard
  • using / Using the report wizard
  • Form Type reports / Using the report wizard, Form type report
  • Tabular Type reports / Using the report wizard
  • Label Type reports / Using the report wizard
  • Tabular-Type report / Tabular type report
  • Label-Type report / Label type report
• Report | Page Header / Displaying data-bound information in the header
• Role Center
  • about / Role Centers
  • example, for Order Processor role / Role Centers
  • example, for small business / Role Centers
• RoleTailored client
  • report, making available / Making a report available in the Role Tailored client
• Role Tailored Client (RTC)
  • about / Role Centers
  • chart types / Charts
  • Chart Panes / Charts, Chart panes
  • Chart Parts / Charts, Chart parts
  • using / Chart parts
  • reports / Reports
• Role Tailored Reports
  • optional enhanced layout / The optional enhanced layout
  • enhanced report, creating / Creating your first enhanced report
  • multiple data items, using / Using multiple data items
  • Create Layout Suggestion option, using / Using the Create Layout Suggestion option
  • template, changing / Changing the template
• RowNumber function / Green bar matrix
• Run command / Creating your first enhanced report
• RunningValue function / Green bar matrix
• RunObject property / Making a report available in the Role Tailored client

S

• +/- sign / Working with addresses in reports
• section triggers
  • OnPreSection / Triggers
• security filter
  • about / Chart security
• SETCURRENTKEY / TOP X reports
• Set function / Working with addresses in reports
• Set functions / Displaying data-bound information in the header
• Setup | General | Business Analytics Setup / Business Analytics
• SharePoint / Dynamics NAV and SharePoint
• Shift+F12 / Dynamics NAV database design
• shortcut dimensions
  • about / Shortcut
• Sizing property / Adding images to your report, ExpanSizing propertyding/collapsing report sections
• Snowflake schema / Business Intelligence and NAV
• Sort tab / TOP X reports
• SourceExpr property / Filtering a page, Displaying data-bound information in the header
• SQL server
  • SQL Server Denali / What will SQL Server do?
  • Project Crescent / Project Crescent
  • BISM / BISM
  • DAX / BISM
• SQL server Denali
  • about / What will SQL Server do?
  • features / What will SQL Server do?
• SQL Server Option
  • about / Chart security
• SSIS / Business Intelligence and NAV
• SSRS
  • about / Reporting Services
  • developing, tools used / Reporting Services
  • Report Builder, using / Using Report Builder
  • BIDS, using / Using BIDS
• Star schema
  • about / Business Intelligence and NAV
• Start button / Creating your first enhanced report
• static filters
  • about / Chart parts
• static report items
  • pointer / Report items
  • textbox / Report items
  • line / Report items
  • rectangle / Report items
  • image / Report items
• Sum functions / What's happening?
• Switch() function / Creating a TOP X reportsSort on windowTOP X table
• – sign / Working with addresses in reports

T

• TableRelation property / Dynamics NAV database design
• Tablix data region / Using Report Builder
• Tabular-Type Report Wizard / UsingTOP X reportschart, creating the wizard
• template report / UsingTOP X reportschart, creating the wizard
• test report
  • about / Test reports
  • examples / Test reports
• textbox
  • about / Text box
  • expression example / Text box
  • as data region / Text box
• TextBoxX
  • naming / Displaying data-bound information in the header
• The joy of stats / Project Crescent
• tips
  • title, using / Use a title, page numbers, and show applied filters
  • page numbers, using / Use a title, page numbers, and show applied filters
  • applied filters, using / Use a title, page numbers, and show applied filters
  • dummy report / Use a title, page numbers, and show applied filters
  • images, using / Using rectangles, lines, and images
  • lines, using / Using rectangles, lines, and images
  • rectangles, using / Using rectangles, lines, and images, Use rectangles
  • report border, adding / Adding a report border
  • page headers/footers borders / Adding a report border
  • report usage, tracking / Tracking report usage
  • ExecutionLog / Tracking report usage
  • SQL monitoring tools, using / Tracking report usage
  • empty datasets, checking / Checking on empty datasets
  • report layout setup table, using / Using a report layout setup table
  • blanking properties / Blanking properties
  • pagination / Pagination
  • proper name, using / Give everything a proper name
  • testing / Test, test, and test
• TO BE situation / Business Intelligence and NAV
• Toggle Item property / List data regions
• Toggle Table/Matrix
  • implemeting / Simulating spark lines
• toolbar, report viewer
  • Document Map / Creating your first enhanced report
  • buttons / Creating your first enhanced report
  • Print button / Creating your first enhanced report
  • Save As button / Creating your first enhanced report
  • Zoom button / Creating your first enhanced report
• Tools | Create Layout Suggestion / UsingTOP X reportschart, creating the wizard
• TOP X reports
  • about / TOP X reports
  • sorting / TOP X reports
  • performance / TOP X reports
  • Sort on window / TOP X reports, Creating a TOP X reportsSort on windowTOP X table
  • table, creating / Creating a TOP X reportsSort on windowTOP X table
  • chart, creating / Creating a TOP X chart, UsingTOP X reportschart, creating the wizard
• TotalFields property / Creating a simple List report, Sorting and grouping data in a report
• totals
  • running / Sections in a classic report
• Transaction report
  • about / Transaction reports
  • characteristics / Transaction reports
  • examples / Transaction reports
• triggers, list reports
  • report triggers / Triggers
  • DataItem triggers / Triggers
  • section triggers / Triggers
  • using / What happens when a report runs?
  • Report Execution Flow, visual representaion / What happens when a report runs?
  • Data Item processing / How is a data item processed?, Ptriggers, list reportsData Item processingroperties in a report

U

• unique keys / Sorting and grouping data in a report
• User collection
  • Language / The User collection
  • UserID / The User collection
• UseReqForm property / Printing reports

V

• View | Layout option / Displaying data-bound information in the header
• Visible property / Creating your first enhanced report

W

• Windows-Key + R / Creating your first enhanced report
• Windows Azure
  • URL / Dynamics NAV in the cloud
• wizard
  • using / UsingTOP X reportschart, creating the wizard

X

• .xsd file
  • about / Chart parts

Z

• zero error
  • dividing by / Creating a TOP X reportsSort on windowTOP X table