problem TeeChart v3 with Reporting Services 2005

[ait]

Hi,

I created a Report Server project, and I added one report in my project.
I want to customize my report with the TeeChart control.

So, in the visual studio toolbox, I added the teeChart Control:
_right clik-> "Choose Items"
_I selected all items with the Assembly Name: TeeChart.ReportingServices (3.2.2722.29258)

The TeeChart control appear in the toolbox, and when I want to add this control in my report (with drag-and-drop), this message shows:

"The custom report item type TeeChart is not installed."

My TeeChart is installed and I don't understand this problem.
My System:
_TeeChart Dev Pro V3
_Microsoft SQL Server Reporting Services Designers
Version 9.00.3042.00
_Microsoft Visual Studio 2005
Version 8.0.50727.42

Thanks in advance.
Best Regards

[Narcís]

Hi ait,

Could you please try following the instructions at Readme_TeeChartReportingServices.htm, available at C:\Program Files\Steema Software\TeeChart for .NET v3 (Default English installation path) and this article?

Thanks in advance.

[ait]

Hi Narcis,

Thanks for your answer.

I followed the instructions in the file :
"C:\Program Files\Steema Software\TeeChart for .NET v3\Readme_TeeChartReportingServices.htm"
and I deployed the TeeChartReport project ("C:\Program Files\Steema Software\TeeChart for .NET v3\Examples\TeeChartReport").
The deployment succeeded.
But at the "Running the Sample" step in the Readme_TeeChartReportingServices.htm file, there are errors.

Indeed, when I add TeeChartDesigner to the Visual Studio toolbox, the following error shows:
"There was an error loading types from assembly 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies folder and select TeeChart.ReportingServices.Designer.dll'
Could not load file or assembly 'TeeChart.ReportingServices, Version=3.2.2722.29258, Culture=neutral, PublicKeyToken=XXXXXXXXXX' or one of its dependencies. The system cannot find the file specified. "

And when I run the sample (clicking preview tab or in my internet browser), this following error shows:
"An error has occurred during processing of the CustomReportItem « teeChart1 » with the « TeeChart » extension. (rsCRIProcessingError)
Could not load file or assembly 'TeeChart.ReportingServices, Version=3.2.2722.29258, Culture=neutral, PublicKeyToken=XXXXXXXXX' or one of its dependencies. The system cannot find the file specified. "

When I want to edit the TeeChart.rdl report of TeeChartReport project, I see a red rectangle with a red center cross which represent the TeeChart control. Is it normal ?
I have the SQL Server 2005 SP2 with Reporting Services Version 9.00.3042.00, there are incompatibilities ?

Thanks in advance for your support.

[Christopher]

Hello,

When I want to edit the TeeChart.rdl report of TeeChartReport project, I see a red rectangle with a red center cross which represent the TeeChart control. Is it normal ?
I have the SQL Server 2005 SP2 with Reporting Services Version 9.00.3042.00, there are incompatibilities ?

I am sorry to say that there is a problem with the TeeChart ReportingServices in the build you are using; an additional compile directive crept into that build which has upset its functionality. This problem will be rectified in the maintenance release which will be made public this week. Thank you for reporting this issue to us!

[ait]

Hi,

I downloaded the new version of TeeChart V3, released 11th july 2007 (v. 3.2.2746.19160) and this version don't correct my problem.
I didn't see in the release notes of this new version, the correction of this bug.

So, I have the same symptom, and this is a real problem for my work...

Somebody encountered this problem ? How I can resolve it ?

Thanks for your help and your support
Best regards

[Christopher]

Hello,

In the penultimate release the TeeChart.ReportingServices.dll was incorrectly compiled as an evaluation version and as such was looking for a registry key that didn't exist on the machine. In the current release, the TeeChart.ReportingServices.dll is compiled with the (correct) licensing classes, meaning that it will only run on a machine with the public keys installed (installed by default by the TeeChart installer). As this change did not require a change to the TeeChart source, it wasn't added the release notes.

So, first check that the license is installed correctly. On the customer download page for TeeChart.NET v3 there is a small registration utility to download which will enable you to do this.

Secondly, make sure you have followed all the steps outlined in the Readme_TeeChartReportingServices.htm. All these steps have to be followed even if you're only working within the Visual Studio IDE.

[ait]

Hi,
Firstly, we want to thank you for your support Christopher.

So, We had follow the Readme_TeeChartReportingServices.htm and the problem persisted :

