I looked into this a while ago and in the end I could only influence the displayed width of non-multivalue drop-downs. If you find an answer let me know!

Another way is to setup all the columns in the report but give the user a multi-value parameter to choose which columns they want. On the basis of their choice...

You could produce a report which when ran, displays one or more hyperlinks, one of which is the URL for your report with 'rs:Render=Excel' (I forget the precise syntax) tacked...

I'm using SP2 and my screen has an extra tick box, 'Quote strings contain list separators when saving .csv results' under Results to Grid.

Anyway, it now works! Thanks.

This doesn't work for me. I have SS2005, but I'm still not getting those pesky headers...

When defining the group, you need to use an expression, something like:

=iif(Parameters!Company.Value = '"[ALL]",1,Fields!Company.Value)

The content of the group header should reflect this too.

I chose 'TRUNCATE TABLE' and was told I was wrong, the correct answer is 'TRUNCATE TABLE'...

I don't think the way our lists of parameter values are stored is really the problem for us - where they are stored is more the issue. It's the trip...

You said in an earlier post: 'All of my parameters are refreshed with new values from the database nightly'. So where is your parameter list stored if not on the...

I've often wondered how to do this in SQL - that's a neat solution.

Hmmm... how does this work if the user selects a continent and then expects to get a choice (in the country parameter drop-down) of only those countries in that continent?...

That sounds interesting, Sabrina. How would that work say if I wanted to report on projects across the world and would be choosing continent, country and project from 3 different...

Yes, there doesn't seem to be a way round it for 'cascading parameters'. However you can stop the screen refresh for date parameters, by setting the default value to another...

You need to use a table, not a matrix, and set the number of columns to, say, 3.

... and after all that make sure the user's browser is set to display UK dates (Tools/Options) !