It depends on what changes you need to make to it - if you are going to drop columns that the existing reports depend on then they will fail as...

IIRC, the calendar box appears by default in Report Manager if the parameter datatype is set to date

If the parameter datatype is set to text, the calendar box does not...

Me neither, we just used ReportManager to administer reports but we never needed to do a bulk removal so it didn't matter too much having to do things one report...

Looks like the DeleteItem method would be the one to use inside an RS script file to remove all the related objects, but you would still need to iterate through...

Well, it does do what the OP requested...:Whistling:

But you are right, it will leave orphan subscriptions and schedules etc. littering the reportserver db so doesn't provide a very complete solution...

This should work (I haven't tested it against our reportserver db for obvious reasons:-D), but you should take a backup of the reportserver db first as MS do not support...

I stand corrected :blush:

I think The Ninja meant for you to add those columns to the included part of the index, rather than to the index key itself like this?

IF EXISTS (SELECT...

Is it always the same data that is missing?

I haven't heard of the problem but I know some rendering formats do not like overlapping tablixes etc. so you might want...

AFAIK, there is no way to change this from ReportManager as it is auto-created

You could change it by running an update script against the ReportServer db directly but this is...

Brian K McDonald wrote a blog entry about how to do this recently:

http://www.sqlservercentral.com/blogs/briankmcdonald/archive/2011/6/30/watermarking.aspx

Like the use of Stuff() there, and if you change the cte slightly to use this code which I have snagged from Jeff Moden's brilliant DelimitedSplit8K function it runs even...

Check out the dense_rank() function

--select

--'Greg' as Person, 100 [Sales Amt]

--into #TestData

--union

--select 'Phil', 100

--union

--select 'Mike', 75

--union

--select 'Joe', 75

--union

--select 'Jeff', 50

--union

--select 'Clay', 10

--union

--select...

I was playing around with using a set of variables to hold the positions of the spaces like this

select

'SABRE a CIRCUIT BREAKER MOTORISATION SCHEMATIC DIAGRAM, FOR USE WITH MICOM &...

Does the code work if you type in the value rather than trying to pass in a parameter?