AX SSRS Reporting ScreenCast List

  • Article

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