How can I configure Report Services to show different set of Rendering Extension Per Repor

Hi There,
I'd like to configure the report services rendering extension on a per
report application basis. for example, if i have two report packages
named Package A and Package B, and I'd like to show only "PDF" as the
only export option for Package A, and "Excel" only for Package B. Is
there anyway to achieve this? changing the RSReportServer.config will
affect all report applications on the same server.
Regards,
KevinNo way to do this. Only way would be to have your own application instead of
using Report Manager.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<hodgelai@.yahoo.com> wrote in message
news:1124482992.992758.129540@.z14g2000cwz.googlegroups.com...
> Hi There,
> I'd like to configure the report services rendering extension on a per
> report application basis. for example, if i have two report packages
> named Package A and Package B, and I'd like to show only "PDF" as the
> only export option for Package A, and "Excel" only for Package B. Is
> there anyway to achieve this? changing the RSReportServer.config will
> affect all report applications on the same server.
>
> Regards,
> Kevin
>|||Thanks, Bruce!
Is that doable in SQL 2005?|||Thanks, Bruce!
Is that doable in SQL 2005?|||I don't think so but I don't know for sure.
One thing you could do is disable all export and then on your report have a
link at the top that exports to the format that you want.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<hodgelai@.yahoo.com> wrote in message
news:1124484347.411986.145310@.z14g2000cwz.googlegroups.com...
> Thanks, Bruce!
> Is that doable in SQL 2005?
>

Hot Backup

Someone told me should backup the live data files (files with
extension MDF and LDF) instead of the backup files (file with
extension BAK) in hot backup. I don't think it work in the case I need
to restore these data files from tape backup. Am I correct?That person might be thinking about the various type of snapshot backup products that exists. This
type of backup uses some technique to "freeze" the I/O for some period of time and then use some
journaling to keep track of the modifications performed while the backup is running (while you are
copying the files). There's some information in SQL Server 2005 Books Online, search for instance
for "VSS Writer" (which is the service in SQL server to assist these types of backup programs).
But in general you are right. You don't want to just "grab the database files".
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<viet@.rocketmail.com> wrote in message
news:2341c184-ec8b-42d7-b250-3e5acd594e49@.w8g2000prd.googlegroups.com...
> Someone told me should backup the live data files (files with
> extension MDF and LDF) instead of the backup files (file with
> extension BAK) in hot backup. I don't think it work in the case I need
> to restore these data files from tape backup. Am I correct?|||On Apr 24, 6:47=A0pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> That person might be thinking about the various type of snapshot backup pr=oducts that exists. This
> type of backup uses some technique to "freeze" the I/O for some period of =time and then use some
> journaling to keep track of the modifications performed while the backup i=s running (while you are
> copying the files). There's some information in SQL Server 2005 Books Onli=ne, search for instance
> for "VSS Writer" (which is the service in SQL server to assist these types= of backup programs).
> But in general you are right. You don't want to just "grab the database fi=les".
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asph=
ttp://sqlblog.com/blogs/tibor_karaszi
> <v...@.rocketmail.com> wrote in message
> news:2341c184-ec8b-42d7-b250-3e5acd594e49@.w8g2000prd.googlegroups.com...
>
> > Someone told me should backup the live data files (files with
> > extension MDF and LDF) instead of the backup files (file with
> > extension BAK) in hot backup. I don't think it work in the case I need
> > to restore these data files from tape backup. Am I correct... Hide quoted= text -
> - Show quoted text -
If the intention is to backup the database before tape backup . You
can always schedule the db backups online before tape backup and
the .bak files can be backed up on tape.
If the database size is very large you can use the tools like
Litespeed which will help you to save on time.
Thanks
Ajay Rengunthwar
MCTS,MCDBA,MCAD