Data Flow Task Problem: class

Showing posts with label class. Show all posts

Tuesday, March 27, 2012

Data Extension Parameters

Hi,
I've implemented a data extension to use a custom business class to return a
dataset. This all works fine but I cannot seem to get parameters working. Has
anyone got any code snippets of creating parameters and the parameters being
available at run-time & design time.
All the examples I've seen don't use parameters so any help would be much
appreciated as I've got to produce this ASAP.
RegardsHi,
OK - I've worked out how to get the parameters in designer mode via the
GetParameters method. However, how do I get the parameters that I add via the
Report Dialog in VS.NET?
I've tried passing the parameter collection object but this comes back with
no items although there is one displayed in the preview.
Regards
"MikeD" wrote:
> Hi,
> I've implemented a data extension to use a custom business class to return a
> dataset. This all works fine but I cannot seem to get parameters working. Has
> anyone got any code snippets of creating parameters and the parameters being
> available at run-time & design time.
> All the examples I've seen don't use parameters so any help would be much
> appreciated as I've got to produce this ASAP.
> Regardssql

Saturday, February 25, 2012

data acess class

hi
i was reading book about asp.net and i found example for a dataacess class but i didn't understand this part

Private m_FieldData As New NameObjectCollection
Private _m_ConnectionString As String
Private m_dbConnection As SqlConnection
Private Sub AddParameters( _
ByVal objCommand As SqlCommand, _
ByVal objValues() As Object)

Dim objValue As Object
Dim I As Integer
Dim objParameter As SqlParameter

objCommand.Parameters.Clear()
SqlCommandBuilder.DeriveParameters(objCommand)

I = 0
For Each objParameter In objCommand.Parameters
If objParameter.Direction = ParameterDirection.Input _
Or objParameter.Direction = _
ParameterDirection.InputOutput Then

objValue = objValues(I)
objParameter.Value = objValue
I = I + 1
End If
Next
End Sub

Private Sub AddFieldParameters _
(ByVal objCommand As SqlCommand)

Dim objParameter As SqlParameter

objCommand.Parameters.Clear()
SqlCommandBuilder.DeriveParameters(objCommand)

For Each objParameter In objCommand.Parameters
objParameter.Value = _
_FieldData.Item(objParameter.ParameterName. _
Substring(1))
Next
End Sub
Public Function ExecDataReader _
(ByVal strStoredProc As String, _
ByVal ParamArray objValues() As Object) _
As SqlDataReader

Dim objCommand As SqlCommand
Dim objReader As SqlDataReader

objCommand = New SqlCommand

objCommand.CommandText = strStoredProc
objCommand.CommandType = CommandType.StoredProcedure
objCommand.Connection = dbConnection

Try
objCommand.Connection.Open()
If (objValues.Length = 0) Then
AddFieldParameters(objCommand)
Else
AddParameters(objCommand, objValues)
End If
objReader = objCommand. _
ExecuteReader(CommandBehavior.CloseConnection)
Catch ex As Exception
If objCommand.Connection.State.Open Then
objCommand.Connection.Close()
End If
End Try

Return objReader
End Function
can anybody help me what the author want to doTamer, can you be more specific?

Thanks|||hi i don't understand sub AddParameters and addfieldparameter
and why to add values as an array
and the parameter have only one single value why to pass an array of object i can pass a single value hope u understand me|||I'm going to have to kind of guess here as I don't know the source or the context of the script. That being said

Looking at just the AddFieldParameters sub:
---------------------------------
Private Sub AddFieldParameters (ByVal objCommand As SqlCommand)

Dim objParameter As SqlParameter

objCommand.Parameters.Clear()
SqlCommandBuilder.DeriveParameters(objCommand)

For Each objParameter In objCommand.Parameters
objParameter.Value = FieldData.Item(objParameter.ParameterName.Substring(1))
Next
End Sub
---------------------------------

I read this as the SQL command is being passed into the sub as a value and that value can have multiple lines to it. The FieldData object is being created with each line of the SQL command as a different entry in the array.

The AddParameters looks pretty much the same.

Does this answer your question?

I can look into this further if you provide me with the origional source and location of the script.

Thanks

Data Access Application Block: Using in Class Library

I'm trying to use the Data Access Application block, and am having some issues with configuration. I am using it in a class library, and it seems that with v 3 you need to configure the DAAB first, making changes to the configuration file. However, in a class library, I do not seem to have the web.config or app.config file to change. So where do I need to store the configuration settings?

Thanks,

Paul

I think you dont need to care about the Configuration in Class Library ... that will be Handled by the Application in which your Class Library is used.

For now you can Sample Application with Proper Configuration and use your class Library in that to test.

|||

I am trying to put my data access code in the class library, though. How can I configure the DAAB to work WITHIN there? Or do I need to pull all data access code out of the class library and into the application?

The library I am developing will be used by several applications, so I would like to encapsulate the data aceess there...

Ideally, I would like to designate the database configuration I am using at run-time, by passing the connection string info in from the consuming applications...

|||

Once after creating DAL then you can keep both Enterprise and DAL dlls can be placed in Web App or Windows app. And all the required configuration can be added in Web.Config and App.Config filesrespectively. We are doing same with Enterprise Library 3.1

Tuesday, February 14, 2012

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

. . .

</ReportItems>

. . .

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

. . .

</ReportItemDesigner>

</ReportItems>

. . .

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

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

Thanks.

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

. . .

</ReportItems>

. . .

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

. . .

</ReportItemDesigner>

</ReportItems>

. . .

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\PolygonsDesigner.dll', Symbols loaded.
. . .
Framevork Ver.: 2.0.50727.26

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.

-- 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

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

Thanks.

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

. . .

</ReportItems>

. . .

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

. . .

</ReportItemDesigner>

</ReportItems>

. . .

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\PolygonsDesigner.dll', Symbols loaded.
. . .
Framevork Ver.: 2.0.50727.26

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.

-- 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

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

Thanks.

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

. . .

</ReportItems>

. . .

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

. . .

</ReportItemDesigner>

</ReportItems>

. . .

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\PolygonsDesigner.dll', Symbols loaded.
. . .
Framevork Ver.: 2.0.50727.26

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.

-- 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

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

Thanks.

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

. . .

</ReportItems>

. . .

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

. . .

</ReportItemDesigner>

</ReportItems>

. . .

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\PolygonsDesigner.dll', Symbols loaded.
. . .
Framevork Ver.: 2.0.50727.26

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.

-- 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

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

Thanks.

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

. . .

</ReportItems>

. . .

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

. . .

</ReportItemDesigner>

</ReportItems>

. . .

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\PolygonsDesigner.dll', Symbols loaded.
. . .
Framevork Ver.: 2.0.50727.26

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.

-- 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

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

Thanks.

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

. . .

</ReportItems>

. . .

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

. . .

</ReportItemDesigner>

</ReportItems>

. . .

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\PolygonsDesigner.dll', Symbols loaded.
. . .
Framevork Ver.: 2.0.50727.26

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.

-- 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

Tuesday, March 27, 2012

Data Extension Parameters

Saturday, February 25, 2012

data acess class

Data Access Application Block: Using in Class Library

Tuesday, February 14, 2012

CustomReportItem Question

CustomReportItem Question

CustomReportItem Question

CustomReportItem Question

CustomReportItem Installation

CustomReportItem Installation

CustomReportItem Installation

Data Flow Task Problem

Blog Archive

About Me