Need help reporting on rebort builder metadata

Question

HI there,

I am hoping to populate  a table that we use for documenting reports programmatically for old legacy report,

the info I would like to retrieve and populate for each report (report builder 3) is  :-

1 Fields included on the report 
2 Sort criteria - must have
3 Filters used - must have
4 Grouping - must have
5 Data sources (have found some code that may do this)

The plan is to auto populate a table  and then maybe manually edit it , I hate data entry when so much data is stored as metadata, any scripts or help you can offer me would be awesome.

cheers, rob

Answer 1

Hi There

Thanks for your posting. Please have a look on this thread that might help you

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/5343706f-090a-4a0d-ace5-a8d8788388d6/

Many thanks

Syed Qazafi Anjum

Answer 2

Syed,

Thanks for that link, I had come across it already however it is one of the best I've come across so thank you again.

I'm quite keen on the sorting and filtering aspects and have found nothing to date.

ok, thanks for your link.

cheers, rob

Answer 3

Hi Diese111,

Thanks for your posting.

In your case, I think that you can look into report parts in Reporting Services. Report parts are self-contained report items that are stored on the report server, we can save a report part with its dependent datasets and shared data source references so it can be reused in other reports.

For more information, please refer to the articles below:
Report Parts and Datasets in Report Builder: http://technet.microsoft.com/en-us/library/ee633649.aspx
Managing Report Parts: http://technet.microsoft.com/en-us/library/ee636148.aspx

Regards,
Bin Long

---

Bin Long

TechNet Community Support