Report on Nested Data structure

Unknown

Report on Nested Data structure

Unknown

I have a Main data structure that has a nested data structure as one of the fields. Reports allow us to have one data source. Is there a way for us to add the nested data structure in the same report so I have all the fields on the report?
[font=Roboto, Arial, Helvetica, sans-serif]
[font=Roboto, Arial, Helvetica, sans-serif]
[/font]
[font=Roboto, Arial, Helvetica, sans-serif]
[/font]

[/font]

Unknown

To report on the parent data structure and the nested data structure, we will need to use a Database query as the report source.

First, we will need to create a database query that will inner join the two tables.
[ul][li]Navigate to a Designer Folder[/li][li]Click "Create Datatypes/Integration[/li][li]Navigate to DataBase Integration>Add Query[/li][li]Here we can add the query to join the two tables.[/li][li]Notes: the fields we add using the query are the fields that will show up on report that we can add.[/li][li]We can run the query to test if it works as well.[/li][/ul]

[color=rgb(127, 140, 141)][font=Roboto][img]att2[/img][/font][/color]
[color=rgb(127, 140, 141)][font=Roboto]
[/font][/color]

On a report, we can use the created query as a data source.
[ul][li]For the data source navigate to Common>Local connection> "name of the query you created"[/li][/ul]
[color=rgb(127, 140, 141)][font=Roboto][img]att1[/img][/font][/color]
[i]edited by faiza@decisions.com on 10/20/2020[/i]