sql server reporting services: Excel rendering - Merged cells issue -- sql server reporting services

You're in the

sql server reporting services

group:

Excel rendering - Merged cells issue

Re: Excel rendering - Merged cells issue

Bruce L-C [MVP]
7/26/2005 9:45:48 AM

sql server reporting services: Are you using table or matrix?

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Re: Excel rendering - Merged cells issue

Bruce L-C [MVP]
7/26/2005 10:21:04 AM

OK, here is what I did. Do not have any textboxes above your table. Instead,
add additional header rows. You can merge cells together, put in text and
center so usually I could still get it where it looked similar. For some
reason even though you are merging cells it does it differently when
exporting to Excel. After doing this you will be able to select the data
region and sort the data.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Excel rendering - Merged cells issue

Gastón Pírez
7/26/2005 10:52:04 AM

Hi,
My rendered Excel reports have lot of merged cells (because of the layout I
made in the designer). Therefore when I open it, the excel takes lot of
minutes to open. So the question is: what can I do in order to avoid having
merged cells in the rendered excel file.

TIA,
Gastón.-

PS: I've opened the excel file, unmerged all cells, save, reopen it, and the
problem disapear.

Re: Excel rendering - Merged cells issue

Gastón Pírez
7/26/2005 11:57:07 AM

I'm using table.

Thx,
Gastón.-

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn