AX SSRS Reporting ScreenCast List
To help you find the right screencast, below is a list of all of them that have been produced so far and some that are scheduled to be created. This list will be updated as additional screencasts become available.
[Updated on 2010/12/08 with Screencasts 26 – 30]
[Updated on 2010/12/08 with Screencasts 21 – 25]
[Updated on 2010/12/07 with Screencasts 17 – 20 ]
Direct link to our YouTube Channel: https://www.youtube.com/dynamicsaxbi
ScreenCast 1: Create the Simplest Possible Report with Visual Studio
URL: https://www.youtube.com/watch?v=oJCj9mCo-9I
- Creating a New Report Library
- Creating a new Report Model
- Creating a dataset an dbinding it to an AX Query
- Previewing the Report in Visual Studio
ScreenCast 2: The Case of the Mysterious Parameter
URL: https://www.youtube.com/watch?v=kdfpMBF-kMA
- parameters created automatically from query ranges
ScreenCast 3: Better Looking Reports with Templates
URL: https://www.youtube.com/watch?v=wzi4czp3cjQ
- templates for Auto Designs
- style template
- layout templates
- adding the shared library to the solution
- referencing the shared library in a report library
ScreenCast 4: AX SSRS Reporting Concepts
URL: https://www.youtube.com/watch?v=8dQomypSAgQ
- Report Libraries
- Report Models
- Report Designs
- DataSets
- Designs
- AutoDesign & Precision Designs
- Designs versus RDL
ScreenCast 5: Launching a Report from a Menu Item
URL: https://www.youtube.com/watch?v=bHF24bZJA_A
- Saving a report library to AOD
- Deploying a report library to SSRS
- Rnning a Report in SSRS Report Manager
- Creating an Output Menu Item and binding it to a report design
ScreenCast 6: Default Values for Parameters and Hiding Parameters
URL: https://www.youtube.com/watch?v=SZRqYx32HwY
- Providing Defaults for Parameters And Hiding Parameters
- Default Parameter Values
- Hiding Parameters
ScreenCast 7: Debugging Parameter Values in AutoDesigns
URL: https://www.youtube.com/watch?v=DiKm6NZt2Ok
- The "Render Parameters" property on Auto Designs designs
ScreenCast 8: Manually Creating Designs and DataRegions
URL: https://www.youtube.com/watch?v=nRUZ5wTukK8
- Drag-and-drop a dataset to create a dataregion
- Manually adding a Design
- Manually adding a DataRegion
- Binding a dataregion to a dataset
ScreenCast 9: Multiple Data Regions in AutoDesigns
URL: https://www.youtube.com/watch?v=YjI_Nq8coCE
- Multiple Datasets in a report model
- Adding a Dataset for InventTableSRS
- Multiple DataRegions in a report model
ScreenCast 10: Expressions and “Expressionable” Properties
URL: https://www.youtube.com/watch?v=K77lQ3-svr4
- Static Values
- Calculated Values with Expressions
- Adding Calculated Columns to a DataRegion
ScreenCast 11: An Introduction to Data Methods
URL: https://www.youtube.com/watch?v=HS2n-NXp--g
- Expressions versus DataMethods
- BusinessLogic assemblies
- Deployment of BusinessLogic assemblies
ScreenCast 12: Using Data Methods as a DataSource
URL: https://www.youtube.com/watch?v=Xd4FiBALl0U
- Creating a System.Data.DataTable
- Creating a DataSet that is bound to a DataMethod
ScreenCast 13: Executing an AX Query in a Data Method
URL: https://www.youtube.com/watch?v=ZIoEZWaiBXI
- using the Microsoft.Dynamics.Framework.Reports.AxQuery.ExecuteQuery API
- Creating a DataSet that is bound to a DataMethod
ScreenCast 14: Programmatically Setting Ranges on an AX Query
URL: https://www.youtube.com/watch?v=8ejHMzHndbA
- Using a ranges with Microsoft.Dynamics.Framework.Reports.AxQuery.ExecuteQuery
- Naming the ranges correctly
ScreenCast 15: Defining and Getting Data from Report Parameters
URL: https://www.youtube.com/watch?v=Q_sVIrfJHlc
- Creating your own Parameter
- Supported Parameter Types
- Default Values
- Parameter values in Expressions
ScreenCast 16: Dynamically Setting Query Ranges At Runtime
URL: https://www.youtube.com/watch?v=_f9SegqA4ZA
- Parameters on Data Methods versus Parameters on Reports
- Refreshing DataSets
- Using a parameter value in query execution
ScreenCast 17: Calling X++ Code from a Report
URL: https://www.youtube.com/watch?v=JVNisza0BQI
- Creating a new report library project to hold datamethods
- Adding report librariesto the AOT
- Deploying Dependent Multiple Projects
ScreenCast 18: Separating Reports from Code using Report Libraries
URL: https://www.youtube.com/watch?v=USJodsrlNOc
- Creating a new report library project to hold datamethods
- Adding report librariesto the AOT
- Deploying Dependent Multiple Projects
ScreenCast 19: Creating Your Own Layout and Style Templates
URL: https://www.youtube.com/watch?v=BnBKcQE2H3A
- Adding new Templates to a Report Library
- Creating a Table Style Template
- Adjusting the font and colors for detail rows via a Table Style Template
- Using Report Libraries to share Style Templates
- Saving Report Libraries to the AOD
ScreenCast 20: Editing Auto Design Templates
URL: https://www.youtube.com/watch?v=SdLHu04VPbA
- Creating a Report Layout Template
- Examining the Properties of a Table Style and Report Layout templates
- Setting text formatting across multiple nodes in templates
ScreenCast 21: Exploring Auto Design Report Layout Templates
URL: https://www.youtube.com/watch?v=w5vDFz1wj_c
- Headers
- Footers
- Section Styles
ScreenCast 22: Exploring Auto Design Style Templates
URL: https://www.youtube.com/watch?v=A5xTe4BJa5I
- Text Styles
ScreenCast 23: Tips for Previewing Reports
URL: https://www.youtube.com/watch?v=XyrKUdWgyfI
- Creating Vertical Tab Groups in Visual Studio
ScreenCast 24: Introduction to SharedComponents and SharedComponentsSRS
URL: https://www.youtube.com/watch?v=VY1UUn4k6HI
- Adding libraries from AX into your solution
ScreenCast 25: Getting the Values of an AX Enum into a Report
URL: https://www.youtube.com/watch?v=GA6uxXtt7RY
- Getting AX Enum metadata via a data method
ScreenCast 26: AX Enums in Reports (part 2)
URL: https://www.youtube.com/watch?v=6V_Fmp35YcA
- letting the user pick which enum to retrieve
ScreenCast 27: AX Enums in Parameters
URL: https://www.youtube.com/watch?v=HiKEgZ6X3oI
- Parameters with data-bound values
- Multi-Value parameters
ScreenCast 28: Introduction to Sorting, Grouping, and Filtering in Auto Designs
URL: https://www.youtube.com/watch?v=qmIo4PeiSz0
- Creating groups
- Adding Filters
- Sorting Data
ScreenCast 29: Getting Data from an XML Cloud Service (part 1)
URL: https://www.youtube.com/watch?v=BCPOeVP3ZsU
- Setting up the databinding before connecting to the service
- Refreshing dataset fields
ScreenCast 30: Getting Data from an XML Cloud Service (part 2)
URL: https://www.youtube.com/watch?v=6XKDX7p7Q0c
- Using System.Xml.Linq to connect to a web service
- Dynamically formatting report content
ScreenCast 31 Static and Dynamic Text Formatting
URL: https://www.youtube.com/watch?v=48sv95kLSVI
ScreenCast 32 Combining Fields and Showing Row Numbers
URL: https://www.youtube.com/watch?v=o-M6d1UmH9Q
Future Topics
- Grouping and Scope
- Grouping and Totaling
- Providing choices for parameters
- End-User filtering of data on the SSRS Server
- Alternating Row Colors
- Grouping and Totaling
- Charting
- Images / Static
- Images / From AX
- Images / Dynamic
- Getting Labels from AX
- Creating a Customized Parameter Experience
- Programmatically executing a Report
- PowerPivot and AX2009
- Custom Parameter UI in AX client
- Printing and Page Sizes in SSRS
- Embedding reports in Role Centers
- Personalization and Customization of Role Center Reports
- Accessing SQL Data Sources
- Report Builder for production reports
- Report Builder for ad hoc reports
- SMDL-based ad hoc reporting
- Precision Designs
- SSRS Actions / link to another report
- SSRS Actions / URL links
- SSRS Actions / Drill down to detail report
- SSRS Actions / Drill through to AX Form
- Creating a non-AX SSAS Cube
- Reports against Cube DataSources