View source for Technics:Reporting Services Integration

==Installation==
The CoPlanner Reporting Services Integration (CRSI) is located in the directory execute\Reporting and consists of two components:

:*A server component which must be installed on the report server.
:*A client component which must be installed on the client computer (only if report creating and editing  using Business Intelligence Development Studio (BIDS) will be done). For SQL Server 2012 you will find a seperate component.

The setups for both components must be executed with administrator rights.

{| {{Bausteindesign1}}
|-
| <span style="color: darkblue;">'''Hint'''</span> &nbsp;The BIStudioConfigurator application must always be made from the corresponding folder of reports. (SQL Server 2008R2 of the Reporting folder, SQL Server 2012 from  Reporting.2012 folder and SQL Server 2014 from the folder Reporting.2014)
|}


===Server Component Setup===
The server component has to be installed using '''ReportServerConfigurator.exe''' which must be executed on the report server. The setup will verify the integrity of the files located in the '''DataExtension'''-directory, recognize al locally installed report servers (using the registry) and install the extension

[[Image:T_Screenshot des ReportServerConfigurator.jpg|thumb|center|Technical, ReportServerConfigurator Screenshot]]

If there are several local report servers the default instance resp. first instance (order appearing in the registry) will be chosen. The setup will only take configured instances into account. Using command line arguments other instances can be selected. Command line arguments can start with / or 

{| class="wikitable" width={{{breite|100%}}}
|- {{Tabellentitel}} 
|width="200pt" |Argument  
|Description
|-
|autoinstall
|Start installation after launching setup
|-
|autoquit
|Quit setup after successfull (!) installation
|-
|instance
|Instance selection (the next argument must define the report server’s instance name)
|-
|?
|Show help
|-
|help
|Show help
|}

An example for automatic installation for instance SQL2012:

<source lang="csharp">
ReportServerConfigurator –autoinstall –autoquit –instance SQL2012
</source>

===Client Component Setup===
The client component hast do be installed using '''BiStudioConfigurator.exe''', which must be executed on each PC which will be used for designing reports using BIDS. The setup will verify the integrity oft he files in the '''DataExtension'''- and '''QueryDesigner'''-directory, recognize locally installed Visual Studio versions (using the registry) and install the extension.

[[Image:T_Screenshot des BiStudioConfigurator.jpg|thumb|center|Technical, Screenshot des BiStudioConfigurator]]

If several versions of Visual Studio exist, the last one with an report designer extension will be chosen. Using command line arguments other versions can be selected. Command line arguments can start with / or –.

{| class="wikitable" width={{{breite|100%}}}
|- {{Tabellentitel}} 
|width="200pt" |Argument  
|Description
|-
|autoinstall
|Start installation after launching setup
|-
|autoquit
|Quit setup after successfull (!) installation
|-
|version
|Version selection (the next argument must specify the Visual Studio version number)
|-
|?
|Show help
|-
|help
|Show help
|}

An example for automatic installation for Visual Studio 2008 (9.0):

<source lang="csharp">BiStudioConfigurator –autoinstall –autoquit –version 9.0</source>

===Manuel Installation===
The steps for manual installation are described in the following document and its references: 
http://msdn.microsoft.com/en-us/library/ms155104.aspx

You have to add following extension in file ''RSReportServer.config'' in section Data:

 <font color="#0000ff"><</font><font color="#a31545">Extension </font><font color="#ff0000">Name</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">CoPlanner</font><font color="#000000">"</font> <font color="#ff0000">Type</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">Cop.Reports.DataExtension.CopConnection,Cop.Reports.DataExtension</font><font color="#000000">"</font><font color="#0000ff">/></font>

You have to create a codegroup with ''FullTrust''-rights in file ''rssrvpolicy.config'':

 <font color="#0000ff"><</font><font color="#a31545">CodeGroup </font><font color="#ff0000">class</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">UnionCodeGroup</font><font color="#000000">"</font> <font color="#ff0000">version</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">1</font><font color="#000000">"</font> <font color="#ff0000">PermissionSetName</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">FullTrust</font><font color="#000000">"</font> <font color="#ff0000">Name</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">CoPlannerCodeGroup</font><font color="#000000">"</font> <font color="#ff0000">Description</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">CodeGroup for CoPlanner DataExtension</font><font color="#000000">"</font><font color="#0000ff">/></font>
 <font color="#0000ff"><</font><font color="#a31545">IMembershipCondition </font><font color="#ff0000">class</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">UrlMembershipCondition</font><font color="#000000">"</font> <font color="#ff0000">version</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">1</font><font color="#000000">"</font> <font color="#ff0000">Url</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">C:\Programme\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\Cop.Reports.DataExtension.dll</font><font color="#000000">"</font><font color="#0000ff">/></font>

