Data Access Laws In the UK

Hi Everyone

This is a data base question so don't switch off thinking it is a Data
Protection Act Question.

I'm Looking for some general information regarding the UK Law on
rights to access data within a database provided by a third party
software provider.

They are preventing me from ODBC Access to their data base and say
that the only way I can access the data held in the data base is
through CSV reports that their custom app can provide.

I am building a datawarehouse and require the data to be DTS'sed to my
OLAP server on a regular basis...but theyt rae denying me access the
database is Oracle so their should really be no problems but they are
hitting me with all the usual invalidate warranty claims.

Does anyone know what UK law has to say in this matter, o0r can you
point me to a good resource.

TIA

Maria"Maria" <nottyshagger69@.yahoo.co.uk> wrote in message
news:e4ba2d0e.0405130142.352a0aee@.posting.google.c om...
> Hi Everyone
> This is a data base question so don't switch off thinking it is a Data
> Protection Act Question.
> I'm Looking for some general information regarding the UK Law on
> rights to access data within a database provided by a third party
> software provider.
> They are preventing me from ODBC Access to their data base and say
> that the only way I can access the data held in the data base is
> through CSV reports that their custom app can provide.
> I am building a datawarehouse and require the data to be DTS'sed to my
> OLAP server on a regular basis...but theyt rae denying me access the
> database is Oracle so their should really be no problems but they are
> hitting me with all the usual invalidate warranty claims.
> Does anyone know what UK law has to say in this matter, o0r can you
> point me to a good resource.
> TIA
> Maria

(from a non-legal background)

It sounds to me as though you've got a efw questions tied into one here.

--

If this is a third-party software provider, then what is your contract with
them ? Are they supplying you with the right to the data (in whatever way
that you wish), or are they supplying software to you that will allow you to
access their data.

The fact that their database server is running Oracle (or MySQL or SQL
Server) shouldn't matter - this would seem to come down to an issue of what
they have committed to providing

There is a difference between "read-only access direct to their database"
(where you can control any filters / queries ) and "access to data from
their database" (where they charge you for providing a report or
data-extract based on your request)

--

I can see nothing here that would have anything to do with a warranty --
maybe they think that by providing you access to their database, they have
lost 100% control of it, so will refuse to support it .

Just a thought

Steven|||I have recently dealt with a similar issue, and there's more than just a legal
question involved. Since the company is selling you a system based on its
external behavior, they are not committing to maintain the same internal
structure each time the product is updated.

In looking at the internal structure of one program I'm trying to get data out
of, I see that the internal structures change with some frequency over time.
Thus, the wise choice for reliably getting data out of this system is to only
use the documented interfaces to the application which the provider has
committed to maintain, and provide documentation on any changes to.

Yes, someone has to manually export the data, and yes, it's silly that I have
to re-normalize data that probably comes out of a normalized structure to
begin with, but that's still the most reliable answer. I would also talk to
your data provider about providing you some sort of ActiveX interface that
could at least be automated, and could provide the data in a more robust
format than csv (e.g. disconnected ADO recordset or XML).

On 13 May 2004 02:42:59 -0700, nottyshagger69@.yahoo.co.uk (Maria) wrote:

>Hi Everyone
>This is a data base question so don't switch off thinking it is a Data
>Protection Act Question.
>I'm Looking for some general information regarding the UK Law on
>rights to access data within a database provided by a third party
>software provider.
>They are preventing me from ODBC Access to their data base and say
>that the only way I can access the data held in the data base is
>through CSV reports that their custom app can provide.
>I am building a datawarehouse and require the data to be DTS'sed to my
>OLAP server on a regular basis...but theyt rae denying me access the
>database is Oracle so their should really be no problems but they are
>hitting me with all the usual invalidate warranty claims.
>Does anyone know what UK law has to say in this matter, o0r can you
>point me to a good resource.
>TIA
>Maria

CustomReportItem Question

Is there any documentation currently outlining how to make use of the CustomReportItem element or class? My thoughts on this are that it might act as a server control for an ASP.NET application. Is that correct?

I want to be able to add some richer user interactivity to a couple reports that I'm currently authoring (i.e. checkboxes, buttons to access web service functionality, etc...) and I think that I might be able to make use of this class to provide that functionality since RDL doesn't seem to give any support for scripting in HTML entities into the report.

Lastly, will support for installing custom report items be included in ReportServer Express?

Thanks.

Unfortunately, the CustomReportItem documentation did not make it in time for SQL 2005 release. We expect to have a white paper and sample out around the release time. It is much like an ASP.NET server control but it is specific to Reporting Services.

The CustomReportItem is also limited in it's initial version to basically returning images. While you can build things like maps, graphs, or other visualizations, the interactive controls you are talking about are not really possible.

RDL doesn't enable embedded HTML because of the inability to render to other formats along with the fact that you would have to write code behind them anyway.

CustomReportItems are not supported in the RS in SQL Server Express.|||

Two months later….

Is there now any documentation, whitepaper or example describing how to make use of the CRI?

|||For instance, Chris Hays posted a blog article including a sample recently: http://blogs.msdn.com/chrishays/archive/2005/10/04/CustomReportItemSample.aspx

RS BOL contains some limited information at this point. Stay tuned for more information becoming available in the next months.

-- Robert|||BTW: besides the scenarios described by Brian Welcker, there are also a few additional scenarios where CRI can be used in RS 2005. I will post more information about this in a few weeks.

-- Robert|||

Thank you for your quick answer. I have already seen the example of Chris.

By using of this example I can add the control to the toolbox. However there are some problems with the installation of the Runtime control (Polygons).

I have done following:

- Both controls (Design and RTC) have been signed.

- Both of them are copied in the ReportServer/Bin directory and additionally in the c$\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies.

- After this did not work, I have appended the Public-Key Membership-Condition to the rssrvpolicy.config.

- Designer control is registered in the RSReportDesigner.config.

Unfortunately, it still does not work. When I try to drag the control to the report the VS dialog appears with the following message:

“The custom report type Polygons is not installed”

The question is: How to install the control properly?

My config files look as shown bellow:

rsreportserver.config

--

. . .

<Extensions>

<ReportItems>

<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsCRI, PolygonsCRI" />

</ReportItems>

<Delivery>

. . .

rssrvpolicy.config

<CodeGroup

class="UnionCodeGroup"

version="1"

PermissionSetName="FullTrust"

Name="Polygons"

Description="This code group grants FullTrust to DAENET assemblies. ">

<IMembershipCondition

class="StrongNameMembershipCondition"

version="1" PublicKeyBlob="00240000. . .BE06C0"

/>

</CodeGroup>

RSReportDesigner.config

. . .

<Extensions>

<ReportItemDesigner>

<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsCRI, PolygonsCRI" />

</ReportItemDesigner>

<ReportItems>

<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsDesigner, PolygonsDesigner" />

</ReportItems>

<Render>

. . .

Here is the list of loaded modules of the VS. As you can see (first and last entry) both componets are loaded.

. . .

'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\PolygonsCRI.dll', Symbols loaded.

'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ProcessingCore.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.QueryDesigners.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.ManagedDTS\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.ManagedDTS.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VSDesigner\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VSDesigner.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_32\System.Data.OracleClient\2.0.0.0__b77a5c561934e089\System.Data.OracleClient.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Runtime.Serialization.Formatters.Soap\2.0.0.0__b03f5f7f11d50a3a\System.Runtime.Serialization.Formatters.Soap.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC\Microsoft.VisualStudio.VSHelp80\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.VSHelp80.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\PolygonsDesigner.dll', Symbols loaded.
. . .
Framevork Ver.: 2.0.50727.26

|||Did you make any changes to the code itself?
I get the behavior you're seeing when I omit the CustomReportItem attribute from the PolygonsDesigner class (or give it the wrong custom report item name, or have a typo in the CRI name in the designer config file).
|||Here is the Designer-code:

[LocalizedName("Polygons")]
[Editor(typeof(CustomEditor), typeof(ComponentEditor))]
[ToolboxBitmap(typeof(PolygonsDesigner),"Polygons.ico")]
[CustomReportItem("Polygons")]
public class PolygonsDesigner : CustomReportItemDesigner

PS. There ware no any changes in the original code.

|||Would a CustomReportItem be capable of providing the following functionality:

Need a Text Box/Label that can support text in multiple styles like Bold and Italic. I have heard that someone is building a RTF TextBox for Reporting Services.

Client is building a service that builds Letters and prints them for mailing. Need blocks of text with different formats in the text.|||In RS 2005, you could build a CustomReportItem that takes the RTF information and generates an image out of it.

-- Robert|||

Sorry I was to fast,

I have found the information in this thread........

Hi,

has anyone example code to build a customReportItem? Or knows anyone a tutorial that descibes this scenario?

Thanks

Stefan

|||

OK, once again,

Robert, Keith or anyone else. Do you have a code sample to integrate the rtf formated text in the report? As ReportItem

Thank you in advance

stefan

|||Now that it is March, do we have any more detailed documentation on how to build Custom Report Items?|||This is now fully documented in the SQL Server 2005 SP1 documentation and samples.|||

Btw, the latest RS BOL documentation is also available as separate download: http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en

-- Robert

CustomReportItem Question

Is there any documentation currently outlining how to make use of the CustomReportItem element or class? My thoughts on this are that it might act as a server control for an ASP.NET application. Is that correct?

I want to be able to add some richer user interactivity to a couple reports that I'm currently authoring (i.e. checkboxes, buttons to access web service functionality, etc...) and I think that I might be able to make use of this class to provide that functionality since RDL doesn't seem to give any support for scripting in HTML entities into the report.

Lastly, will support for installing custom report items be included in ReportServer Express?

Thanks.

Unfortunately, the CustomReportItem documentation did not make it in time for SQL 2005 release. We expect to have a white paper and sample out around the release time. It is much like an ASP.NET server control but it is specific to Reporting Services.

The CustomReportItem is also limited in it's initial version to basically returning images. While you can build things like maps, graphs, or other visualizations, the interactive controls you are talking about are not really possible.

RDL doesn't enable embedded HTML because of the inability to render to other formats along with the fact that you would have to write code behind them anyway.

CustomReportItems are not supported in the RS in SQL Server Express.|||

Two months later….

Is there now any documentation, whitepaper or example describing how to make use of the CRI?

