Data Flow Task Problem: element

Showing posts with label element. Show all posts

Monday, March 19, 2012

Data Design Issues

I am working on a Project Management application, and I have two data design issues I am debating.

The key element of this app, as you might expect, is Project. The project will proceed through many phases, from Planning, to Pre-Design, Design, Bid, Construction and Post Construction. All along the way there are a number of discrete tasks that must be performed and tracked.

I bounce back and forth in my mind between a single Project table that encapsulates all of these tasks, but am hesitant because I'm not a big fan of large monolithic tables. Alternatively, I could logically create separate tables for the various phases. However, this would create a series of one-to-one relationships between Project and the Phase tables, and require extra joins. The performance hit would probably not be too bad, but I would need to add extra code in either the app code or stored procedures to create an empty record in each of the phase tables when a new project is added. (Obviously, projects in planning or design will not have active records in the Construction and Post Construction tables). What are your thoughts about these choices?

Secondly, I have to manage data for a lot of individuals, which basically break down into two groups. First are internal employees who will have tasks routed to them, be invited to meetings, etc. Second are external vendors, basically contractors and consultants, who will be performing work and also be invited to meetings and such. I need to track the participants in meetings and inspections, so will have a Meeting Participant table to capture the many-to-many relationship. My issue is structuring the handling of the people. One option is to have a Person table, which basically includes everybody, with a flag field for internal or external people, and categories for their roles. Second is a table for internal folks and a table for external, or separate tables for Consultants, Contractors, and internal Employees. However, this makes capturing the meeting participants more cumbersome.

What is the collective wisdom on these? Thanks!

Jeff LittleThe place to start is the Time Tracker starter kit table design and make modification as needed. The second place is to test drive Enterprise Project Server it comes with Database templates for OLTP and OLAP to build cubes for the project. Check the link below for a demo I attended a while back with OLAP cubes, you can also search the TechNet site for more Project demos. Hope this helps.
http://www.microsoft.com/technet/community/events/project/tnt1-64.mspx

Kind regards,
Gift Peddie|||Here's my suggestion:

Project (ProjectID, ...)
Task (ProjectID, PhaseID, TaskID, TaskTypeID, TaskName, ...)
Phase (PhaseID, Name, ...)
TaskType (TaskTypeID, Name, ...)

Person (PersonID, PersonTypeID, PersonName, Username, ...)
PersonType (PersonTypeID, Name, Internal Bit, ...)|||Hi Jeff,

First off I would go with the idea of multple tables for the project instead of one. I have seen way to many applications where the number of fields and record length is outrageous given that most of the time a third to a half of the fields aren't populated. As for your concerns about adding an empty record, why? Simply do an outer join, where no matching record exists the field values from the applicable table will be null.

Lastly, people are people unless there is some compelling reason such as significant data requirements for internal as opposed to external they belong in the same table.

Cheers

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

CustomReportItem Element in an RDL

I have 3 related questions, thanks ahead of time for any help...
1 - Does anyone know of any documentation and/or examples on how to use the
CustomReportItem Element in an RDL doc? MS has a PDF available about the
RDL specification, RDLDEC03.PDF, but it is not very clear on how to use it.
2 - Is there a way to write your own custom Report Item that could be added
to the toolbox?
3- Specifically, when a report is rendered as HTML, we want to add a
checkbox and a bit of JavaScript to allow users to select/deselect report
records. Is there another way besides 1 or 2?
Thanks again!#1, #2:
The currently available RDL spec describes the CustomReportItem element as
defined in RS 2000. The specification is getting changed/extended in RS
2005. We are planning on making a comprehensive sample for implementing a
design time control (report designer) and a runtime control (report server)
available when RS 2005 gets released.
#3:
This is only possible if you write your own custom rendering extension (on
top of RS 2000 or RS 2005). You cannot do your own Javascript just through a
CustomReportItem processing/runtime control.
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Scott LaFave" <slafave@.trendmls.com> wrote in message
news:eDKv2%23$TFHA.2812@.tk2msftngp13.phx.gbl...
>I have 3 related questions, thanks ahead of time for any help...
> 1 - Does anyone know of any documentation and/or examples on how to use
> the CustomReportItem Element in an RDL doc? MS has a PDF available about
> the RDL specification, RDLDEC03.PDF, but it is not very clear on how to
> use it.
> 2 - Is there a way to write your own custom Report Item that could be
> added to the toolbox?
>
> 3- Specifically, when a report is rendered as HTML, we want to add a
> checkbox and a bit of JavaScript to allow users to select/deselect report
> records. Is there another way besides 1 or 2?
> Thanks again!
>|||hi,
About #2, is there a step by step RS 2000 example code ?
Thanks.
> #1, #2:
> The currently available RDL spec describes the CustomReportItem element as
> defined in RS 2000. The specification is getting changed/extended in RS
> 2005. We are planning on making a comprehensive sample for implementing a
> design time control (report designer) and a runtime control (report
server)
> available when RS 2005 gets released.
> #3:
> This is only possible if you write your own custom rendering extension (on
> top of RS 2000 or RS 2005). You cannot do your own Javascript just through
a
> CustomReportItem processing/runtime control.
>
> --
> Robert M. Bruckner
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Scott LaFave" <slafave@.trendmls.com> wrote in message
> news:eDKv2%23$TFHA.2812@.tk2msftngp13.phx.gbl...
> >I have 3 related questions, thanks ahead of time for any help...
> >
> > 1 - Does anyone know of any documentation and/or examples on how to use
> > the CustomReportItem Element in an RDL doc? MS has a PDF available
about
> > the RDL specification, RDLDEC03.PDF, but it is not very clear on how to
> > use it.
> >
> > 2 - Is there a way to write your own custom Report Item that could be
> > added to the toolbox?
> >
> >
> > 3- Specifically, when a report is rendered as HTML, we want to add a
> > checkbox and a bit of JavaScript to allow users to select/deselect
report
> > records. Is there another way besides 1 or 2?
> >
> > Thanks again!
> >
> >
>

Monday, March 19, 2012

Data Design Issues

Tuesday, February 14, 2012

CustomReportItem Question

CustomReportItem Question

CustomReportItem Question

CustomReportItem Question

CustomReportItem Installation

CustomReportItem Installation

CustomReportItem Installation

CustomReportItem Element in an RDL

Data Flow Task Problem

Blog Archive

About Me