On the client computer you have to add the extendion in the ''Data''-section and the query designer in the ''Designer''-section in file ''RSReportDesigner.config'':

 <font color="#0000ff"><</font><font color="#a31545">Extension </font><font color="#ff0000">Name</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">CoPlanner</font><font color="#000000">"</font> <font color="#ff0000">Type</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">Cop.Reports.DataExtension.CopConnection,Cop.Reports.DataExtension</font><font color="#000000">"</font><font color="#0000ff">/></font>
 <font color="#0000ff"><</font><font color="#a31545">Extension </font><font color="#ff0000">Name</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">CoPlanner</font><font color="#000000">"</font> <font color="#ff0000">Type</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">Cop.Reports.QueryDesigner.CopQueryDesigner,Cop.Reports.QueryDesigner</font><font color="#000000">"</font><font color="#0000ff">/></font>

You have to create a codegroup with ''FullTrust''-rights in file ''rspreviewpolicy.config'':

 <font color="#0000ff"><</font><font color="#a31545">CodeGroup </font><font color="#ff0000">class</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">UnionCodeGroup</font><font color="#000000">"</font> <font color="#ff0000">version</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">1</font><font color="#000000">"</font> <font color="#ff0000">PermissionSetName</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">FullTrust</font><font color="#000000">"</font> <font color="#ff0000">Name</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">CoPlannerCodeGroup</font><font color="#000000">"</font> <font color="#ff0000">Description</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">CodeGroup for CoPlanner DataExtension</font><font color="#000000">"</font><font color="#0000ff">/></font>
 <font color="#0000ff"><</font><font color="#a31545">IMembershipCondition </font><font color="#ff0000">class</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">UrlMembershipCondition</font><font color="#000000">"</font> <font color="#ff0000">version</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">1</font><font color="#000000">"</font> <font color="#ff0000">Url</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">C:\Programme\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Cop.Reports.QueryDesigner.dll</font><font color="#000000">"</font><font color="#0000ff">/></font>

==Configuration==

CoPlanner Reporting Services Integration settings you will find in [[Technics:CoPlanner-Server#SSRSSettings|SvrConfig.xml]].

The following points must be taken into account:
:*If any of the required elements is missing or empty all reporting functions in the CoPlanner client will be disabled or hidden.
:*The server name in the URLs must not be localhost.
:*The folders on the report server won’t be created automatically.
:*The variable names are case-sensitive.


In the SSRS CoPlanner datasource the connection string has to be equal following the client connection string.

2 examples:

1) <  COP10: Server=Rechnername;Port=8963;TcpFormatter=Native

2) >= COP10: ServerUrl=http://Rechnername:8080/coplanner;

===Data Processing Extension (DataExtension)===

You can cinfugure the data processing extension in configuration file RSReportServer.config and RSReportDesigner.config. The following figure shows all kinds of options with their default values. All elements and attributes are optional, that means if they are missing, the default value will be taken. If the server delivers an error message, like the figure below, the TimeOut Setting values must be increased.


[[Image:T_Screenshot der Fehlermeldung.png|thumb|center|Technics, Server Error Message]]



 <font color="#0000ff"><</font><font color="#a31545">Extension </font><font color="#ff0000">Name</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">CoPlanner</font><font color="#000000">"</font> <font color="#ff0000">Type</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">...</font><font color="#000000">"</font><font color="#0000ff">></font>
 <font color="#0000ff">   <</font><font color="#a31545">Configuration</font><font color="#0000ff">></font>
 <font color="#0000ff">      <</font><font color="#a31545">Connection </font><font color="#ff0000">LogLevel</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">ErrorWarning</font><font color="#000000">"</font><font color="#0000ff">/></font>
 <font color="#0000ff">      <</font><font color="#a31545">Connection </font><font color="#ff0000">LogLevel</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">ErrorWarning</font><font color="#000000">"</font> <font color="#ff0000">TimeOut</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">10000</font><font color="#000000">"</font><font color="#0000ff">/></font>
 <font color="#0000ff">      <</font><font color="#a31545">Reader </font><font color="#ff0000">LogLevel</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">ErrorWarning</font><font color="#000000">"</font><font color="#0000ff">/></font>
 <font color="#0000ff">      <</font><font color="#a31545">CopApiClientStore </font><font color="#ff0000">LogLevel</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">ErrorWarning</font><font color="#000000">"</font> <font color="#ff0000">EntryLifeTime</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">30000</font><font color="#000000">"</font><font color="#0000ff">/></font>
 <font color="#0000ff">      <</font><font color="#a31545">Session </font><font color="#ff0000">ConnectTimeOut</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">2000</font><font color="#000000">"</font> <font color="#ff0000">ConnectMaxAttempts</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">5</font><font color="#000000">"</font> <font color="#ff0000">DisConnectTimeOut</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">2000</font><font color="#000000">"</font><font color="#0000ff">/></font>
 <font color="#0000ff">      <</font><font color="#a31545">Kerberos </font><font color="#ff0000">SPN</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff"></font><font color="#000000">"</font><font color="#0000ff">/></font>
 <font color="#0000ff">      <</font><font color="#a31545">ServerCommandLog </font><font color="#ff0000">Active</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">False</font><font color="#000000">"</font> <font color="#ff0000">Path</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff"></font><font color="#000000">"</font><font color="#0000ff">/></font>
 <font color="#0000ff">   </</font><font color="#a31545">Configuration</font><font color="#0000ff">></font>
 <font color="#0000ff"></</font><font color="#a31545">Extension</font><font color="#0000ff">></font>


 <font color="#ff0000">LogLevel</font><font color="#0000ff">=</font><font color="#000000">""</font>
