sql server reporting services: Report availablity during maintenance (Vital but rarely discussed) -- sql server reporting services

You're in the

sql server reporting services

group:

Report availablity during maintenance (Vital but rarely discussed)

Bryan Bullard
3/23/2005 12:48:02 PM

sql server reporting services:

Hi,

I need to be able to disable (or turn-off) a report during database
maintenance. Any suggestions?

Bryan

Re: Report availablity during maintenance (Vital but rarely discussed)

Jeff Lynch
3/23/2005 3:36:29 PM

What kind of database maintenance? Have you tried running a report while
your db is being backed up, reindexed, etc.?

--
Jeff Lynch
"A BizTalk Enthusiast"
http://codebetter.com/blogs/jeff.lynch/

[quoted text, click to view]

Re: Report availablity during maintenance (Vital but rarely discussed)

Bryan Bullard
3/23/2005 4:18:40 PM

Well, say I have a report that queries tables X, Y, and Z. I want the
report to be unavailable if those tables are either non-existent or not
complete because of maintenance operation is being performed that recreates,
loads, etc ....

[quoted text, click to view]

Re: Report availablity during maintenance (Vital but rarely discussed)

Jeff Lynch
3/24/2005 9:35:25 AM

Got it. I don't believe there is any standard way to accomplish this except
you can set the "NoRows" property to display a string stating that the
report is unavailable.

--
Jeff Lynch
"A BizTalk Enthusiast"
http://codebetter.com/blogs/jeff.lynch/

[quoted text, click to view]

Re: Report availablity during maintenance (Vital but rarely discussed)

Jeff A. Stucker
3/24/2005 2:17:41 PM

If you want to get fancy, you could create a script that uploads an
alternate report (with nothing more than a message for users) at the
beginning of the maintenance process, and then another script that uploads
the real report when it's done.

(I haven't checked the interface to see if you can rename reports; if
possible, they could be uploaded already and the scripts simply swap them by
changing their names. Someone else feel free to jump in on this one...)

--
Cheers,

'(' Jeff A. Stucker
\

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn