Display a report in fullscreenmode

Hello,
is it possible to open a report in fullscreenmode automatically? Perhaps there might be a http parameter?

Current view:

Now a click on the button on the right side. This is the view i want to see when i open a report.

Did anyone have an idea how i can achieve my goal?

Thanks for your help!
Christian Niehaves

Use the url http://servername/ReportServer instead of http://servername/Reports|||Great.
Thanks for your help.

disconnect in an emergency

Hi,
In the event of an emergency restore in SQL 2000, I used to right
click on a database, choose detach and then the "clear" button to
disconnect all users. I didn't actually detach the database, this just
was my sneak out to disconnect so I could run my restore scripts for
the db backups and the logs. I do have a script that I can run that
loops through the SP_WHO results and kills all the spids, but that
takes time and I don't want to have to build that into my restore
scripts.
Does anyone know of a quick way in SSMS where I can detach users from
a database? There are so many more options, I am wondering if I am
just missing where to click?
Thanks all you gurus out there.
KristinaAlter Database Foo set offline with rollback immediate
Go
alter database foo set online
Go
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Kristina" <KristinaDBA@.gmail.com> wrote in message
news:1181324410.567760.132940@.k79g2000hse.googlegroups.com...
> Hi,
> In the event of an emergency restore in SQL 2000, I used to right
> click on a database, choose detach and then the "clear" button to
> disconnect all users. I didn't actually detach the database, this just
> was my sneak out to disconnect so I could run my restore scripts for
> the db backups and the logs. I do have a script that I can run that
> loops through the SP_WHO results and kills all the spids, but that
> takes time and I don't want to have to build that into my restore
> scripts.
> Does anyone know of a quick way in SSMS where I can detach users from
> a database? There are so many more options, I am wondering if I am
> just missing where to click?
> Thanks all you gurus out there.
> Kristina
>|||On Jun 8, 1:48 pm, "Geoff N. Hiten" <SQLCrafts...@.gmail.com> wrote:
> Alter Database Foo set offline with rollback immediate
> Go
> alter database foo set online
> Go
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Kristina" <Kristina...@.gmail.com> wrote in message
> news:1181324410.567760.132940@.k79g2000hse.googlegroups.com...
>
> > Hi,
> > In the event of an emergency restore in SQL 2000, I used to right
> > click on a database, choose detach and then the "clear" button to
> > disconnect all users. I didn't actually detach the database, this just
> > was my sneak out to disconnect so I could run my restore scripts for
> > the db backups and the logs. I do have a script that I can run that
> > loops through the SP_WHO results and kills all the spids, but that
> > takes time and I don't want to have to build that into my restore
> > scripts.
> > Does anyone know of a quick way in SSMS where I can detach users from
> > a database? There are so many more options, I am wondering if I am
> > just missing where to click?
> > Thanks all you gurus out there.
> > Kristina- Hide quoted text -
> - Show quoted text -
THANKS! I actually did this, but omitted the rollback immediate.
perfect! :)

Disable Right Click?

