Click to Rate and Give Feedback
TechNet
TechNet Library
SQL Server
SQL Server 2012
ReportService2005
 CreateReport Method
Community Content
In this section
Statistics Annotations (0)
Collapse All/Expand All Collapse All
ReportingService2005..::.CreateReport Method

Adds a new report to the report server database.

Namespace:  ReportService2005
Assembly:  ReportService2005 (in ReportService2005.dll)
Visual Basic (Declaration)
Public Function CreateReport ( _
	Report As String, _
	Parent As String, _
	Overwrite As Boolean, _
	Definition As Byte(), _
	Properties As Property() _
) As Warning()
Visual Basic (Usage)
Dim instance As ReportingService2005
Dim Report As String
Dim Parent As String
Dim Overwrite As Boolean
Dim Definition As Byte()
Dim Properties As Property()
Dim returnValue As Warning()

returnValue = instance.CreateReport(Report, _
	Parent, Overwrite, Definition, Properties)
C#
public Warning[] CreateReport(
	string Report,
	string Parent,
	bool Overwrite,
	byte[] Definition,
	Property[] Properties
)
Visual C++
public:
array<Warning^>^ CreateReport(
	String^ Report, 
	String^ Parent, 
	bool Overwrite, 
	array<unsigned char>^ Definition, 
	array<Property^>^ Properties
)
F#
member CreateReport : 
        Report:string * 
        Parent:string * 
        Overwrite:bool * 
        Definition:byte[] * 
        Properties:Property[] -> Warning[] 
JScript
public function CreateReport(
	Report : String, 
	Parent : String, 
	Overwrite : boolean, 
	Definition : byte[], 
	Properties : Property[]
) : Warning[]

Parameters

Report
Type: System..::.String
The name of the new report.
Parent
Type: System..::.String
The fully qualified URL of the parent folder to which to add the report.
Overwrite
Type: System..::.Boolean
A Boolean expression that indicates whether an existing report with the same name in the location specified should be overwritten.
Definition
Type: array<System..::.Byte>[]()[]
The report definition to publish to the report server, which is the content of an .rdl file. The XML data is defined by the http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition/ Report Definition Language .
Properties
Type: array<ReportService2005..::.Property>[]()[]
An array of Property objects that contains the property names and values to set for the report.

Return Value

Type: array<ReportService2005..::.Warning>[]()[]
An array of Warning objects that describes any warnings that occurred when the report definition was validated.

The table below shows header and permissions information on this operation.

SOAP Headers

(In) BatchHeaderValue

(Out) ServerInfoHeaderValue

Required Permissions

Creating a new report: CreateReport on Parent AND ReadProperties on the report's data sources AND ReadProperties on the report's datasets

Updating an existing report: UpdateReportDefinition on Report AND UpdateProperties on Report (if Properties contains properties) AND UpdateProperties on the report's data sources AND UpdateProperties on the report's datasets

The length of the Parent parameter cannot exceed 260 characters; otherwise, a SOAP exception is thrown with the error code rsItemLengthExceeded.

The Parent parameter cannot be null or empty or contain the following reserved characters: : ? ; @ & = + $ , \ * > < | . ". You can use the forward slash character (/) to separate items in the full path name of the folder, but you cannot use it at the end of the folder name.

If errors occur, the report is not created.

Adding a report to the report server database modifies the ModifiedBy and ModifiedDate properties of the parent folder.

To compile this code example, you must reference the Reporting Services WSDL and import certain namespaces. For more information, see Compiling and Running Code Examples. The following code example publishes a report in the form of a Report Definition Language (RDL) file to a report server database.

Visual Basic
Imports System
Imports System.IO
Imports System.Web.Services.Protocols

Class Sample
   Public Shared Sub Main()
      Dim rs As New ReportingService2005()
      rs.Credentials = System.Net.CredentialCache.DefaultCredentials

      Dim definition As [Byte]() = Nothing
      Dim warnings As Warning() = Nothing
      Dim name As String = "MyReport"

      Try
         Dim stream As FileStream = File.OpenRead("MyReport.rdl")
         definition = New [Byte](stream.Length - 1) {}
         stream.Read(definition, 0, CInt(stream.Length - 1))
         stream.Close()

      Catch e As IOException
         Console.WriteLine(e.Message)
      End Try

      Try
         warnings = rs.CreateReport(name, "/Samples", False, definition, Nothing)

         If Not (warnings Is Nothing) Then
            Dim warning As Warning
            For Each warning In  warnings
               Console.WriteLine(warning.Message)
            Next warning

         Else
            Console.WriteLine("Report: {0} created successfully with no warnings", name)
         End If

      Catch e As SoapException
         Console.WriteLine(e.Detail.InnerXml.ToString())
      End Try
   End Sub 'Main 
End Class 'Sample
C#
using System;
using System.IO;
using System.Web.Services.Protocols;

class Sample
{
   public static void Main()
   {
      ReportingService2005 rs = new ReportingService2005();
      rs.Credentials = System.Net.CredentialCache.DefaultCredentials;

      Byte[] definition = null;
      Warning[] warnings = null;
      string name = "MyReport";

      try
      {
         FileStream stream = File.OpenRead("MyReport.rdl");
         definition = new Byte[stream.Length];
         stream.Read(definition, 0, (int) stream.Length);
         stream.Close();
      }

      catch(IOException e)
      {
         Console.WriteLine(e.Message);
      }

      try
      {
         warnings = rs.CreateReport(name, "/Samples", false, definition, null);

         if (warnings != null)
         {
            foreach (Warning warning in warnings)
            {
               Console.WriteLine(warning.Message);
            }
         }

         else
            Console.WriteLine("Report: {0} created successfully with no warnings", name);
      }

      catch (SoapException e)
      {
         Console.WriteLine(e.Detail.InnerXml.ToString());
      }

   }
}
Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2012 Microsoft. All rights reserved. Terms of Use | Trademarks | Privacy Statement
Page view tracker