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

RS on the Internet - security issues

Hi there,

We are looking at making RS over the web for a client.

Is is safe to put RS on the web? Is it possible to provide adequate security for complete peace of mind - ssl etc? Or does another security layer have to be placed over it?

Advice, thoughts, and some pointers would be greatly appreciated!!

Many thanks

Chris

It is relatively safe, to a point. Check out this article:

http://msdn2.microsoft.com/en-us/library/ms157198.aspx

for a summary of SSRS authentication options.

Integrated Windows authentication is not sent in plain text, and it is controlled by IIS, not RS. But you can only use integrated (NTLM) authentication in IE.

sluggy

|||

Reporting services supports SSL.

For authentication, you can either:

1. use forms based authentication - take a look at the sample that comes with RS 2005 or

2. use the built-in Windows authentication if you want to give your users access to your domain.

In general RS 2005 is safer/easier to deploy in internet facing scenarios than RS 2000. See the following article for some more information.

http://blogs.msdn.com/tudortr/archive/2005/11/03/488731.aspx

The safest option is to only expose report manager outside of the firewall.

There will be more information on this topic in an upcoming MSDN doc refresh.

Thanks

Tudor Trufinescu

|||

Thanks Tudor,

To put into context, we are looking at putting a server into a datacentre, putting SQL and RS onto it, and RS making available to clients.

If we use windows authentication (with SSL?), would you consider this to be a secure environment? Considering the context, would it be a problem if clients have access to our domain? Could we set up their user accounts so that they would only be able to access our site via a browser into RS?

Regards

Chris

RS Certification

Hi,
Does Microsoft Provide Certification in RS.Where do i find the
information for the same.
Thanks,I think RS is part of the SQL Server BI certification.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"CCP" <CCP@.discussions.microsoft.com> wrote in message
news:E704B7E5-124B-431C-BC8B-539E3ED7096B@.microsoft.com...
> Hi,
> Does Microsoft Provide Certification in RS.Where do i find the
> information for the same.
>
> Thanks,