I got to finish my lunch! Thanks for the question.

Nice to recollect INTERSECT. Basic, but I've almost forgotten to use it. Thanks Ron!

Simple one. Thanks for sharing!

I got it. I presumed that restorehistory keeps only the latest restore record. But I came across with restorehistory table that contained multiple records for a database restored periodically. So...

Please refer http://www.sqlservercentral.com/Forums/Topic966065-1550-1.aspx

We restore our testing database frequently from Production database. Is there any way we can get details of all previous restores, or may be last 5 restores?

SELECT * FROM dbo.restorehistory

Returns...

Good to know. Not yet encountered such scenario. Thanks for sharing!

Nice one. It being long since I last used SSAS, gets hard to recollect things.

It's because either or both of the queries are returning more than one ID.

SELECT ID FROM MyCTE WHERE FullContent = 'Authorized Privileges:'

SELECT ID FROM MyCTE WHERE FullContent = 'Default Privileges:'

Do...

Try setting properties related to the textboxes, like "can increase to accomodate contents" to false.

You may try the alignment by setting hard coded values to the textboxes. Just to see...

Is this resolved by now? If yes, what approach did you take?

Michael R (1/5/2009)

---

Here is another workaround that may be helpful:

http://blogs.msdn.com/lukaszp/archive/2005/10/11/479791.aspx

Use a hidden parameter and drillthrough links back to the same report. The hidden parameter will be used...

Somehow I missed to set the options as checkboxes....

Are you sure about this?

I tried replicating this in SSRS 2005 (unfortunately I don't have SSRS 2008 installed on my machine).

With a dataset like:

Select 'Pre Order #1' as Text

union

Select 'Pre...

I agree with Steve. Normally it's conversion or calculation error. The twist is it works in BIDS but not when deployed (I guess with the same data). :crazy: