all groups > sql server reporting services > november 2004 >
You're in the

sql server reporting services

group:

Exporting to Excel Tips



Exporting to Excel Tips Yoshi
11/8/2004 10:20:41 PM
sql server reporting services: Hi !

I am exporting a report to Excel. I have this issue where my labels that
are to the left of my data columns are exported to different rows.

Is there anyone out there can give me some tips or lessons learned when
designing a report that will be exported to Excel?

Thanks,

Y

RE: Exporting to Excel Tips sebring1130
11/9/2004 10:10:02 AM
I am having a similar problem. I am not using the column headings of the
grid because I need the column headings up in the page header. Instead I
created a row of textboxes that line up with the datagrid up in the header.
It looks great in pdf and html, but as soon as I export to excel some of the
textboxes get pushed down into a lower row. I haven't figured out why yet,
but I think it has something to do with merged cells in excel. If I find
anything I'll post it here.

sebring1130



[quoted text, click to view]
Re: Exporting to Excel Tips Yoshi
11/9/2004 12:16:49 PM
Thanks. I will do the same. Glad to know there are others working on the
same issue.

Take care,

Y

[quoted text, click to view]

AddThis Social Bookmark Button