Index
A
- Adventure Works database
- URL / Getting Ready
- aggregation
- in reports / Aggregation in reports, How to do it…, How it works…
- AOT queries
- best practices / AOT queries
- Application Object Tree (AOT) / Using a query as a data source in a report
- auto design
- creating, from datasets / Creating auto designs from datasets, How to do it..., How it works…
- image, adding / How it works…
- sub-report, creating / Creating a sub-report in auto design, How to do it...
- chart reports / Chart reports in auto design
- AX
- VS, connecting to / Connecting VS to AX
- long running reports, handling in / Handling long-running reports in AX
- AX 2009
- URL / How to do it...
- AX 2012 R3 datasets
- vs. AX 2009 reports / Datasets in AX 2012 R3 vs AX 2009 reports
- AX 2012 report development, best practices
- report design / Report design
- AOT queries / AOT queries
- data source table / Data source table
- RDP class / RDP class
- contract class / Contract class
- controller class / Controller class
- UI Builder class / UI Builder class
- general / General best practices
- URL / General best practices
- AXEnumProvider
- using as dataset for parameters, in reports / Using AXEnumProvider as the dataset for parameters in reports , How to do it…
B
- barcodes
- displaying, in reports / Generating and displaying barcodes in reports, How to do it…, How it works…
- generating, in reports / Generating and displaying barcodes in reports, How to do it…, How it works…
- business logic
- data methods, adding / Adding data methods in business logic, How to do it…, How it works...
- debugging / Debugging business logic, How to do it…
- unit testing / Unit testing business logic, How to do it…, How it works...
- used, for adding datasource / Adding a datasource through business logic, How to do it..., How it works…
- used, for building parameter lookup / Building a parameter lookup using business logic, How to do it…, How it works…
- about / Business logic
C
- caller
- UI, modifying by / Modifying the UI by caller, How to do it…
- chart data region
- creating / Creating a chart data region, How to do it…, How it works…
- chart reports
- in auto design / Chart reports in auto design
- charts
- creating, in reports / Creating multiple data regions and charts in reports, How to do it…, How it works…
- column chart report
- creating / Creating a column chart report, How to do it…, How it works…
- company images
- displaying / Adding headers and displaying company images, How to do it…
- complex queries
- used, for fetching data for reports / Creating reports by fetching the data using complex queries, How to do it…
- configuration-based resolution, long running reports
- about / Configuration-based resolution
- data extension-based timeout / Data extension-based timeout
- server-side WCF timeout / Server-side WCF timeout
- client-side WCF timeout / Client-side WCF timeout
- report execution timeout / Report execution timeout
- timeouts, specifying / Specifying timeouts for all reports, Specifying timeouts for a specific report
- user session timeout / User session timeout
- context
- controls, hiding by / Hiding controls by context, How to do it…, How it works…
- contract class
- used, for connecting UI Builder class / Connecting the UI builder class with a contract class
- unit test class, creating for / Creating a unit test class for a contract class, How to do it...
- best practices / Contract class
- contracts
- grouping / Grouping in contracts, How it works…
- controller
- used, for opening reports / Opening a report through a controller, How to do it..., How it works...
- about / Controller
- Report data contract / Report data contract
- Report controller / Report controller
- Report UI builder / Report UI builder
- report query, modifying / Modifying the report query in controller, How to do it..., How it works...
- multiple reports, calling / Calling multiple reports from a controller, How to do it…
- used, for creating reports / Creating a report using a controller and the UI Builder class, How to do it..., How it works…
- controller class
- unit test class, creating for / Creating a unit test class for a controller class, How to do it...
- best practices / Controller class
- controls
- grouping, in report dialog / Grouping and ordering controls in the report dialog, Grouping in report model
- ordering, in report dialog / Grouping in report model
- hiding, by context / Hiding controls by context, How to do it…, How it works…
- customer summary OLAP report
D
- data
- retrieving / Retrieving metadata and data
- fetching for reports, complex queries used / Creating reports by fetching the data using complex queries, How to do it…
- fetching for reports, views used / Creating reports by fetching the data using views, How to do it…
- fetching for reports, maps used / Creating reports by fetching the data using maps, How to do it...
- data-related issues
- about / Data-related issues
- query-based report / Query-based report
- RDP-based report / RDP-based report
- controller issues / Controller issues
- data methods
- adding, in business logic / Adding data methods in business logic, How to do it…
- vs. expressions / Data method vs Expressions
- data regions
- filters, adding / Adding filters to data regions, How it works…
- datasets
- auto design, creating / Creating auto designs from datasets, How to do it..., How it works…
- datasource
- adding, business logic used / Adding a datasource through business logic, How to do it..., How it works…
- XML feed, using as / Using an XML feed as a datasource, How to do it…, How it works…
- data source table
- best practices / Data source table
- deployment-related issues / Unable to deploy, Unable to refresh
- design-based resolution, long running reports
- about / Design-based resolution
- dialog
- used, for opening reports / Opening a report with a dialog, How to do it..., How it works…
- document map navigation
- adding, to reports / Adding document map navigation to reports, How it works…
- drill-down actions
- creating, in reports / Creating drill-up/drill-down actions in reports, How to do it…
- drill-up actions
- creating, in reports / Creating drill-up/drill-down actions in reports, How to do it…
- duties
- URL / How it works…
- dynamic filters / Dynamic filters
- dynamic parameter
- about / How it works…
E
- e-mail
- reports, sending through / Sending the report through e-mail, How it works…
- Enterprise Portal (EP) / Using AXEnumProvider as the dataset for parameters in reports
- events
- post reporting completion, handling / Handling events after report completion, How to do it…, How it works…
- expression
- expressions
- URL / How it works…
- vs. data method / Data method vs Expressions
- Extended Data Types (EDTs) / Defining the data source
- external datasource
- used, for building reports / Building a report through an external datasource, How to do it…, How it works...
- external datasource query
- parameter, adding for / Adding a parameter for an external datasource query, How it works…
F
- filters
- adding, to data regions / Adding filters to data regions, How it works…
- financial dimensions
- in query reports / Financial dimensions in query reports, How to do it…, How it works…
- in RDP reports / Financial dimensions in RDP reports, How to do it…, How it works…
G
- gauges
- in reports / Gauges in reports, How to do it…
- group view report
- creating / Creating a group view report, How to do it…, How it works…
H
- headers
I
- image
- adding, in auto design / Adding an image in auto design, How it works…
- inventory dimension
- in reports / Inventory dimensions in reports, How to do it…
- in report / How it works…
L
- language-specific reports
- deploying, to speedup execution time / Deploying language-specific reports to speed up execution time, How to do it…, How it works…
- Language Integrated Query (LINQ) / How it works…
- layout template
- creating / Creating a new layout template, How to do it…, How it works…
- legacy reporting system
- about / Introduction
- line chart
- creating / Creating a line chart, How to do it…, How it works…
- list control
- in reports / List and rectangle controls in reports, How to do it…, How it works…
- long running reports
- handling, in AX / Handling long-running reports in AX
- design-based resolution / Design-based resolution
- configuration-based resolution / Configuration-based resolution
M
- maps
- used, for fetching data for reports / Creating reports by fetching the data using maps, How to do it...
- URL / How to do it...
- map sub-report
- designing, SQL Report Builder used / Designing a map sub-report with SQL Report Builder, How to do it
- matrix report
- creating / Creating a matrix report, How to do it…, Creating a matrix report, How it works…
- design / Basic report design
- multicolumn matrix report, creating / Creating a multicolumn matrix report, How to do it…, How it works…
- MDX Query Editor
- URL / How to do it…
- menu item
- creating, from report / Creating a menu item for a report, How to do it..., How it works…
- of report into privilege, adding up / Adding up the report menu item into privilege, How to do it..., How it works…
- metadata
- retrieving / Retrieving metadata and data
- Microsoft Dynamics AX
- URL / Reporting overview
- model / Report programming model
- Model View Controller (MVC) pattern / Report programming model
- multi-value lookup
- selecting / Multi-value lookup, How to do it…
- multicolumn matrix report
- creating / Creating a multicolumn matrix report, How to do it…
- Multidimensional Expressions (MDX) queries / Getting Ready
- multiple data regions
- creating, in reports / Creating multiple data regions and charts in reports, How to do it…, How it works…
- multiple temporary table
- with RDP / RDP with multiple temporary tables, How to do it…
O
- OLAP
- parameter lookup, adding / Adding a parameter lookup for OLAP, How to do it…, EndDate parameter
- OLAP table report
- designing, SQL Report Builder used / Designing an OLAP table report with SQL Report Builder, How to do it…, How it works...
- Online Transaction Processing (OLTP) / Building a report through an external datasource
P
- parameter
- adding, for external datasource query / Adding a parameter for an external datasource query, How to do it…
- parameter lookup
- building, business logic used / Building a parameter lookup using business logic, How to do it…, How it works…
- adding, for OLAP / Adding a parameter lookup for OLAP, How to do it…
- Company parameter / Company parameter
- EndDate parameter / EndDate parameter
- main query / Main query
- parameters
- about / How it works…
- system parameter / System parameter
- user defined parameters / User-defined parameters
- and data source types / Parameters and data source types
- query parameters / Query parameters
- dynamic filters / Dynamic filters
- PowerShell
- for report deployment, URL / Location of deployment
- precision design
- creating / Creating a simple precision design, How to do it…, How it works…
- used, for creating sub-report / Creating a sub-report in precision design, How to do it..., How it works...
- print management
- used, for adding new report design / Adding a new report design to print management, How to do it…
- privileges
- URL / How it works…
Q
- query
- using as data source, in reports / Using a query as a data source in a report, How to do it...
- verifying / Verify the query
- query-based reports
- surrogate keys / Surrogate keys in query-based reports
- query parameters / Query parameters
- query reports
- financial dimensions / Financial dimensions in query reports, How to do it…, How it works…
R
- ranges
- adding, to report / Adding ranges to the report, How to do it..., How it works…
- adding, from unbound parameters to query / Adding ranges from unbound parameters to a query, How to do it..., How it works…
- RDL
- contract validation / How it works…
- RDP
- about / RDP
- data contract class / RDP data contract
- UI builder / UI builder
- selecting, for report / Choosing RDP for a report, See Also
- precision design, creating / Creating a simple precision design, How to do it…, How it works…
- testing / Testing the RDP
- debugging / Debugging RDP
- existing temp table, using / Using an existing temp table in RDP, How to do it…, How it works…
- contract validation / How it works…
- surrogate keys / Surrogate keys in RDP, How it works…
- multiple temporary table / RDP with multiple temporary tables, How to do it…
- RDP class
- URL / Model
- unit test class, creating for / Creating a unit test class for an RDP class, How to do it...
- best practices / RDP class
- RDP class, attributes
- RDP data contract
- vs. RDL data contract / RDP vs RDL data contract
- RDP report
- creating / Creating a simple RDP report, How to do it…
- testing / Testing the RDP report
- advanced RDP report, creating / Creating an advanced RDP report, How to do it…
- RDP reports
- financial dimensions / Financial dimensions in RDP reports, How to do it…, How it works…
- rectangle control
- in reports / List and rectangle controls in reports, How to do it…, How it works…
- rendering-related issues / Rendering-related issues
- Report Data Providers (RDP) / Introduction
- Report Definition Language (RDL) / Introduction
- report design
- best practices / Report design
- report dialog
- lookup adding, UI Builder class used / Adding a lookup on a report dialog using the UI Builder class, How to do it...
- turning off / Turning off a report dialog, How to do it...
- controls, grouping / Grouping and ordering controls in the report dialog
- controls, ordering / Grouping and ordering controls in the report dialog
- controls, grouping in report model / Grouping in report model
- controls, grouping in UI builder / Grouping in the UI builder
- controls, grouping in RDP-based reports / Grouping in contracts, How it works…
- Reporting Services extensions
- URL / Reporting overview
- report query
- modifying, in controller / Modifying the report query in controller, How to do it..., How it works...
- reports
- about / Introduction
- overview / Reporting overview
- designing, ways / Creating auto designs from datasets
- preview / How it works…
- grouping / Grouping in reports, How to do it..., How it works…
- ranges, adding / Adding ranges to the report, How to do it..., How it works…
- deploying / Deploying a report, How to do it...
- deployment, location / Location of deployment
- menu item, creating / Creating a menu item for a report, How to do it..., How it works…
- creating, Warehouse Management query used / Creating a report using a query in Warehouse Management, How to do it..., How it works
- charts, creating / Getting Ready, How to do it…, How it works…
- multiple data regions, creating / Getting Ready, How it works…
- expression / Expression in reports, How to do it…, How it works…
- aggregation / Aggregation in reports, How to do it…, How it works…
- formatting / Formatting reports, How it works…
- unbounded parameters, adding / Adding unbounded parameters in reports, How to do it…
- document map navigation, adding / Adding document map navigation to reports, How it works…
- drill-up actions, adding / Creating drill-up/drill-down actions in reports, How to do it…
- drill-down actions, adding / Creating drill-up/drill-down actions in reports, How to do it…
- opening, controller used / Opening a report through a controller, How to do it..., How it works...
- opening, dialog used / Opening a report with a dialog, How to do it..., How it works…
- creating, UI Builder class used / Creating a report using the UI Builder class, How to do it..., How it works…, Creating a report using a controller and the UI Builder class, How to do it..., How it works…
- security, setting up / Setting up security for reports, How it works...
- menu item, adding into privilege / Adding up the report menu item into privilege, How to do it..., How it works…
- multiple reports, calling from controller / Calling multiple reports from a controller, How to do it…
- multiple reports calling, single controller used / Calling multiple reports simultaneously using a single controller, How to do it...
- model, debugging / Debugging a report model
- model, changes / Changes to model and adding new classes, How it works…
- new classes, adding / Changes to model and adding new classes, How it works…
- URL drill, adding through action / Adding a URL drill through action in reports, How to do it…
- creating, controller used / Creating a report using a controller and the UI Builder class, How to do it..., How it works…
- creating, with multiple data sources in single table / Creating a report with multiple data sources in a single table, How to do it…
- pre-processing / Pre-processing reports, How to do it…
- cleaning up / Clean up
- building, through external datasource / Building a report through an external datasource, How to do it…, How it works...
- gauges / Gauges in reports, How to do it…
- rectangle controls / List and rectangle controls in reports, How to do it…
- list controls / List and rectangle controls in reports, How to do it…
- adding, to role centre / Adding reports to the role center, How to do it…, How it works…
- upgrading, from previous version / Upgrading a report from its previous version
- existing report, analyzing / Analyzing and modifying an existing report, How to do it...
- existing report, modifying / Analyzing and modifying an existing report, How to do it...
- existing report, URL / How to do it...
- project, URL / How to do it...
- validation, implementing / Implementing validation in reports, How to do it…, How it works…
- surrogate fields / Surrogate fields in reports, How to do it…
- inventory dimension / Inventory dimensions in reports, How to do it…, How it works…
- performance, assessing / Assessing report performance and usage, How to do it…, How it works…
- usage, assessing / Assessing report performance and usage, How to do it…, How it works…
- troubleshooting, in AX / Troubleshooting reports in AX
- saving, to file / Auto e-mail, save as file tasks in reports, Saving the report to a file
- sending, through e-mail / Sending the report through e-mail, How it works…
- barcodes, generating / Generating and displaying barcodes in reports, How it works…
- barcodes, displaying / Generating and displaying barcodes in reports, How to do it…, How it works…
- AXEnumProvider, using as dataset for parameters / Using AXEnumProvider as the dataset for parameters in reports , How to do it…
- new report design adding, print management used / Adding a new report design to print management, How to do it…
- improving / Improving the functionality of reports, How to do it…
- designing / Improving the functionality of reports, How to do it…
- creating by data fetching, complex queries used / Creating reports by fetching the data using complex queries, How to do it…
- creating by data fetching, views used / Creating reports by fetching the data using views, How to do it…
- creating by data fetching, maps used / Creating reports by fetching the data using maps, How to do it...
- reports, upgrading
- from previous version / Upgrading a report from its previous version
- datasource, defining / Defining the data source
- fields, mapping / Mapping the parameters and fields
- parameters, mapping / Mapping the parameters and fields
- design, mapping / Mapping the design
- AX 2012 R3 datasets vs. AX 2009 reports / Datasets in AX 2012 R3 vs AX 2009 reports
- controller, developing / Developing the controller
- UI events, handling / Handling UI events
- role centre
- reports, adding / Adding reports to the role center, How to do it…, How it works…
- roles
- URL / How it works…
S
- security
- for reports, setting up / Setting up security for reports, How it works...
- single controller
- used, for calling multiple reports simultaneously / Calling multiple reports simultaneously using a single controller, How to do it..., How it works…
- SQL Report Builder
- used, for designing OLAP table report / Designing an OLAP table report with SQL Report Builder, How to do it…, How it works...
- used, for designing map sub-report / Designing a map sub-report with SQL Report Builder, How to do it, How it works...
- SSRS report log viewer
- URL / Getting ready
- sub-report
- creating, in auto design / Creating a sub-report in auto design, How to do it..., How it works...
- creating, precision design used / Creating a sub-report in precision design, How to do it..., How it works...
- surrogate fields
- in reports / Surrogate fields in reports, How to do it…
- surrogate keys, in query-based reports / Surrogate keys in query-based reports
- surrogate keys, in RDP / Surrogate keys in RDP, How it works…
- system parameter
- about / System parameter
T
- TempDB tables
- URL / How to do it…
- templates
- about / How it works…
- temporary tables
- existing temp table, using in RDP / Using an existing temp table in RDP, How to do it…, How it works…
- ternary operator (?)
- URL / How to do it...
- troubleshooting, reports
- about / Troubleshooting reports in AX
- deployment-related issues / Deployment-related issues
- rendering-related issues / Rendering-related issues
- data-related issues / Data-related issues
U
- UI
- modifying, by caller / Modifying the UI by caller, How to do it…
- UI builder
- grouping / Grouping in the UI builder
- UI Builder class
- used, for creating reports / Creating a report using the UI Builder class, How to do it..., How it works…, Creating a report using a controller and the UI Builder class, How to do it..., How it works…
- used, for adding lookup on report dialog / Adding a lookup on a report dialog using the UI Builder class, How to do it...
- connecting, contract class used / Connecting the UI builder class with a contract class, Getting Ready
- best practices / UI Builder class
- unbound parameters
- to query, ranges adding from / Adding ranges from unbound parameters to a query, How to do it..., How it works…
- unit test class
- creating, for contract class / Creating a unit test class for a contract class, How to do it...
- creating, for controller class / Creating a unit test class for a controller class, How to do it...
- creating, for RDP class / Creating a unit test class for an RDP class, How to do it...
- URL drill
- adding, through action in reports / Adding a URL drill through action in reports, How to do it…
- user defined parameters
- bounded parameters / Bounded parameters, Unbounded parameters
- unbounded parameters / Unbounded parameters
V
- validation
- implementing, in reports / Implementing validation in reports, How to do it…, How it works…
- view
- about / View
- views
- used, for fetching data for reports / Creating reports by fetching the data using views, How to do it…
- Visual Studio Tools
- URL / Reporting overview
- VS
- connecting, to AX / Connecting VS to AX
W
- WCF
- in SSRS reports. URL / Clean up
X
- XML feed
- using, as datasource / Using an XML feed as a datasource, Getting ready, How to do it…, How it works…
- URL / Getting ready, Getting ready
- Spin-off recipes / Spin-off recipes