|||For instance, Chris Hays posted a blog article including a sample recently: http://blogs.msdn.com/chrishays/archive/2005/10/04/CustomReportItemSample.aspx

RS BOL contains some limited information at this point. Stay tuned for more information becoming available in the next months.

-- Robert|||BTW: besides the scenarios described by Brian Welcker, there are also a few additional scenarios where CRI can be used in RS 2005. I will post more information about this in a few weeks.

-- Robert|||

Thank you for your quick answer. I have already seen the example of Chris.

By using of this example I can add the control to the toolbox. However there are some problems with the installation of the Runtime control (Polygons).

I have done following:

- Both controls (Design and RTC) have been signed.

- Both of them are copied in the ReportServer/Bin directory and additionally in the c$\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies.

- After this did not work, I have appended the Public-Key Membership-Condition to the rssrvpolicy.config.

- Designer control is registered in the RSReportDesigner.config.

Unfortunately, it still does not work. When I try to drag the control to the report the VS dialog appears with the following message:

“The custom report type Polygons is not installed”

The question is: How to install the control properly?

My config files look as shown bellow:

rsreportserver.config

--

. . .

<Extensions>

<ReportItems>

<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsCRI, PolygonsCRI" />

</ReportItems>

<Delivery>

. . .

rssrvpolicy.config

<CodeGroup

class="UnionCodeGroup"

version="1"

PermissionSetName="FullTrust"

Name="Polygons"

Description="This code group grants FullTrust to DAENET assemblies. ">

<IMembershipCondition

class="StrongNameMembershipCondition"

version="1" PublicKeyBlob="00240000. . .BE06C0"

/>

</CodeGroup>

RSReportDesigner.config

. . .

<Extensions>

<ReportItemDesigner>

<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsCRI, PolygonsCRI" />

</ReportItemDesigner>

<ReportItems>

<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsDesigner, PolygonsDesigner" />

</ReportItems>

<Render>

. . .

Here is the list of loaded modules of the VS. As you can see (first and last entry) both componets are loaded.

. . .

'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\PolygonsCRI.dll', Symbols loaded.

'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ProcessingCore.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.QueryDesigners.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.ManagedDTS\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.ManagedDTS.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VSDesigner\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VSDesigner.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_32\System.Data.OracleClient\2.0.0.0__b77a5c561934e089\System.Data.OracleClient.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Runtime.Serialization.Formatters.Soap\2.0.0.0__b03f5f7f11d50a3a\System.Runtime.Serialization.Formatters.Soap.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC\Microsoft.VisualStudio.VSHelp80\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.VSHelp80.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\PolygonsDesigner.dll', Symbols loaded.
. . .
Framevork Ver.: 2.0.50727.26

|||Did you make any changes to the code itself?
I get the behavior you're seeing when I omit the CustomReportItem attribute from the PolygonsDesigner class (or give it the wrong custom report item name, or have a typo in the CRI name in the designer config file).
|||Here is the Designer-code:

[LocalizedName("Polygons")]
[Editor(typeof(CustomEditor), typeof(ComponentEditor))]
[ToolboxBitmap(typeof(PolygonsDesigner),"Polygons.ico")]
[CustomReportItem("Polygons")]
public class PolygonsDesigner : CustomReportItemDesigner

PS. There ware no any changes in the original code.

|||Would a CustomReportItem be capable of providing the following functionality:

Need a Text Box/Label that can support text in multiple styles like Bold and Italic. I have heard that someone is building a RTF TextBox for Reporting Services.

Client is building a service that builds Letters and prints them for mailing. Need blocks of text with different formats in the text.|||In RS 2005, you could build a CustomReportItem that takes the RTF information and generates an image out of it.

-- Robert|||

Sorry I was to fast,

I have found the information in this thread........

Hi,

has anyone example code to build a customReportItem? Or knows anyone a tutorial that descibes this scenario?

Thanks

Stefan

|||

OK, once again,

Robert, Keith or anyone else. Do you have a code sample to integrate the rtf formated text in the report? As ReportItem

Thank you in advance

stefan

|||Now that it is March, do we have any more detailed documentation on how to build Custom Report Items?|||This is now fully documented in the SQL Server 2005 SP1 documentation and samples.|||

Btw, the latest RS BOL documentation is also available as separate download: http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en

-- Robert

CustomReportItem Question

Is there any documentation currently outlining how to make use of the CustomReportItem element or class? My thoughts on this are that it might act as a server control for an ASP.NET application. Is that correct?

I want to be able to add some richer user interactivity to a couple reports that I'm currently authoring (i.e. checkboxes, buttons to access web service functionality, etc...) and I think that I might be able to make use of this class to provide that functionality since RDL doesn't seem to give any support for scripting in HTML entities into the report.

Lastly, will support for installing custom report items be included in ReportServer Express?

Thanks.

Unfortunately, the CustomReportItem documentation did not make it in time for SQL 2005 release. We expect to have a white paper and sample out around the release time. It is much like an ASP.NET server control but it is specific to Reporting Services.

The CustomReportItem is also limited in it's initial version to basically returning images. While you can build things like maps, graphs, or other visualizations, the interactive controls you are talking about are not really possible.

RDL doesn't enable embedded HTML because of the inability to render to other formats along with the fact that you would have to write code behind them anyway.

