Thursday, 15 July 2010

ssrs 2008 - What's the "cheapest" way to check if a report exists on my Reporting Server? -


Looking at a SQL Server 2008 Reporting Services installation, what is the "cheapest" way to check (according to the report ) Name + Report path, such as / myReports / SomeOddballReport is present (or not)?

I look at many potential candidates on the report server web service - which is the fastest and the least amount of a system resource ?? GetReportDefinition ()

  • GetReportLink ()
  • GetProperties ()
  • Is anyone else missing me? Thanks for any hints and hints! I feel a lack of documentation and samples in the reporting service webservice interface, in fact ......

    < P> MS reporting on MS CSC due to ongoing reporting services is an easy choice for you to return the name of the report and see if any report exists. Within SQL Server there is a database called ReportServer that contains a table that is called a catalog within the database. The catalog table stores data sources, reports, and some other important information. The main fields are "Name" and "Type" type A report / There is a difference between a data source / etc. Definitely the name is obvious, this is the name of the report.

    To get all the reports at your reporting service frequency, try:

      to get all data sources 

      Usage Select the report server SELECT name, from the list where list = 5  

    So if you have a name or at least know that a report starts with you, Can query:

      See my blog for more information: 

    Since then As this heat that has been noted is a path field that may include data such as:

    / per Itiim / Department job hours Summary


    No comments:

    Post a Comment