How to create a new report type

Version: Yurbi v12

Role: Architect

Permission: Architect access to the application


Access the Architect Section

This section show how you can access the architect section

1. Once logged in, Click on Architect found on the sidebar.

A screenshot of a web pageAI-generated content may be incorrect.

 

Application and Report Type

This section shows the steps on how you can access the application and create a new report type.

1. Select the app to edit in App List and click Configure.

Note: For this guide, we have created a sample. Applications will vary depending on your organization's admin.

A screenshot of a computerAI-generated content may be incorrect.

2.  Click Add Category button

A white background with black linesAI-generated content may be incorrect.

3. Type in the name.

A screenshot of a computerAI-generated content may be incorrect.

 4. Click Save.

A screenshot of a computerAI-generated content may be incorrect.

Adding a database table

This section shows the steps on how you can add a database table to the report you are creating

 1. Click on Add Database Tables.

A screenshot of a search boxAI-generated content may be incorrect.

2. An Add SQL Table dialog box will appear

3. Leave the Table owner blank unless you know the specific table owner.

A screenshot of a computerAI-generated content may be incorrect.

4. Select the table you want to use by ticking off the box. Either use the search box or scroll down.

A screenshot of a computerAI-generated content may be incorrect.

5. Click Save

A screenshot of a computerAI-generated content may be incorrect.

Join Tables

This section shows the steps on how you can join database tables in the report you are creating.

1.  Add as many tables as needed within the report type.

2. To join tables, select two tables (only two can be joined at a time).

Note: After selecting two tables, the checkboxes for other tables will be grayed out.

A screenshot of a chatAI-generated content may be incorrect.

 3. Click the Join Database Tables button.

Note: The first table selected will be the primary table, and the join clause will appear in the second table.

A screenshot of a computerAI-generated content may be incorrect.

4. Select your desired join type.

A blue line on a white backgroundAI-generated content may be incorrect.

5. Do not change anything within the Parent Alias field box.

A white rectangular object with a black borderAI-generated content may be incorrect.

6. Choose your Field 1.

A screenshot of a computerAI-generated content may be incorrect.

7. Operator should be equal sign [=].

A white rectangular object with a black borderAI-generated content may be incorrect.

8. Alias should not be changed.

A white rectangular object with a black borderAI-generated content may be incorrect.

9. Select your Field 2 in the dropdown box.

10. For the 2nd Operator dropdown box, Select And.

A white rectangular object with a black borderAI-generated content may be incorrect.

11. Click Save.

A blue rectangle with white textAI-generated content may be incorrect.

 Repeat this process for the other tables you have added.

Note: Only the primary table has an empty join clauseother tables must have a join clause to establish relationships between them.

Add Report Fields

This section shows the steps on how you can add report fields to the report you are creating.

1. Click Configure Report Tree 

A screenshot of a computerAI-generated content may be incorrect.

2. In the report treeselect the root folder.

A screenshot of a computerAI-generated content may be incorrect.

3. Click the Folder button.

A screenshot of a computerAI-generated content may be incorrect.

4. Click Add Folder

 5. Type in the folder name.

A screenshot of a computerAI-generated content may be incorrect.

6. Click Save.

A blue rectangle with white textAI-generated content may be incorrect.

7. Select the newly created folder.

A screenshot of a computerAI-generated content may be incorrect.

8. Click Add Field to Folder

A black and white rectangle with black textAI-generated content may be incorrect.

9. Tick the box off beside the fields

A screenshot of a computerAI-generated content may be incorrect.

10. Configure the Display Name 

A white line on a white backgroundAI-generated content may be incorrect.

11. Click Add Field.

A screenshot of a computerAI-generated content may be incorrect.

 Repeat these steps as you choose which fields to add.  

 Reminder:

  •  Remember to arrange fields in a way that makes them easily accessible in the builder.
  •  There is no save button here. Any work done is automatically saved and appears in real time in the builder application.

And there you have it! You now know how to create a new report type in the architect section!