The attribute LogLevel defines the granularity for logging of the component. All messages are logged, with a smaller or equal granularity of the configured granularity. Following table shows the available steps.

{| class="wikitable" width={{{breite|100%}}}
|- {{Tabellentitel}} 
|width="200pt" |Level  
|Description
|-
|None
|NoLogging
|-
|Error
|Error message
|-
|Warning
|Error message and warning
|-
|ErrorWarning
|Compatibility to previous versions
|-
|Info
|Additional state messages
|-
|Verbose
|Extended Logging
|}

Log-file ''coprsint.log'' will be written in the temporary user folder of the report server. The report server generally use the folder
C:\Windows\Temp,
and for BIDS (Windows 2003 Server) the folder
C:\Documents and settings\''username''\Lokale Einstellungen\Temp

 <font color="#ff0000">TimeOut</font><font color="#0000ff">=</font><font color="#000000">""</font>
The following table shows the available time specifications (in millisecond) and their lower and upper limits. 

{| class="wikitable" width={{{breite|100%}}}
|- {{Tabellentitel}} 
|width="200pt" |Element  
|Attribut
|Min
|Max
|Standard
|-
|Command
|TimeOut
|100
|
|10000
|-
|CopApiClientStore
|EntryLifeTime
|100
|120000
|30000
|-
|Session
|ConnectTimeOut
|100
|
|2000
|-
|Session
|DisConnectTimeOut
|100
|
|2000
|}

The TimeOut-Attribute controls the time, within the command has to be executed by the CoPlanner server. The EntryLifeTime–Attribut defines, within which time span a connection has to be reused by the data extension.


{| {{Bausteindesign1}}
|-
| <span style="color: darkblue;">'''Important'''</span> &nbsp;During the installation you must set the TimeOut, otherwise it doesn't work. The TimeOut must be set at the BI-Studio in ''RSReportDesigner.config'' (C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies) and at the ReportServer in ''RSReportServer.config'' (C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer).
|}


 <font color="#ff0000">ConnectMaxAttempts</font><font color="#0000ff">=</font><font color="#000000">""</font>
This attribute defines the maximum number of connection attempts to the [[Technics:CoPlanner-Server|CoPlanner Server]]. The minimum value is 1.

 <font color="#0000ff"><</font><font color="#a31545">ServerCommandLog </font><font color="#ff0000">Active</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">False</font><font color="#000000">"</font> <font color="#ff0000">Path</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff"></font><font color="#000000">"</font><font color="#0000ff">/></font>
Using this option the logging of the [[Technics:CoPlanner-Server|CoPlanner Server]] commands can be activated. In this case each request to the [[Technics:CoPlanner-Server|CoPlanner Server]] and its answer will create a file with the following file name pattern:

'''Counter-Command-anfrage.xml (for requests)'''
bzw.
'''Counter-Command-ergebnis.xml (for answers answers)'''

Counter is a consecutive numbering of the commands.By default the files will be put into the report server’s bin-directory (the clCop_ClientProxy-class’ default path is the path of the binary).

 <font color="#0000ff"><</font><font color="#a31545">Kerberos </font><font color="#ff0000">SPN</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff"></font><font color="#000000">"</font><font color="#0000ff">/></font>
Defines the Service Principle Name (SPN) if Kerberos authentication must be used 

===SQL Server Reporting Services 2012===

For accessing to an CoPlanner data source with SSRS 2012 the transmission mode ''Native'' has to be activated. Therefore the connection settings have to be extended: ''server=vpcopsq2;port=8963;tcpformatter=native''

{| {{Bausteindesign1}}
|-
| <span style="color: darkblue;">'''Hint'''</span> &nbsp;The chosen mode has to be adjusted both on server (SvrConfig.xml) and on client (ClientConfig.xml) and both have to come to an agreement.
|


__NOEDITSECTION__

[[Category:Technics|Reporting Services Integration]]

[[de:Technik:Reporting Services Integration]]