Change Request report (CR info and affected Doc info)

[lgrant]

Hi report wizards - I need some help.

I am trying to create a report for an audit on changes to documents. Ideally I would like the Change Request number (and some info on the CR) and what documents were on the CR (doc info etc) and it would be wonderful if I could also add in who approved the CR (but that could be a different report).

I am stuck at this point (report attached) in that the document numbers so several times in the row?

[Marco_Tosin]

You should take a look at this document Resource for reporting I wrote (it's very long).

It is divided in sections and one of these is about Change Management.

In this document you can find some useful tips & tricks about reporting and also lots of report ready to use.

You should also read the presentations I attached at the end of the document.