Saveen Reddy's blog : Dynamics AX 2009: Business Intelligence – the Matrix Layout for Auto Design reports

Dynamics AX 2009: Business Intelligence – the Matrix Layout for Auto Design reports

Previously with Auto Design layouts, I left off with by saying that some required us to tweak the Datasets to get them to work. In this post, we’ll change the properties of the datasets and see how that enables the Matrix and chart layouts.

First, we need more data. I’ve revised the my Data Method to return more patient data …

using System;
using System.Collections.Generic;
using System.Security.Permissions;
using System.Data;
using System.Linq;

using Microsoft.Dynamics.Framework.Reports;
public partial class Report1
{

    [DataMethod(), AxSessionPermission(SecurityAction.Assert)]
    public static System.Data.DataTable DataMethod_Patient_Data()
    {
        int max_age = 60;
        int min_age = 18;

int min_weight = 140; // weight in pounds
int max_weight = 240;

var areas = new[] { "Thoracic Surgery", "Emergency", "ENT" };
var doctors = new [] { "Reddy", "Jackson", "Tordilla" };

        var r = new System.Random();
        var names = new string[] {      "Akuma", "Ryu", "Ken",
                                        "Guile", "M.Bison" ,
                                        "Chun-Li", "Cammy" ,
                                        "Blanka", "E.Honda",
                                        "Gen", "Birdie", "Adon",
                                        "Sagat", "Dhalsim", "Zangief",
                                        "Balrog", "Vega"};

        var records = from name in names
                      select new
                      {
                          Name = name,
                          Age = r.Next(min_age, max_age),
                          Weight = r.Next(min_weight, max_weight),
                          Area = areas[ r.Next(0, areas.Length) ],
                          Doctor = doctors [ r.Next(0, doctors.Length)] ,
                          Hypertension = (r.NextDouble() > 0.9) ? true : false,
                          Diabetes = (r.NextDouble() > 0.85) ? true : false,
                          Asthma = (r.NextDouble() > 0.75) ? true : false
                      };

var datatable = Isotope.Data.DataUtil.DataTableFromEnumerable(records);

return datatable;

}

And then create a Data set that uses this Data method …

And when I drag it into the Designs node a new Design is created which I renamed to AutoDesign_Table_0 and set the styles for the layout and the table. The results are this.

Instead of modifying that Data set we will duplicate it using Copy

And then Paste

Which created this Dataset

And I will rename this to “Dataset_PatientData_1”

And set the Default layout to Matrix

And now drag it into the Designs node. A new AutoDesign is created. When you try to preview the design …

Obviously something is missing … let’s focus on the errors.

We obviously need to set something.

For this report, let’s say we want have a question about the number patients, we want to know who is treating them and what these patients are doing at the hospital.

In other words we want a matrix like this …