lesson-5-publish-the-report-definition-to-the-report-server.md

title	Lesson 5: Publish the Report Definition to the Report Server | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql-server-2014
ms.reviewer
ms.technology	reporting-services-native
ms.topic	conceptual
ms.assetid	57fab70f-4a72-4413-a0ad-d0525caca3f7
author	markingmyname
ms.author	maghan
manager	kfile

Lesson 5: Publish the Report Definition to the Report Server

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 [!INCLUDEvbprvb]) 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  

Next Lesson

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

See Also

Updating Reports Using Classes Generated from the RDL Schema (SSRS Tutorial)
Report Definition Language (SSRS)