There was an error loading types from assembly 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies folder and select TeeChart.ReportingServices.Designer.dll'
Could not load file or assembly 'TeeChart.ReportingServices, Version=3.2.2722.29258, Culture=neutral, PublicKeyToken=XXXXXXXXXX' or one of its dependencies. The system cannot find the file specified.

We had resolved this problem by adding the TeeChart.ReportingServices.dll in the same folder :"'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies"

Remark: This manipulation is not specified in the Readme_TeeChartReportingServices.htm file, but now the previous error disappears !?

Now, we can :
_add the TeeChart Component in the VS toolbox
_add TeeChart Component in a report and edit his properties
_preview my report in the "Preview" tab

But we have two others problem :

1/ The deployment of our report has succeeded, and our report is in the reportserver. But when we want to show our report (in the reports WebSite for example), this error is provided :

An error has occurred during processing of the CustomReportItem « teeChart1 » with the « TeeChart » extension
Attempt to access the method failed.

We think this error proceed from our configuration, and particularly of our rssrvpolicy.config file.
Indeed, in the Readme_TeeChartReportingServices.htm file, you recommend to add the following lines :

Code: Select all

<CodeGroup 
           class="UnionCodeGroup" 
           version="1" 
           PermissionSetName="FullTrust"
           Description="This code group grants TeeChart.ReportingServices.CRI.dll FullTrust permission. ">
       <IMembershipCondition 
           class="UrlMembershipCondition"
           version="1"
           Url="C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\TeeChart.ReportingServices.CRI.dll" />
</CodeGroup>

in the rssrvpolicy.config but you don't specify where ? (exactly)
This file (rssrvpolicy.config) has a specific pattern and that is not so easy to add code at the good place.
Could you tell us more about that ?

2/ We want to add several Series (at least two) in the same report.
We have tried and we have had some problems with DataSets etc... :
"The definition of the report '/TeeChart' is invalid.
More Than one date set, data region, or grouping in the report has the name 'teeChart1_X'. Data set, data region, and grouping names must be unique within a report."

Is It possible to have several Series in the same report ?
Whether yes, can you send us an example of a Report Project highlighting this behaviour...

Thanks in advance...
Best Regards

[Christopher]

Hello,

Remark: This manipulation is not specified in the Readme_TeeChartReportingServices.htm file, but now the previous error disappears !?

You're right, I've now updated the htm file to reflect this.

An error has occurred during processing of the CustomReportItem « teeChart1 » with the « TeeChart » extension
Attempt to access the method failed.

Ok, I've got this to work on localhost by doing the following:
1. copy TeeChart.ReportingServices.CRI.dll to:
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin (should already be there)
2. copy TeeChart.ReportingServices.dll to:
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin
3. copy C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.Designer.dll
to:
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin

this last step is necessary because TeeChart.ReportingServices.dll depends on Microsoft.ReportingServices.Designer.dll. Now add the code groups to rssrvpolicy.config; mine now looks like this:

Code: Select all

