Export (0) Print
Expand All

Lesson 5: Publish the Report Definition to the Report Server


Applies To: SQL Server 2016 Preview

The last step for updating the report definition is to publish it back to the report server.

To publish the report to the report catalog

  1. Replace the code for the PublishReportDefinition() method in your Program.cs file (Module1.vb for Visual Basic) with the following code:

    private void PublishReportDefinition()
        System.Console.WriteLine("Publishing Report Definition");
        string reportPath =
            "/AdventureWorks 2012 Sample Reports/Company Sales 2012";
        XmlSerializer serializer =
            new XmlSerializer(typeof(Report));
        using (MemoryStream stream = new MemoryStream())
            // Serialize the report into the MemoryStream
            serializer.Serialize(stream, _report);
            stream.Position = 0;
            byte[] bytes = stream.ToArray();
            // Update the report on the report server
            Warning[] warnings = 
                _reportService.SetItemDefinition(reportPath, bytes, null);

    Private Sub PublishReportDefinition()
        System.Console.WriteLine("Publishing Report Definition")
        Dim reportPath As String = _
            "/AdventureWorks 2012 Sample Reports/Company Sales 2012"
        Dim serializer As XmlSerializer = _
            New XmlSerializer(GetType(Report))
        Using stream As MemoryStream = New MemoryStream
            'Serialize the report into the MemoryStream
            serializer.Serialize(stream, m_report)
            stream.Position = 0
            'Update the report on the report server
            Dim bytes As Byte() = stream.ToArray
            Dim warnings As Warning() = _
                m_reportService.SetItemDefinition(reportPath, bytes, Nothing)
        End Using
    End Sub

In the next lesson, you will compile and run the SampleRDLSchema application. See Lesson 6: Run the RDL Schema Application (VB/C#).

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft