How to get Parent Field in Child Table Report

Sri63 · ‎02-07-2019

Hi All,

In report I am looking to get PARENT FIELD VALUE from CHILD report.

Eg:

Below is Child Table and Its Records

Child Table: child_table
Extends: parent_table

Child ID               Child Type              Child Device                Month
--------               ----------              ------------                ---------
CH000001               Engage                  device 01                   January
CH000001               Engage                  device 02                   January
CH000001               Engage                  device 03                   January
CH000002               Engage                  device 04                   January
CH000002               Engage                  device 05                   January
CH000002               Engage                  device 06                   January

CH000001               Engage                  device 11                   February
CH000001               Engage                  device 12                   February
CH000001               Engage                  device 13                   February
CH000002               Engage                  device 14                   February
CH000002               Engage                  device 15                   February
CH000002               Engage                  device 16                   February

CH000001               Engage                  device 21                   March
CH000001               Engage                  device 22                   March
CH000001               Engage                  device 23                   March
CH000002               Engage                  device 24                   March
CH000002               Engage                  device 25                   March
CH000002               Engage                  device 26                   March

Below is Parent Table

Parent Table: parent_table

Number           Title             Owner            
--------         -----             -----
CH000001         English           ggggg
CH000002         Science           sssss

Now I created a report using CHILD_TABLE.

Report:
-------

Table : Child_table

Chart: BAR Chart

Group By: Month

Stack By: ID

Aggregation: Count

As shown in the above graph ... INSTEAD of . CH000 i want to it's Title (from parent table) to be displayed in the report.

CH00001 ==> English (from Parent Table)
CH00002 ==> Science (from Parent Table)

I want to achieve something like

Fabian Kunzke · ‎02-08-2019

Hello,

The easiest fix for that (although quite inconsitent) is to use the parent.name as a grouping criteria (esentially dotwalking the referenced field). This is inconsisten if the naming for the parent is not unique.

Other than that check what the Display Field for the parent table is (as ist probably is the field "number"). Change the display field to the name instead. You can do that within the dictionary definition of the table fields. Please note: This will apply to every reference. Therefore, whenever this parent table is used, the name instead of the number would be shown. This would mean a greater impact to your overall instance.

Kind regards

Fabian

Sri63 · ‎02-11-2019

Hi Fabian,

Thanks for the quick response.

The display field for the parent is STRING type. I have tried DOT WALKING but it is not showing up.

Fabian Kunzke · ‎02-12-2019

Hello,

Well, dot walking will only work with reference fields. Check with your requirements if changing that field to a reference one would be an option, as it is (imo) the best solution for your requirement. However, if that is not an option you will have the alternative to script your report. Check the documentation for this here (please note, i have not found a newer version than geneva).

Overall i would advice to use a reference field as it would also improve the usability with the parent field. Please not, that this change would probably need a fix script, which would properly set up the references. Best way to go along with this is to do an export before the deployment of such a change. In this case you have a backup if something goes wrong.

Kind regards

Fabian

Ashutosh Munot1 · ‎02-12-2019

HI,

Display value of That table will be true for Number field. If you want to show that label you have to group by that field on parent table.

Thanks
Ashutosh