Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Microsoft Dynamics NAV 2009: Professional Reporting

You're reading from   Microsoft Dynamics NAV 2009: Professional Reporting Discover all the tips and tricks for Dynamics NAV report building

Arrow left icon
Product type Paperback
Published in Oct 2011
Publisher Packt
ISBN-13 9781849682442
Length 352 pages
Edition 1st Edition
Languages
Arrow right icon
Author (1):
Arrow left icon
Steven Renders Steven Renders
Author Profile Icon Steven Renders
Steven Renders
Arrow right icon
View More author details
Toc

Table of Contents (15) Chapters Close

Microsoft Dynamics NAV 2009: Professional Reporting
Credits
About the Author
Acknowledgement
About the Reviewers
www.PacktPub.com
Preface
1. Charts and Dimensions FREE CHAPTER 2. Creating a Report in the Classic Client 3. Creating Role Tailored Reports 4. Visualization Methods 5. Developing Specific Reports 6. Other Reporting and Business Intelligence Tools 7. A View of the Future Index

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
lock icon The rest of the chapter is locked
arrow left Previous Section
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image