CustomReportItems are not supported in the RS in SQL Server Express.|||

Two months later….

Is there now any documentation, whitepaper or example describing how to make use of the CRI?

|||For instance, Chris Hays posted a blog article including a sample recently: http://blogs.msdn.com/chrishays/archive/2005/10/04/CustomReportItemSample.aspx

RS BOL contains some limited information at this point. Stay tuned for more information becoming available in the next months.

-- Robert|||BTW: besides the scenarios described by Brian Welcker, there are also a few additional scenarios where CRI can be used in RS 2005. I will post more information about this in a few weeks.

-- Robert|||

Thank you for your quick answer. I have already seen the example of Chris.

By using of this example I can add the control to the toolbox. However there are some problems with the installation of the Runtime control (Polygons).

I have done following:

- Both controls (Design and RTC) have been signed.

- Both of them are copied in the ReportServer/Bin directory and additionally in the c$\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies.

- After this did not work, I have appended the Public-Key Membership-Condition to the rssrvpolicy.config.

- Designer control is registered in the RSReportDesigner.config.

Unfortunately, it still does not work. When I try to drag the control to the report the VS dialog appears with the following message:

“The custom report type Polygons is not installed”

The question is: How to install the control properly?

My config files look as shown bellow:

rsreportserver.config

--

. . .

<Extensions>

<ReportItems>

<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsCRI, PolygonsCRI" />

</ReportItems>

<Delivery>

. . .

rssrvpolicy.config

<CodeGroup

class="UnionCodeGroup"

version="1"

PermissionSetName="FullTrust"

Name="Polygons"

Description="This code group grants FullTrust to DAENET assemblies. ">

<IMembershipCondition

class="StrongNameMembershipCondition"

version="1" PublicKeyBlob="00240000. . .BE06C0"

/>

</CodeGroup>

RSReportDesigner.config

. . .

<Extensions>

<ReportItemDesigner>

<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsCRI, PolygonsCRI" />

</ReportItemDesigner>

<ReportItems>

<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsDesigner, PolygonsDesigner" />

</ReportItems>

<Render>

. . .

Here is the list of loaded modules of the VS. As you can see (first and last entry) both componets are loaded.

. . .

'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\PolygonsCRI.dll', Symbols loaded.

'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ProcessingCore.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.QueryDesigners.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.ManagedDTS\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.ManagedDTS.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VSDesigner\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VSDesigner.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_32\System.Data.OracleClient\2.0.0.0__b77a5c561934e089\System.Data.OracleClient.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Runtime.Serialization.Formatters.Soap\2.0.0.0__b03f5f7f11d50a3a\System.Runtime.Serialization.Formatters.Soap.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC\Microsoft.VisualStudio.VSHelp80\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.VSHelp80.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\PolygonsDesigner.dll', Symbols loaded.
. . .
Framevork Ver.: 2.0.50727.26

|||Did you make any changes to the code itself?
I get the behavior you're seeing when I omit the CustomReportItem attribute from the PolygonsDesigner class (or give it the wrong custom report item name, or have a typo in the CRI name in the designer config file).
|||Here is the Designer-code:

[LocalizedName("Polygons")]
[Editor(typeof(CustomEditor), typeof(ComponentEditor))]
[ToolboxBitmap(typeof(PolygonsDesigner),"Polygons.ico")]
[CustomReportItem("Polygons")]
public class PolygonsDesigner : CustomReportItemDesigner

PS. There ware no any changes in the original code.

|||Would a CustomReportItem be capable of providing the following functionality:

Need a Text Box/Label that can support text in multiple styles like Bold and Italic. I have heard that someone is building a RTF TextBox for Reporting Services.

Client is building a service that builds Letters and prints them for mailing. Need blocks of text with different formats in the text.|||In RS 2005, you could build a CustomReportItem that takes the RTF information and generates an image out of it.

-- Robert|||

Sorry I was to fast,

I have found the information in this thread........

Hi,

has anyone example code to build a customReportItem? Or knows anyone a tutorial that descibes this scenario?

Thanks

Stefan

|||

OK, once again,

Robert, Keith or anyone else. Do you have a code sample to integrate the rtf formated text in the report? As ReportItem

Thank you in advance

stefan

|||Now that it is March, do we have any more detailed documentation on how to build Custom Report Items?|||This is now fully documented in the SQL Server 2005 SP1 documentation and samples.|||

Btw, the latest RS BOL documentation is also available as separate download: http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en

-- Robert

CustomReportItem Question

Is there any documentation currently outlining how to make use of the CustomReportItem element or class? My thoughts on this are that it might act as a server control for an ASP.NET application. Is that correct?

I want to be able to add some richer user interactivity to a couple reports that I'm currently authoring (i.e. checkboxes, buttons to access web service functionality, etc...) and I think that I might be able to make use of this class to provide that functionality since RDL doesn't seem to give any support for scripting in HTML entities into the report.

Lastly, will support for installing custom report items be included in ReportServer Express?

Thanks.

Unfortunately, the CustomReportItem documentation did not make it in time for SQL 2005 release. We expect to have a white paper and sample out around the release time. It is much like an ASP.NET server control but it is specific to Reporting Services.

