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

[Chandu Telu]

Hi,

Report Shared with Users/Group Information will have in "sys_report_users_groups" Group

You can create a data base view table between report and "sys_report_users_groups" you can get the report

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

[Pallavi65]

Hi Chandu,

How to create a database view to get one report from the two tables?

I just want to send an Excel with Report name, Last run and the users sharing that report. So totally 3 columns.

Can you explain me plz

Regards,

Lucky

[Pallavi65]

Hi,

I have created a Database View (this is my first time)

1. Given Name and Label (abcxyz) and saved the form

2. In the Related Lists, View Tables added two different tables report_stats & sys_report_users_groups 

3. In the report_stats, I have added two fields in the View Fields related list 

   - Last run & Report 

4. In the sys_report_users_groups, I have added User ID field and in the Where Clause written like this

rs_sys_id=ug_user_id

Plz note: rs is for Report Statistics and ug for Report Users and Groups

 But when I clicked on try it

Please help me how to achieve this

Regards,

Lucky

[Chandu Telu · Accepted solution]

Hi,

Try in below way and let us know if you see any issues

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