Tech Trek Log – 2010.01.31
Here’s a re-post of an issue I’ve encountered while working on SQL Server Reporting Services when exporting a report into Excel.
The key points in the blog are:
- Sorting will not be possible when merged cells exist
- Alignment of header/footer with the data elements resolves the issue
The additional tip I can add when using SQL Business Intelligence (BI) Development Studio is specifying textbox sizes in quarter units so that it will be easier to align elements in the RDL file.
Source: MSDN Blog – Merge Ahead