The CustomReportItem is also limited in it's initial version to basically returning images. While you can build things like maps, graphs, or other visualizations, the interactive controls you are talking about are not really possible.

RDL doesn't enable embedded HTML because of the inability to render to other formats along with the fact that you would have to write code behind them anyway.

CustomReportItems are not supported in the RS in SQL Server Express.|||

Two months later….

Is there now any documentation, whitepaper or example describing how to make use of the CRI?

|||For instance, Chris Hays posted a blog article including a sample recently: http://blogs.msdn.com/chrishays/archive/2005/10/04/CustomReportItemSample.aspx

RS BOL contains some limited information at this point. Stay tuned for more information becoming available in the next months.

-- Robert|||BTW: besides the scenarios described by Brian Welcker, there are also a few additional scenarios where CRI can be used in RS 2005. I will post more information about this in a few weeks.

-- Robert|||

Thank you for your quick answer. I have already seen the example of Chris.

By using of this example I can add the control to the toolbox. However there are some problems with the installation of the Runtime control (Polygons).

I have done following:

- Both controls (Design and RTC) have been signed.

- Both of them are copied in the ReportServer/Bin directory and additionally in the c$\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies.

- After this did not work, I have appended the Public-Key Membership-Condition to the rssrvpolicy.config.

- Designer control is registered in the RSReportDesigner.config.

Unfortunately, it still does not work. When I try to drag the control to the report the VS dialog appears with the following message:

“The custom report type Polygons is not installed”

The question is: How to install the control properly?

My config files look as shown bellow:

rsreportserver.config

--

. . .

<Extensions>

<ReportItems>

<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsCRI, PolygonsCRI" />

</ReportItems>

<Delivery>

. . .

rssrvpolicy.config

<CodeGroup

class="UnionCodeGroup"

version="1"

PermissionSetName="FullTrust"

Name="Polygons"

Description="This code group grants FullTrust to DAENET assemblies. ">

<IMembershipCondition

class="StrongNameMembershipCondition"

version="1" PublicKeyBlob="00240000. . .BE06C0"

/>

</CodeGroup>

RSReportDesigner.config

. . .

<Extensions>

<ReportItemDesigner>

<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsCRI, PolygonsCRI" />

</ReportItemDesigner>

<ReportItems>

<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsDesigner, PolygonsDesigner" />

</ReportItems>

<Render>

. . .

Here is the list of loaded modules of the VS. As you can see (first and last entry) both componets are loaded.

. . .

'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\PolygonsCRI.dll', Symbols loaded.

'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ProcessingCore.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.QueryDesigners.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.ManagedDTS\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.ManagedDTS.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VSDesigner\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VSDesigner.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_32\System.Data.OracleClient\2.0.0.0__b77a5c561934e089\System.Data.OracleClient.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Runtime.Serialization.Formatters.Soap\2.0.0.0__b03f5f7f11d50a3a\System.Runtime.Serialization.Formatters.Soap.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC\Microsoft.VisualStudio.VSHelp80\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.VSHelp80.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\PolygonsDesigner.dll', Symbols loaded.
. . .
Framevork Ver.: 2.0.50727.26

|||Did you make any changes to the code itself?
I get the behavior you're seeing when I omit the CustomReportItem attribute from the PolygonsDesigner class (or give it the wrong custom report item name, or have a typo in the CRI name in the designer config file).
|||Here is the Designer-code:

[LocalizedName("Polygons")]
[Editor(typeof(CustomEditor), typeof(ComponentEditor))]
[ToolboxBitmap(typeof(PolygonsDesigner),"Polygons.ico")]
[CustomReportItem("Polygons")]
public class PolygonsDesigner : CustomReportItemDesigner

PS. There ware no any changes in the original code.

|||Would a CustomReportItem be capable of providing the following functionality:

Need a Text Box/Label that can support text in multiple styles like Bold and Italic. I have heard that someone is building a RTF TextBox for Reporting Services.

Client is building a service that builds Letters and prints them for mailing. Need blocks of text with different formats in the text.|||In RS 2005, you could build a CustomReportItem that takes the RTF information and generates an image out of it.

-- Robert|||

Sorry I was to fast,

I have found the information in this thread........

Hi,

has anyone example code to build a customReportItem? Or knows anyone a tutorial that descibes this scenario?

Thanks

Stefan

|||

OK, once again,

Robert, Keith or anyone else. Do you have a code sample to integrate the rtf formated text in the report? As ReportItem

Thank you in advance

stefan

|||Now that it is March, do we have any more detailed documentation on how to build Custom Report Items?|||This is now fully documented in the SQL Server 2005 SP1 documentation and samples.|||

Btw, the latest RS BOL documentation is also available as separate download: http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en

-- Robert

CustomReportItem Installation

Is there any documentation currently outlining how to make use of the CustomReportItem element or class? My thoughts on this are that it might act as a server control for an ASP.NET application. Is that correct?

I want to be able to add some richer user interactivity to a couple reports that I'm currently authoring (i.e. checkboxes, buttons to access web service functionality, etc...) and I think that I might be able to make use of this class to provide that functionality since RDL doesn't seem to give any support for scripting in HTML entities into the report.

Lastly, will support for installing custom report items be included in ReportServer Express?

Thanks.

