query underneath the report, possible?

andy_dufresne · ‎05-17-2017

Thanks to nice graphical representation of parent and dot-walking in the report-module, I was able create the exact report. Now my next step is to write it in query format, so I can build further on it. I'm struggling to get the parent child relationship as easily as in the report. So I was wondering if there was anyway we can find the 'encoded query', regular query behind a report? Any clues? Thanks for reading!

Alikutty A · ‎05-17-2017

On your first image, Click on the i information icon and this will open the actual report configuration.

The report configuration will look something like this

On this form, you should right click on header and do a Show XML.

Please try it once, If this does not help you can add the Filter column on the list layout and also export the data.

Thank You

Please Hit Like, Helpful or Correct depending on the impact of response

View solution in original post

andy_dufresne · ‎05-17-2017

Mr.Alikutty, because of genius like you, I keep coming back to this forum!! Million thanks for helping me out, Sir! Did anyone tell you, that you don't give up ? 😉

Alikutty A · ‎05-17-2017

Glad it worked

Come back again and we are glad to help you always.

Have a nice day ahead!

Thank You

Please Hit Like, Helpful or Correct depending on the impact of response