Create a report with 2 tables Data

[Pallavi65]

Hi all,

I need to send a report which includes the below following columns in the Excel

1. Reports which were not run since 3 months

2. Last run

3. Created by

4. Updated by

5. Users to whom all the report was shared. (this is important)

So please help how to fetch this report

Regards,

Lucky

[Pallavi65]

Thanks Chandu,

It's working.

Can you tell me why to write Where clause in report statistics table?

Regards,

Lucky

[Jaspal Singh]

Where clause actions as a join between teh tables. So, you can consider it to be a common or primary key between 2 tables which acts as base to display only common data from the tables.

[Pallavi65]

Hi Jaspal,

Currently I am able to get Report ID, Last Run, User ID columns in the Database view when combined the two tables data.

But I want to add other two columns like, Report Created By and Updated by

For this, I need to add one more table to the view, i.e., sys_report table

But I am not able to understand how to write the where clause.

Can you please help

Regards,

Lucky

[Jaspal Singh]

No need. When you create a report you can simply dot-walk Report table as report_stats table holds Report name & access related fields.

[Chandu Telu]

Hi Pallavi,

You can add the dot walk -in for this

Thanks
Chandu Telu
Please Mark ✅ Correct/helpful, if applicable,