How can I join tables in Create Reports?

[Doug McCormick]

I am new to reporting and doing some training.  In the meantime I thought I would post this and see if any quick responses.

How can I join 2 tables in Create reports?  For example if I wanted to join ast_contract to sys_usr to get more information about a supervisory manager in ast_contract?  That may be more difficult as dont have any specific keys I dont think.  The idea for this use case would be to run a report and ensure the manager is still active in user table.

This is an example use case and am curious on overall level on how to join tables in Reports.

[ryan_pope]

For this type of reporting, you should be able to access data associated with the manager through "dot-walking". In the report builder, when adding columns, click on the column you want to dive into, but instead of double clicking or adding to the right column, click the extension button between the two, to access data related to that user: 

[ryan_pope]

Side note - any column in this section that shows as green and has the "[+]" next to it, is a reference field that you can access the data for from the referenced table.

[Aman Kumar S]

If you want to join tables for different tables and create reports for those.

Preferable approach is Database views

Database views for beginners

Database views SN docs

Feel free to mark correct, If I answered your query.

Will be helpful for future visitors looking for similar questions 🙂