Add or Edit a Query Source

Query Sources enable you to specify the sites and site collections you want to report off in the Report file XML. If a user selects Report XML when configuring the report, these are the sites that are reported off.

The current version of the Report Editor does not support adding or editing Query Sources and as a consequence this must be done by editing the code of a report stored in the BrightWork Reporter Library.

Note:

Portfolios also allow you to select the sites you want to report off; however, sites queried in Portfolios must be added one by one. With a Query Source you can specify that a particular site and all its subsites be queried by the report.

To add or edit a Query Source:

  1. Open the report in the report editor of your choice.
  2. Search for </ViewDescriptor> and paste the below code after it (if the <QuerySources> code already exists then follow the steps from 3 onwards).

    <QuerySources>
    <QuerySource href="http://myserver/sites/mysite" recursive="yes"/>
    </QuerySources>
     
  3. Update the URL in the href to the site that you want to report off.
  4. Change the yes in recursive to no if you only want to report off this site and not its subsites.
  5. If you want to add another site, copy and paste the <QuerySource line (you can have as many of these as you like) and follow steps 3 and 4.
  6. Save the report file.
  7. Upload the file to the BrightWork Reporter library.

    Note:

    If you are using SharePoint Designer or Visual Studio to directly edit the file, you will not have to upload it.

Send feedback on this help.