Unfortunately, the CustomReportItem documentation did not make it in time for SQL 2005 release. We expect to have a white paper and sample out around the release time. It is much like an ASP.NET server control but it is specific to Reporting Services.

The CustomReportItem is also limited in it's initial version to basically returning images. While you can build things like maps, graphs, or other visualizations, the interactive controls you are talking about are not really possible.

RDL doesn't enable embedded HTML because of the inability to render to other formats along with the fact that you would have to write code behind them anyway.

CustomReportItems are not supported in the RS in SQL Server Express.|||

Two months later….

Is there now any documentation, whitepaper or example describing how to make use of the CRI?

|||For instance, Chris Hays posted a blog article including a sample recently: http://blogs.msdn.com/chrishays/archive/2005/10/04/CustomReportItemSample.aspx

RS BOL contains some limited information at this point. Stay tuned for more information becoming available in the next months.

-- Robert|||BTW: besides the scenarios described by Brian Welcker, there are also a few additional scenarios where CRI can be used in RS 2005. I will post more information about this in a few weeks.

-- Robert|||

Thank you for your quick answer. I have already seen the example of Chris.

By using of this example I can add the control to the toolbox. However there are some problems with the installation of the Runtime control (Polygons).

I have done following:

- Both controls (Design and RTC) have been signed.

- Both of them are copied in the ReportServer/Bin directory and additionally in the c$\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies.

- After this did not work, I have appended the Public-Key Membership-Condition to the rssrvpolicy.config.

- Designer control is registered in the RSReportDesigner.config.

Unfortunately, it still does not work. When I try to drag the control to the report the VS dialog appears with the following message:

“The custom report type Polygons is not installed”

The question is: How to install the control properly?

My config files look as shown bellow:

rsreportserver.config

--

. . .

<Extensions>

<ReportItems>

<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsCRI, PolygonsCRI" />

</ReportItems>

<Delivery>

. . .

rssrvpolicy.config

<CodeGroup

class="UnionCodeGroup"

version="1"

PermissionSetName="FullTrust"

Name="Polygons"

Description="This code group grants FullTrust to DAENET assemblies. ">

<IMembershipCondition

class="StrongNameMembershipCondition"

version="1" PublicKeyBlob="00240000. . .BE06C0"

/>

</CodeGroup>

RSReportDesigner.config

. . .

<Extensions>

<ReportItemDesigner>

<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsCRI, PolygonsCRI" />

</ReportItemDesigner>

<ReportItems>

<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsDesigner, PolygonsDesigner" />

</ReportItems>

<Render>

. . .

Here is the list of loaded modules of the VS. As you can see (first and last entry) both componets are loaded.

. . .

'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\PolygonsCRI.dll', Symbols loaded.

'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ProcessingCore.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.QueryDesigners.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.ManagedDTS\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.ManagedDTS.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VSDesigner\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VSDesigner.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_32\System.Data.OracleClient\2.0.0.0__b77a5c561934e089\System.Data.OracleClient.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Runtime.Serialization.Formatters.Soap\2.0.0.0__b03f5f7f11d50a3a\System.Runtime.Serialization.Formatters.Soap.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC\Microsoft.VisualStudio.VSHelp80\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.VSHelp80.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\PolygonsDesigner.dll', Symbols loaded.
. . .
Framevork Ver.: 2.0.50727.26

|||Did you make any changes to the code itself?
I get the behavior you're seeing when I omit the CustomReportItem attribute from the PolygonsDesigner class (or give it the wrong custom report item name, or have a typo in the CRI name in the designer config file).
|||Here is the Designer-code:

[LocalizedName("Polygons")]
[Editor(typeof(CustomEditor), typeof(ComponentEditor))]
[ToolboxBitmap(typeof(PolygonsDesigner),"Polygons.ico")]
[CustomReportItem("Polygons")]
public class PolygonsDesigner : CustomReportItemDesigner

PS. There ware no any changes in the original code.

|||Would a CustomReportItem be capable of providing the following functionality:

Need a Text Box/Label that can support text in multiple styles like Bold and Italic. I have heard that someone is building a RTF TextBox for Reporting Services.

Client is building a service that builds Letters and prints them for mailing. Need blocks of text with different formats in the text.|||In RS 2005, you could build a CustomReportItem that takes the RTF information and generates an image out of it.

-- Robert|||

Sorry I was to fast,

I have found the information in this thread........

Hi,

has anyone example code to build a customReportItem? Or knows anyone a tutorial that descibes this scenario?

Thanks

Stefan

|||

OK, once again,

Robert, Keith or anyone else. Do you have a code sample to integrate the rtf formated text in the report? As ReportItem

Thank you in advance

stefan

|||Now that it is March, do we have any more detailed documentation on how to build Custom Report Items?|||This is now fully documented in the SQL Server 2005 SP1 documentation and samples.|||

Btw, the latest RS BOL documentation is also available as separate download: http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en

-- Robert

CustomReportItem Installation

Is there any documentation currently outlining how to make use of the CustomReportItem element or class? My thoughts on this are that it might act as a server control for an ASP.NET application. Is that correct?

I want to be able to add some richer user interactivity to a couple reports that I'm currently authoring (i.e. checkboxes, buttons to access web service functionality, etc...) and I think that I might be able to make use of this class to provide that functionality since RDL doesn't seem to give any support for scripting in HTML entities into the report.

