We have our own Report Administrator and Report Manager which provide customisations for our product. The reports are still stored in the Report Store (using ReportService2010.asmx) and we annotate the reports with additional properties of our own.
However, the performance of ListChildren and GetProperties
is causing us serious performance issue.
1) not being able to return just the sub-folders of a folder. If a folder contains 1000 reports and 1 folder I have to iterate over all 1001 items to get the single folder. In fact I'd like to be able to list per type (not just name and description).
2) not being able to get a report and properties in one call, after calling ListChildren I then have then to call GetProperties on each.
Are there any plans to provide a richer interface to the underlying ReportStore without having to resort to accessing the database directly (which is not very future proof!).
View Complete Post