I used to get this a lot - same work around - close SSMS & reopen.

Patching SSMS to SP1 or 2 seemed to have stopped it happening.

Assuming you mean DataSet - double-click the dataset name, on the dialog box that pops up there's radio buttons for Text/Table/Stored Procedure.

No problem, good to hear it's working.

I'd go with nested REPLACEs. It's not going to look nice but I don't think there's a better way.

Perhaps wrap it in a Function if you need to reuse or...

I've never had any problem in a script when using SINGLE_USER, followed by another command against that database.

You could move the script around so the drop and restore are done...

Sorry, not quite sure what you're describing there.

Is the Date parameter a multi-valued parameter in the target report?

I suspect the expression's not generating the date in the right format - you might need to play with that a bit to get it working in date datatype.

Hi Debora,

Sounds like something's (RS URL?) missing in the Sharepoint RS config on the Central Admin Server - although I really am guessing in the dark now 🙂

There's some setup...

If I read it right, you're executing dynamic SQL (hence the @sql variable)?

Your temp table will be out of scope from within that execution - hence the error you're getting....

Is this any help? I assume you're generating the URL through an expression. Not sure on what format the date would be expected in though.

http://msdn.microsoft.com/en-us/library/ms155391(v=sql.105).aspx

(I'm also assuming that Jump to...

Hi Debora,

Not sure (as I don't use Sharepoint integration), but I think the RS Add-In needs to be installed on the Central Admin Server before it will appear on the...

Does this work?

= DATEADD("mm", DATEDIFF("mm", 0,Parameters!date.Value)-3, 0)

waxingsatirical (11/14/2012)

---

Hi Gaz,

The code I've posted is just some sample code to replicate the problem. When this happened in real life the persisted column was not just a repeat of...

I think SQL optimiser is second-guessing you because your computed column is equal to the 'real' one.

See if you get the behaviour you expect when the column is defined as:...

No worries mate 🙂