I thought I would post how to get a simple custom SSRS report included in a management pack using VSAE.
There are articles out there but I was not, for some reason, making the connection between the REPORT and the RESOURCE in my head. The following article link explains in more detail the report options. I only wanted to understand the most basic requirements to get a report into a Management Pack. http://blog.scomskills.com/report-fragmentvisual-studio-authoring-extensions/
I’ll use the following file name for the example “My.Report.rdl” which contains the entire XML for the report definition.
Add the “My.Report.rdl” file to the solution.
Add a management pack fragment named “MyReport.mpx” and add the following XML code:
<Report ID=”REPORT.ID” Accessibility=”Internal” Visible=”true“>
<ReportResource ID=”RESOURCE.ID” Accessibility=”Internal” FileName=”MyReport.rdl” MIMEType=”application/octet-stream“ HasNullStream=”false” />
REPORT.ID you define
RESOURCE.ID you define
The <ReportDefinition> tag should contain the RESOURCE.ID you define in the <ReportResource ID=””…> attribute. This links the report to the resource.
The <ReportResource FileName=””> attribute contains the file name of the RDL file that was added to the solution. This links the resource to the file in the solution.
So at this point the REPORT tag points to the RESOURCE tag which points to the FILE with the report definition and can be included in the management pack. You don’t actually include the XML for the report in a management pack fragment.
At this point the solution should be ok to build and then import.
I used the “Data Warehouse Main” as a shared data source in my SSRS report so that I can leverage the Data Source that is already there. If you create a custom data source, you will have to create the custom data source to the SSRS implementation in order to leverage it.