Thanks Linda, that's reassuring. Having rarely shared a report project with a colleague before I've never noticed this behaviour. Unfortunately, this means the reports with that data source don't run...

Thanks for this - solved my problem.

You could also insert the following if the login doesn't yet exist in each database

CREATE USER LOGIN_HERE

GO

I agree that there's a temptation for the manager to save up everything to the annual review, sometimes long after the detail of some issues has been forgotten. But where...

On the subject of consolidating SQL Server instances, we have the opposite problem of trying to arrange separate groups of databases on one machine. This is really just get round...

glad to help, though I didn't know about Ben's solution and it is a little neater...

I don't know any way of converting a literal string into something which could be interpreted as a field name. Better to pass your @param to the underlying stored proc...

Hi there,

I haven't moved the SMS site database, I just want to run queries on it (in its current location) from our company SQL Server installation. I expect this...

that's much better!

neat one dystarry. And here's the solution for rows grouped by type_id:

declare @type_id int

declare cursor1 CURSOR FAST_FORWARD FOR SELECT distinct type_id FROM fruit

drop table #Temp

create table #Temp (region_id int, atext...

this is mostly useful when you have to group rows together by one field and concatenate the corresponding values for each group. How would the solution look then?

I have tried to alter the width of multi-value parameter drop-downs but have not found a way. You can however vary the width of other parameters by editing the ReportingServices.css...

OK I can empathise with that...

what is SCOME?

Standing Committee on Medical Education (SCOME)?

another problem is that when 'Select All' is selected, you have to deal with a massive string which slows down the performance of your proc, rather than ignoring the condition...

I've always used this code in my stored procs:

charindex(',' + rtrim(fieldname) + ',',',' + @paramlist + ',') > 0