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 wishlist

Hi,
I would like to add one more item to RS wishlist:
- ability to dynamically switching parameter prompts
Example:
when userid = Person1 then Parameter1 prompt is ON
when userid = Person2 then Parameter1 prompt is OFF
TIA,
KamelThanks, this is on our wishlist as well.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"kamel" <kwiciak@.gmail.com> wrote in message
news:1114775390.305089.6510@.l41g2000cwc.googlegroups.com...
> Hi,
> I would like to add one more item to RS wishlist:
> - ability to dynamically switching parameter prompts
> Example:
> when userid = Person1 then Parameter1 prompt is ON
> when userid = Person2 then Parameter1 prompt is OFF
> TIA,
> Kamel
>

RS Printing Questions

1. When creating a report,In the preview tab i have the ability to print out
the report (using the print button) however once the report is deployed to
the report server the user doesnt get the print button and can only print
from the browser.Is there any way to print from the report (as opposed to the
browser) after the report has been deployed?
2.When printing from the browser,only the first page prints out,even though
'All' pages has been selected in the print dialog.This only occurs when
printing out a report,If i print out another web page all the pages print
out.Does anyone know of a fix for this?Vinny,
This is annoying. I found one way around this - the report prints
beautifully (if you set it up correctly) from PDF. You can provide a
'Printable Report' link to the user to the PDF version - that will work. To
do that you append ''&rs%3AFormat=PDF" to the end of the regular report URL.
This works pretty well - obviously it would be ideal if Reporting Services
didnt have this problem, but here's one work around. Hope this helps.
Derek
"Vinny Vinn" wrote:
> 1. When creating a report,In the preview tab i have the ability to print out
> the report (using the print button) however once the report is deployed to
> the report server the user doesnt get the print button and can only print
> from the browser.Is there any way to print from the report (as opposed to the
> browser) after the report has been deployed?
> 2.When printing from the browser,only the first page prints out,even though
> 'All' pages has been selected in the print dialog.This only occurs when
> printing out a report,If i print out another web page all the pages print
> out.Does anyone know of a fix for this?|||Derek,
Thank you,How can i provide a 'Printable Report' link,(i dont have a
link in my toolbox- the user can export the report to PDF.)?
Vinny
"Derek Fisher" wrote:
> Vinny,
> This is annoying. I found one way around this - the report prints
> beautifully (if you set it up correctly) from PDF. You can provide a
> 'Printable Report' link to the user to the PDF version - that will work. To
> do that you append ''&rs%3AFormat=PDF" to the end of the regular report URL.
> This works pretty well - obviously it would be ideal if Reporting Services
> didnt have this problem, but here's one work around. Hope this helps.
> Derek
> "Vinny Vinn" wrote:
> > 1. When creating a report,In the preview tab i have the ability to print out
> > the report (using the print button) however once the report is deployed to
> > the report server the user doesnt get the print button and can only print
> > from the browser.Is there any way to print from the report (as opposed to the
> > browser) after the report has been deployed?
> >
> > 2.When printing from the browser,only the first page prints out,even though
> > 'All' pages has been selected in the print dialog.This only occurs when
> > printing out a report,If i print out another web page all the pages print
> > out.Does anyone know of a fix for this?|||Keep in mind that SP2 will have client side printing (if you are using
Report Manager or URL integration, not sure what happens with web services).
SP2 will hopefully be out this month. Soon, anyway.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Vinny Vinn" <VinnyVinn@.discussions.microsoft.com> wrote in message
news:2E283D92-05EB-46A4-9DE6-8703A9DE5E81@.microsoft.com...
> Derek,
> Thank you,How can i provide a 'Printable Report' link,(i dont have a
> link in my toolbox- the user can export the report to PDF.)?
> Vinny
> "Derek Fisher" wrote:
> > Vinny,
> >
> > This is annoying. I found one way around this - the report prints
> > beautifully (if you set it up correctly) from PDF. You can provide a
> > 'Printable Report' link to the user to the PDF version - that will work.
To
> > do that you append ''&rs%3AFormat=PDF" to the end of the regular report
URL.
> > This works pretty well - obviously it would be ideal if Reporting
Services
> > didnt have this problem, but here's one work around. Hope this helps.
> >
> > Derek
> >
> > "Vinny Vinn" wrote:
> >
> > > 1. When creating a report,In the preview tab i have the ability to
print out
> > > the report (using the print button) however once the report is
deployed to
> > > the report server the user doesnt get the print button and can only
print
> > > from the browser.Is there any way to print from the report (as opposed
to the
> > > browser) after the report has been deployed?
> > >
> > > 2.When printing from the browser,only the first page prints out,even
though
> > > 'All' pages has been selected in the print dialog.This only occurs
when
> > > printing out a report,If i print out another web page all the pages
print
> > > out.Does anyone know of a fix for this?