Wednesday, March 21, 2012

RS2005 and Reuse

Does RS2005 provide the ability to create reusable components? By component
I mean the ability to create graphs or textboxes that are tied to certain
expressions or sql queries and stored for reuse. This would allow an enduser
to simply select the component to put on the report without knowing anything
about the data. All they need to know is they want "Graph X" on the report.
Is this philosphy supported by Report Builder?
ThanksThe tools on the tools list are dot net classes... You can create a dot net
assembly, which subclasses the chart controls, etc, adding your custom stuff
( ie making it data-aware), deploy it to the developers desktop and RS
server. Then the developers can add the new custom controls to their toolbar
and go to work...
The big deal, is that now you must deploy/maintain this new assembly...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"tcs" wrote:
> Does RS2005 provide the ability to create reusable components? By component
> I mean the ability to create graphs or textboxes that are tied to certain
> expressions or sql queries and stored for reuse. This would allow an enduser
> to simply select the component to put on the report without knowing anything
> about the data. All they need to know is they want "Graph X" on the report.
> Is this philosphy supported by Report Builder?
>
> Thanks|||Thanks for the response Wayne. Its good to see the flexiblity is available
even if you need to maintain the assembly.
"tcs" wrote:
> Does RS2005 provide the ability to create reusable components? By component
> I mean the ability to create graphs or textboxes that are tied to certain
> expressions or sql queries and stored for reuse. This would allow an enduser
> to simply select the component to put on the report without knowing anything
> about the data. All they need to know is they want "Graph X" on the report.
> Is this philosphy supported by Report Builder?
>
> Thankssql

No comments:

Post a Comment