显示标签为“perhaps”的博文。显示所有博文
显示标签为“perhaps”的博文。显示所有博文

2012年3月29日星期四

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.

2012年3月7日星期三

Disabling triggers not involved in replication in SQL 2000

I am experimenting with replication and recently set up a prototype
transactional replication with about a dozen publications and perhaps twice
as many articles. All has gone smoothly so far. One item that is causing
much gnashing of teeth is the fact that I cannot disable a pre-existing
trigger that has nothing to do with the replication.
Msg 4929, Level 16, State 2, Line 1
Cannot alter the table 'XXXXX' because it is being published for replication.
Any help greatly appreciated.
Craig
Craig,
you won't be able to do this sort of statement: "alter table suppliers
disable trigger all" but you can issue an alter trigger statement. If there
are only a few triggers this might be practical for you.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)