<configuration>
    <mscorlib>
        <security>
            <policy>
                <PolicyLevel version="1">
                    <SecurityClasses>
                        <SecurityClass Name="AllMembershipCondition" Description="System.Security.Policy.AllMembershipCondition, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="AspNetHostingPermission" Description="System.Web.AspNetHostingPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="DnsPermission" Description="System.Net.DnsPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="EnvironmentPermission" Description="System.Security.Permissions.EnvironmentPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="FileIOPermission" Description="System.Security.Permissions.FileIOPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="FirstMatchCodeGroup" Description="System.Security.Policy.FirstMatchCodeGroup, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="IsolatedStorageFilePermission" Description="System.Security.Permissions.IsolatedStorageFilePermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="NamedPermissionSet" Description="System.Security.NamedPermissionSet"/>
                        <SecurityClass Name="PrintingPermission" Description="System.Drawing.Printing.PrintingPermission, System.Drawing, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
                        <SecurityClass Name="ReflectionPermission" Description="System.Security.Permissions.ReflectionPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="RegistryPermission" Description="System.Security.Permissions.RegistryPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="SecurityPermission" Description="System.Security.Permissions.SecurityPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="SocketPermission" Description="System.Net.SocketPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="SqlClientPermission" Description="System.Data.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="StrongNameMembershipCondition" Description="System.Security.Policy.StrongNameMembershipCondition, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="UnionCodeGroup" Description="System.Security.Policy.UnionCodeGroup, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="UrlMembershipCondition" Description="System.Security.Policy.UrlMembershipCondition, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="WebPermission" Description="System.Net.WebPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="ZoneMembershipCondition" Description="System.Security.Policy.ZoneMembershipCondition, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                    </SecurityClasses>
                    <NamedPermissionSets>
                        <PermissionSet
                                class="NamedPermissionSet"
                                version="1"
                                Unrestricted="true"
                                Name="FullTrust"
                                Description="Allows full access to all resources"
                        />
                        <PermissionSet
                                class="NamedPermissionSet"
                                version="1"
                                Name="Nothing"
                                Description="Denies all resources, including the right to execute"
                        />
                        <PermissionSet
                                class="NamedPermissionSet"
                                version="1"
                                Name="Execution">
                            <IPermission 
                                    class="SecurityPermission"
                                    version="1"
                                    Flags="Execution"
                            />
                        </PermissionSet>
                    </NamedPermissionSets>
                    <CodeGroup 
                            class="FirstMatchCodeGroup"
                            version="1"
                            PermissionSetName="Nothing">
                        <IMembershipCondition 
                                class="AllMembershipCondition"
                                version="1"
                        />
                        <CodeGroup
                                class="UnionCodeGroup"
                                version="1"
                                PermissionSetName="Execution"
                                Name="Report_Expressions_Default_Permissions"
                                Description="This code group grants default permissions for code in report expressions and Code element. ">
                            <IMembershipCondition
                                    class="StrongNameMembershipCondition"
                                    version="1"
                                    PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100512C8E872E28569E733BCB123794DAB55111A0570B3B3D4DE3794153DEA5EFB7C3FEA9F2D8236CFF320C4FD0EAD5F677880BF6C181F296C751C5F6E65B04D3834C02F792FEE0FE452915D44AFE74A0C27E0D8E4B8D04EC52A8E281E01FF47E7D694E6C7275A09AFCBFD8CC82705A06B20FD6EF61EBBA6873E29C8C0F2CAEDDA2"
                            />
                        </CodeGroup>
                        <CodeGroup 
                                class="FirstMatchCodeGroup" 
                                version="1" 
                                PermissionSetName="Execution"
                                Description="This code group grants MyComputer code Execution permission. ">
                        	<IMembershipCondition 
                                    class="ZoneMembershipCondition"
                                    version="1"
                                    Zone="MyComputer" />
                            <CodeGroup
                                    class="UnionCodeGroup"
                                    version="1"
                                    PermissionSetName="FullTrust"
                                    Name="Microsoft_Strong_Name"
                                    Description="This code group grants code signed with the Microsoft strong name full trust. ">
                                <IMembershipCondition
                                        class="StrongNameMembershipCondition"
                                        version="1"
                                        PublicKeyBlob="002400000480000094000000060200000024000052534131000400000100010007D1FA57C4AED9F0A32E84AA0FAEFD0DE9E8FD6AEC8F87FB03766C834C99921EB23BE79AD9D5DCC1DD9AD236132102900B723CF980957FC4E177108FC607774F29E8320E92EA05ECE4E821C0A5EFE8F1645C4C0C93C1AB99285D622CAA652C1DFAD63D745D6F2DE5F17E5EAF0FC4963D261C8A12436518206DC093344D5AD293"
                                />
                            </CodeGroup>
                            <CodeGroup
                                    class="UnionCodeGroup"
                                    version="1"
                                    PermissionSetName="FullTrust"
                                    Name="Ecma_Strong_Name"
                                    Description="This code group grants code signed with the ECMA strong name full trust. ">
                                <IMembershipCondition
                                        class="StrongNameMembershipCondition"
                                        version="1"
                                        PublicKeyBlob="00000000000000000400000000000000"
                                />
                            </CodeGroup>
                            <CodeGroup
                                    class="UnionCodeGroup"
                                    version="1"
                                    PermissionSetName="FullTrust"
                                    Name="Report_Server_Strong_Name"
                                    Description="This code group grants Report Server code full trust. ">
                                <IMembershipCondition
                                        class="StrongNameMembershipCondition"
                                        version="1"
                                        PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100272736AD6E5F9586BAC2D531EABC3ACC666C2F8EC879FA94F8F7B0327D2FF2ED523448F83C3D5C5DD2DFC7BC99C5286B2C125117BF5CBE242B9D41750732B2BDFFE649C6EFB8E5526D526FDD130095ECDB7BF210809C6CDAD8824FAA9AC0310AC3CBA2AA0523567B2DFA7FE250B30FACBD62D4EC99B94AC47C7D3B28F1F6E4C8"
                                />
                            </CodeGroup>
                            <CodeGroup
                                    class="UnionCodeGroup"
                                    version="1"
                                    PermissionSetName="FullTrust">
                                <IMembershipCondition 
                                        class="UrlMembershipCondition"
                                        version="1"
                                        Url="$CodeGen$/*"
                                />
                            </CodeGroup>
							<CodeGroup
								class="UnionCodeGroup"
								version="1"
								PermissionSetName="FullTrust"
								Description="This code group grants Microsoft.ReportingServices.Designer.dll FullTrust permission. ">
								<IMembershipCondition
									class="UrlMembershipCondition"
									version="1"
									Url="C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\Microsoft.ReportingServices.Designer.dll" />
							</CodeGroup>
							<CodeGroup
								class="UnionCodeGroup"
								version="1"
								PermissionSetName="FullTrust"
								Description="This code group grants TeeChart.ReportingServices.dll FullTrust permission. ">
								<IMembershipCondition
									class="UrlMembershipCondition"
									version="1"
									Url="C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\TeeChart.ReportingServices.dll" />
							</CodeGroup>
							<CodeGroup
								class="UnionCodeGroup"
								version="1"
								PermissionSetName="FullTrust"
								Description="This code group grants TeeChart.ReportingServices.CRI.dll FullTrust permission. ">
								<IMembershipCondition
									class="UrlMembershipCondition"
									version="1"
									Url="C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\TeeChart.ReportingServices.CRI.dll" />
							</CodeGroup>
                            <CodeGroup
                                    class="UnionCodeGroup"
                                    version="1"
                                    PermissionSetName="FullTrust"
                                    Name="SharePoint_Server_Strong_Name"
                                    Description="This code group grants SharePoint Server code full trust. ">
                                <IMembershipCondition
                                        class="StrongNameMembershipCondition"
                                        version="1"
                                        PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100AFD4A0E7724151D5DD52CB23A30DED7C0091CC01CFE94B2BCD85B3F4EEE3C4D8F6417BFF763763A996D6B2DFC1E7C29BCFB8299779DF8785CDE2C168CEEE480E570725F2468E782A9C2401302CF6DC17E119118ED2011937BAE9698357AD21E8B6DFB40475D16E87EB03C744A5D32899A0DBC596A6B2CFA1E509BE5FBD09FACF"
                                />
                            </CodeGroup>
                        </CodeGroup>
                    </CodeGroup>
                </PolicyLevel>
            </policy>
        </security>
    </mscorlib>