Is there anyway to disable mouse right click events in Reporting Services
Reports?
I am using RS 2005.
On custom web pages, I can either use javascript/vbscript or set
oncontextmenu="return false".
How can I accomplish the same results using Reporting Services?
I've been searching and find no built-in property for my desired result. I
do have access to Visual Studio 2005, is there a custom way to provide what I
need using VB.Net or other method?
I realize that even if possible, users can probably get around it, but at
least it will limit users from exporting data to Excel for example.
Thanks!labsRcool@.community.nospan wrote:
> Is there anyway to disable mouse right click events in Reporting Services
> Reports?
> I am using RS 2005.
> On custom web pages, I can either use javascript/vbscript or set
> oncontextmenu="return false".
> How can I accomplish the same results using Reporting Services?
> I've been searching and find no built-in property for my desired result. I
> do have access to Visual Studio 2005, is there a custom way to provide what I
> need using VB.Net or other method?
> I realize that even if possible, users can probably get around it, but at
> least it will limit users from exporting data to Excel for example.
> Thanks!
I also responded to your other posting. It seems that you should
design a custom interface in VB.NET that allows a user to view the
report in some manner; but not actually have access to the report to
export it. I believe that an application can customize user access
much better.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Thanks EMartinez for your input.
When you say "VB.Net", are you refering to creating custom asp.net webpages
via vb.net, or are you suggesting the only way to accomplish my goal is to
move away from webpages all to gether?
Thanks
"EMartinez" wrote:
> labsRcool@.community.nospan wrote:
> > Is there anyway to disable mouse right click events in Reporting Services
> > Reports?
> >
> > I am using RS 2005.
> > On custom web pages, I can either use javascript/vbscript or set
> > oncontextmenu="return false".
> >
> > How can I accomplish the same results using Reporting Services?
> >
> > I've been searching and find no built-in property for my desired result. I
> > do have access to Visual Studio 2005, is there a custom way to provide what I
> > need using VB.Net or other method?
> >
> > I realize that even if possible, users can probably get around it, but at
> > least it will limit users from exporting data to Excel for example.
> >
> > Thanks!
> I also responded to your other posting. It seems that you should
> design a custom interface in VB.NET that allows a user to view the
> report in some manner; but not actually have access to the report to
> export it. I believe that an application can customize user access
> much better.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>|||On Mar 2, 5:10 pm, labsRc...@.community.nospan
<labsRcoolcommunitynos...@.discussions.microsoft.com> wrote:
> Thanks EMartinez for your input.
> When you say "VB.Net", are you refering to creating custom asp.net webpages
> via vb.net, or are you suggesting the only way to accomplish my goal is to
> move away from webpages all to gether?
> Thanks
> "EMartinez" wrote:
> > labsRc...@.community.nospan wrote:
> > > Is there anyway to disable mouse right click events in Reporting Services
> > > Reports?
> > > I am using RS 2005.
> > > On custom web pages, I can either use javascript/vbscript or set
> > > oncontextmenu="return false".
> > > How can I accomplish the same results using Reporting Services?
> > > I've been searching and find no built-in property for my desired result. I
> > > do have access to Visual Studio 2005, is there a custom way to provide what I
> > > need using VB.Net or other method?
> > > I realize that even if possible, users can probably get around it, but at
> > > least it will limit users from exporting data to Excel for example.
> > > Thanks!
> > I also responded to your other posting. It seems that you should
> > design a custom interface in VB.NET that allows a user to view the
> > report in some manner; but not actually have access to the report to
> > export it. I believe that an application can customize user access
> > much better.
> > Regards,
> > Enrique Martinez
> > Sr. SQL Server Developer
You should be able to use VB.NET to create custom web pages w/various
access levels.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Thank for your input.
I will attempt custom asp.net approach,
Thanks!
"EMartinez" wrote:
> On Mar 2, 5:10 pm, labsRc...@.community.nospan
> <labsRcoolcommunitynos...@.discussions.microsoft.com> wrote:
> > Thanks EMartinez for your input.
> >
> > When you say "VB.Net", are you refering to creating custom asp.net webpages
> > via vb.net, or are you suggesting the only way to accomplish my goal is to
> > move away from webpages all to gether?
> >
> > Thanks
> >
> > "EMartinez" wrote:
> >
> > > labsRc...@.community.nospan wrote:
> > > > Is there anyway to disable mouse right click events in Reporting Services
> > > > Reports?
> >
> > > > I am using RS 2005.
> > > > On custom web pages, I can either use javascript/vbscript or set
> > > > oncontextmenu="return false".
> >
> > > > How can I accomplish the same results using Reporting Services?
> >
> > > > I've been searching and find no built-in property for my desired result. I
> > > > do have access to Visual Studio 2005, is there a custom way to provide what I
> > > > need using VB.Net or other method?
> >
> > > > I realize that even if possible, users can probably get around it, but at
> > > > least it will limit users from exporting data to Excel for example.
> >
> > > > Thanks!
> >
> > > I also responded to your other posting. It seems that you should
> > > design a custom interface in VB.NET that allows a user to view the
> > > report in some manner; but not actually have access to the report to
> > > export it. I believe that an application can customize user access
> > > much better.
> >
> > > Regards,
> >
> > > Enrique Martinez
> > > Sr. SQL Server Developer
>
> You should be able to use VB.NET to create custom web pages w/various
> access levels.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>