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.

Answer this question

CustomReportItem Question

oaktree444
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
antonioa
Thank you for your quick answer. I have already seen the example of Chris.< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

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
BabuKP
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.
Gene W
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
DianaChia
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
Matt Lalonde
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
JWelton
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.
Spigot
In RS 2005, you could build a CustomReportItem that takes the RTF information and generates an image out of it.

-- Robert
EmilG

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
LiamD
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.
YuvvY
Now that it is March, do we have any more detailed documentation on how to build Custom Report Items
Boris Todorovic
This is now fully documented in the SQL Server 2005 SP1 documentation and samples.
VarunSuri
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).
Phil James Skyline Technologies
Two months later….< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

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

Answer this question