</configuration>

I have also added this info to the htm readme file.

"The definition of the report '/TeeChart' is invalid.
More Than one date set, data region, or grouping in the report has the name 'teeChart1_X'. Data set, data region, and grouping names must be unique within a report."

Yes, as things stand, the best that could be done was to only enable multiple series when these are generated automatically by teechart's crosstab facility. An example of crosstab can be seen on the chart on the right in the example TeeChart.rdl.

[ait]

Hi Christopher,

We want to thank you for your effective responses and your devotion for our problems.

All run good !

But We have any question about the multiple series in the same TeeChart component.
We want to show in the same Teechart Component some several series using differents DataSet for example...

When it will be possible ? Do you think in the next Release ?

[Christopher]

Hello,

We want to thank you for your effective responses and your devotion for our problems.

All run good !

Excellent, I'm pleased to hear it. You're very welcome.

But We have any question about the multiple series in the same TeeChart component.
We want to show in the same Teechart Component some several series using differents DataSet for example...

When it will be possible ? Do you think in the next Release ?

I do remember that there were some technical issues with this related to how customreportitems work with SQL RS2005. I'll have another look at it when I can, but I'm afraid I can't promise anything. In the meantime you'll have to use separate charts for each dataset.

[ait]

Hi Chris,

Our objective is to create a Chart which has several series (two at least), even though the dataset is the same.
At present,
_when we add only one series in our report. All run good !
but
_when we add a second series in our report, this error occured:

"The definition of the report '/TeeChart' is invalid.
More Than one data set, data region, or grouping in the report has the name 'teeChart1_X'. Data set, data region, and grouping names must be unique within a report."

We have one dataset, and we want to use it with several series.
How we can do this ?
If you add a second series in your report, the previous error occured or you can preview the several series ?

Thanks in avance

[Christopher]

Hello,

We have one dataset, and we want to use it with several series.
How we can do this ?
If you add a second series in your report, the previous error occured or you can preview the several series ?

I do remember that there were some technical issues with this related to how customreportitems work with SQL RS2005. I'll have another look at it when I can, but I'm afraid I can't promise anything. In the meantime you'll have to use separate charts for each dataset.