Lastly, will support for installing custom report items be included in ReportServer Express?

Thanks.

Unfortunately, the CustomReportItem documentation did not make it in time for SQL 2005 release. We expect to have a white paper and sample out around the release time. It is much like an ASP.NET server control but it is specific to Reporting Services.

The CustomReportItem is also limited in it's initial version to basically returning images. While you can build things like maps, graphs, or other visualizations, the interactive controls you are talking about are not really possible.

RDL doesn't enable embedded HTML because of the inability to render to other formats along with the fact that you would have to write code behind them anyway.

CustomReportItems are not supported in the RS in SQL Server Express.|||

Two months later….

Is there now any documentation, whitepaper or example describing how to make use of the CRI?

|||For instance, Chris Hays posted a blog article including a sample recently: http://blogs.msdn.com/chrishays/archive/2005/10/04/CustomReportItemSample.aspx

RS BOL contains some limited information at this point. Stay tuned for more information becoming available in the next months.

-- Robert|||BTW: besides the scenarios described by Brian Welcker, there are also a few additional scenarios where CRI can be used in RS 2005. I will post more information about this in a few weeks.

-- Robert|||

Thank you for your quick answer. I have already seen the example of Chris.

By using of this example I can add the control to the toolbox. However there are some problems with the installation of the Runtime control (Polygons).

I have done following:

- Both controls (Design and RTC) have been signed.

- Both of them are copied in the ReportServer/Bin directory and additionally in the c$\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies.

- After this did not work, I have appended the Public-Key Membership-Condition to the rssrvpolicy.config.

- Designer control is registered in the RSReportDesigner.config.

Unfortunately, it still does not work. When I try to drag the control to the report the VS dialog appears with the following message:

“The custom report type Polygons is not installed”

The question is: How to install the control properly?

My config files look as shown bellow:

rsreportserver.config

--

. . .

<Extensions>

<ReportItems>

<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsCRI, PolygonsCRI" />

</ReportItems>

<Delivery>

. . .

rssrvpolicy.config

<CodeGroup

class="UnionCodeGroup"

version="1"

PermissionSetName="FullTrust"

Name="Polygons"

Description="This code group grants FullTrust to DAENET assemblies. ">

<IMembershipCondition

class="StrongNameMembershipCondition"

version="1" PublicKeyBlob="00240000. . .BE06C0"

/>

</CodeGroup>

RSReportDesigner.config

. . .

<Extensions>

<ReportItemDesigner>

<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsCRI, PolygonsCRI" />

</ReportItemDesigner>

<ReportItems>

<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsDesigner, PolygonsDesigner" />

</ReportItems>

<Render>

. . .

Here is the list of loaded modules of the VS. As you can see (first and last entry) both componets are loaded.

. . .

'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\PolygonsCRI.dll', Symbols loaded.

'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ProcessingCore.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.QueryDesigners.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.ManagedDTS\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.ManagedDTS.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VSDesigner\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VSDesigner.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_32\System.Data.OracleClient\2.0.0.0__b77a5c561934e089\System.Data.OracleClient.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Runtime.Serialization.Formatters.Soap\2.0.0.0__b03f5f7f11d50a3a\System.Runtime.Serialization.Formatters.Soap.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC\Microsoft.VisualStudio.VSHelp80\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.VSHelp80.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\PolygonsDesigner.dll', Symbols loaded.
. . .
Framevork Ver.: 2.0.50727.26

|||Did you make any changes to the code itself?
I get the behavior you're seeing when I omit the CustomReportItem attribute from the PolygonsDesigner class (or give it the wrong custom report item name, or have a typo in the CRI name in the designer config file).
|||Here is the Designer-code:

[LocalizedName("Polygons")]
[Editor(typeof(CustomEditor), typeof(ComponentEditor))]
[ToolboxBitmap(typeof(PolygonsDesigner),"Polygons.ico")]
[CustomReportItem("Polygons")]
public class PolygonsDesigner : CustomReportItemDesigner

PS. There ware no any changes in the original code.

|||Would a CustomReportItem be capable of providing the following functionality:

Need a Text Box/Label that can support text in multiple styles like Bold and Italic. I have heard that someone is building a RTF TextBox for Reporting Services.

Client is building a service that builds Letters and prints them for mailing. Need blocks of text with different formats in the text.|||In RS 2005, you could build a CustomReportItem that takes the RTF information and generates an image out of it.

-- Robert|||

Sorry I was to fast,

I have found the information in this thread........

Hi,

has anyone example code to build a customReportItem? Or knows anyone a tutorial that descibes this scenario?

Thanks

Stefan

|||

OK, once again,

Robert, Keith or anyone else. Do you have a code sample to integrate the rtf formated text in the report? As ReportItem

Thank you in advance

stefan

|||Now that it is March, do we have any more detailed documentation on how to build Custom Report Items?|||This is now fully documented in the SQL Server 2005 SP1 documentation and samples.|||

Btw, the latest RS BOL documentation is also available as separate download: http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en

-- Robert

CustomReportItem Installation

Is there any documentation currently outlining how to make use of the CustomReportItem element or class? My thoughts on this are that it might act as a server control for an ASP.NET application. Is that correct?

