adding the hidden = 0 did the trick. was looking for this field for ages. I missed it somehow.

Thanks every so much guys

Appreciated.

Enis

Hi ,

I just don't know what the filter should be to return only the visible reports.

Hi,

That's true, but most of the unused reports are hidden in the reporting services. I am trying to return only the ones that are visible by everyone.

I don't think there...

Hi,

It works! and it was really easy to implement.

Much appreciated.

Guys,

Just to let you know there isn't significant difference between two approaches.

Appreciate your help again.

Thanks

Enis

Hi Guys,

Phil - it worked like a charm - thank you.

I am currently adopt mc's approach with yours to MC's 3. approach. It is very similar to your approach...

Guys,

Thank you for the useful tips.

CEWII - Is there any way to send me the project file as I can only see the executeable. I want to see how...

Hi Cewii,

Thanks very much for taking time to reply. I think I have followed what you were saying. I am leaving now but I will try this tomorrow and update...

Hi John,

I would have however the stored procedure only returns the information for one site at a time. I could always change it of course but this issue has become...

Hi Mc,

Yes there is.

Enis