Merge Ahead

re: Merge Ahead

JamesAndrewPlant — Thu, 01 Mar 2007 20:42:21 GMT

If you need a title for your report -but that title causes the cursed merge cells problems - then you may try the following work around:

Create a bitmap image that contains the report title. Within BIDS choose the Report menu then Embedded Images. Add your bitmap to the list. Add a header to the report (from the Report menu again). Select the header and set the background image property to Source=Embedded, Value=The name of you embedded image.

The image will display when the report is rendered in the browser but will not appear if you save the results to an Excel spreadsheet.

The 2-for-1 Special in Excel

Strate SQL — Fri, 09 Mar 2007 23:23:54 GMT

It inevitably happens when building SQL Server Reporting Services reports that someone will have desire

re: Merge Ahead

ajkarthik — Tue, 22 May 2007 05:50:01 GMT

I also had similar issues related to merged cells.

Merged cells were present mostly in the regions which is interfering with left and right edges of report items in report header.

So i tried to keep the header into excel header. This can be done by including SimplePageHeaders=true in device info. Another tips is to remove the blank columns by adding RemoveSpace item in device info.

A sample of reconfiguring device info thro Reportserver.config is pasted below.

</DeviceInfo>

</Configuration>

</Extension>

Reporting Frameworks Part 3 ??? using SQL Server 2005 Reporting Services « conservative geek

Wed, 17 Oct 2007 06:34:41 GMT

PingBack from http://conservativgeek.wordpress.com/2007/08/30/reporting-frameworks-part-3-%e2%80%93-using-sql-server-2005-reporting-services/

The 2-for-1 Special in Excel

Strate SQL — Fri, 14 Nov 2008 06:49:39 GMT

It inevitably happens when building SQL Server Reporting Services reports that someone will have desire to export the beautifully created report out of SSRS and into some other format. And sometimes that format just happens to be Excel.*Presto Change-O*And

re: Merge Ahead

kmbimal — Thu, 12 Mar 2009 18:26:41 GMT

If you add the <SimplePageHeaders>true</SimplePageHeaders> the header section will be placed in the header of the excel sheet and the user will see it only when he takes print out or select print preview.

I think the better option is to add multiple header rows in the grid which is shown in the detail section and move the text you want to show in the header section to these rows. You can have merged cells also here and excel wont prevent you from sorting in this case also.

---------

Bimal

re: Merge Ahead

samratbhatnagar — Tue, 09 Jun 2009 09:22:28 GMT

The tips given above really work.

Point 1 is the basis.

Points 2 and 3 are very true. There might be cases when measurements are same but still excel export has merged cells. This problem can be rectified without doing much of the math. Lemme take an example by stating what I did in my reports. The basic elements in my reports were tables(usually two). I had created the tables from scratch. I did all the math and made sure the cell border alignment in the two tables were same. But excel exports still had merged cells issues. Just to mention the merged cells were very small. So instead of creating two different tables from scratch I created a single table and then made a copy of that table. Hence reusing one table.

My Reporting Service Problem In Excel Output - Dedirahman blog

My Reporting Service Problem In Excel Output - Dedirahman blog — Sat, 13 Jun 2009 09:48:46 GMT

PingBack from http://dedirahmansianturi.com/2009/06/13/my-reporting-service-problem-in-excel-output/