SQL query for 'Report and Layout Manager' Menu Location

[Former Member]

I am trying to create a list of all customized reports from 'Report and Layout Manager' with table RDOC.

However, I am not sure how to get the field "Menu Location" since it does not seem to be stored in this table. How can I get that field?

Thanks,

Ajay Audich

[KennedyT21 · Accepted solution]

Hi Ajay...

It is not stored in the table . so it is not possible to get those information

Rgds

Keny

[kothandaraman_nagarajan]

Please check reply time and assign correct answer.

[former_member191075]

Hi Ajay ,,

You want to create List of all customize reports , Then

Try this Select * from RDOC where Author ='manager'

I think It will solve your issue.

Regards/Thanks

Amol

[kothandaraman_nagarajan]

There is no field in RDOC table to store menu location for customized report.

[kothandaraman_nagarajan]

Hi,

What you mean by menu location? Are you looking for document name for selected report?

Thanks & Regards,

Nagarajan

[Former Member]

If you open and look at the Reports and Layout window you will see a field called Menu location with the path where this report has been saved to for example Sales > Sales Reports and so on

I need that path which does not show on RDOC table

[kothandaraman_nagarajan]

Is it possible to share screen shot?

[Former Member]