I want to be able to add some richer user interactivity to a couple reports that I'm currently authoring (i.e. checkboxes, buttons to access web service functionality, etc...) and I think that I might be able to make use of this class to provide that functionality since RDL doesn't seem to give any support for scripting in HTML entities into the report.

Lastly, will support for installing custom report items be included in ReportServer Express?

Thanks.

Unfortunately, the CustomReportItem documentation did not make it in time for SQL 2005 release. We expect to have a white paper and sample out around the release time. It is much like an ASP.NET server control but it is specific to Reporting Services.

The CustomReportItem is also limited in it's initial version to basically returning images. While you can build things like maps, graphs, or other visualizations, the interactive controls you are talking about are not really possible.

RDL doesn't enable embedded HTML because of the inability to render to other formats along with the fact that you would have to write code behind them anyway.

CustomReportItems are not supported in the RS in SQL Server Express.|||

Two months later….

Is there now any documentation, whitepaper or example describing how to make use of the CRI?

|||For instance, Chris Hays posted a blog article including a sample recently: http://blogs.msdn.com/chrishays/archive/2005/10/04/CustomReportItemSample.aspx

RS BOL contains some limited information at this point. Stay tuned for more information becoming available in the next months.

-- Robert|||BTW: besides the scenarios described by Brian Welcker, there are also a few additional scenarios where CRI can be used in RS 2005. I will post more information about this in a few weeks.

-- Robert|||

Thank you for your quick answer. I have already seen the example of Chris.

By using of this example I can add the control to the toolbox. However there are some problems with the installation of the Runtime control (Polygons).

I have done following:

- Both controls (Design and RTC) have been signed.

- Both of them are copied in the ReportServer/Bin directory and additionally in the c$\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies.

- After this did not work, I have appended the Public-Key Membership-Condition to the rssrvpolicy.config.

- Designer control is registered in the RSReportDesigner.config.

Unfortunately, it still does not work. When I try to drag the control to the report the VS dialog appears with the following message:

“The custom report type Polygons is not installed”

The question is: How to install the control properly?

My config files look as shown bellow:

rsreportserver.config

--

. . .

<Extensions>

<ReportItems>

<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsCRI, PolygonsCRI" />

</ReportItems>

<Delivery>

. . .

rssrvpolicy.config

<CodeGroup

class="UnionCodeGroup"

version="1"

PermissionSetName="FullTrust"

Name="Polygons"

Description="This code group grants FullTrust to DAENET assemblies. ">

<IMembershipCondition

class="StrongNameMembershipCondition"

version="1" PublicKeyBlob="00240000. . .BE06C0"

/>

</CodeGroup>

RSReportDesigner.config

. . .

<Extensions>

<ReportItemDesigner>

<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsCRI, PolygonsCRI" />

</ReportItemDesigner>

<ReportItems>

<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsDesigner, PolygonsDesigner" />

</ReportItems>

<Render>

. . .

Here is the list of loaded modules of the VS. As you can see (first and last entry) both componets are loaded.

. . .

'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\PolygonsCRI.dll', Symbols loaded.

'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ProcessingCore.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.QueryDesigners.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.ManagedDTS\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.ManagedDTS.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VSDesigner\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VSDesigner.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_32\System.Data.OracleClient\2.0.0.0__b77a5c561934e089\System.Data.OracleClient.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Runtime.Serialization.Formatters.Soap\2.0.0.0__b03f5f7f11d50a3a\System.Runtime.Serialization.Formatters.Soap.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC\Microsoft.VisualStudio.VSHelp80\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.VSHelp80.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\PolygonsDesigner.dll', Symbols loaded.
. . .
Framevork Ver.: 2.0.50727.26

|||Did you make any changes to the code itself?
I get the behavior you're seeing when I omit the CustomReportItem attribute from the PolygonsDesigner class (or give it the wrong custom report item name, or have a typo in the CRI name in the designer config file).
|||Here is the Designer-code:

[LocalizedName("Polygons")]
[Editor(typeof(CustomEditor), typeof(ComponentEditor))]
[ToolboxBitmap(typeof(PolygonsDesigner),"Polygons.ico")]
[CustomReportItem("Polygons")]
public class PolygonsDesigner : CustomReportItemDesigner

PS. There ware no any changes in the original code.

|||Would a CustomReportItem be capable of providing the following functionality:

Need a Text Box/Label that can support text in multiple styles like Bold and Italic. I have heard that someone is building a RTF TextBox for Reporting Services.

Client is building a service that builds Letters and prints them for mailing. Need blocks of text with different formats in the text.|||In RS 2005, you could build a CustomReportItem that takes the RTF information and generates an image out of it.

-- Robert|||

Sorry I was to fast,

I have found the information in this thread........

Hi,

has anyone example code to build a customReportItem? Or knows anyone a tutorial that descibes this scenario?

Thanks

Stefan

|||

OK, once again,

Robert, Keith or anyone else. Do you have a code sample to integrate the rtf formated text in the report? As ReportItem

Thank you in advance

stefan

|||Now that it is March, do we have any more detailed documentation on how to build Custom Report Items?|||This is now fully documented in the SQL Server 2005 SP1 documentation and samples.|||

Btw, the latest RS BOL documentation is also available as separate download: http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en

-- Robert