This is an ugly kludge that I'm sure there are better solutions than, but one inelegant way of achieving your #3 is to have a separate matrix/tablix directly below your...

AFAIK, reports rendered as HTML through SSRS are not editable. Perhaps someone can correct me, but the reports I have deployed as HTML have all been functionally just like...

You can do conditional sorting either in SSRS by using an IIF expression in the sorting properties for your Table/Tablix, or in SQL by using case statements in your ORDER...

David's suggestion is how I have always done it. In your WHERE statement you then have something like

WHERE endYear IN (SELECT Param FROM bk_report.dbo.fn_StringSplitter(@endYear, ','))

Then in SSRS make sure...

I got some good tuning tips from this Brent Ozar video:

http://www.brentozar.com/archive/2014/01/watch-brent-tune-queries/

Query tuning is a complex art, but Grant Fritchey's book on execution plans is a good resource to start with. It's available as a free pdf here:

http://www.red-gate.com/community/books/sql-server-execution-plans-ed-2

This might be what you're after:

="For " + Format(Parameters!startdate.Value, "MMMyyyy"

I think you should be able to do this using groups. Each sub-group can have its own columns, and you can toggle their visibility off of the groups above...

I think you have to define parameters for subreports in three places:

1. In the subreport itself

2. In the main report

3. Right-click on the cell in the main report containing the...

I have seen this done by setting the format to #,###,###

Is the parameter being passed to a subreport? If so do you have the parameter defined in the subreport properties on the main report?

I have found a similar thing with opening reports that contain drill-downs in Excel 2010. The error I get on opening is "File error: Data may have been lost."...

You could perhaps try using ReportItems. Have Table A with the results form dataset 1, and Table B with the results from dataset 2. These two tables could...

Duplicate post. See http://www.sqlservercentral.com/Forums/Topic1552884-391-1.aspx

Duplicate post. See http://www.sqlservercentral.com/Forums/Topic1552885-1633-1.aspx