Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DaveC11
Starting Member
43 Posts |
 Posted - 2008-07-30 : 05:45:48
|
| I have a report that exports into a excel document on subscription. The problem I'm having is that some of cells have merged on the export making the spreadsheet impossible to use! Is there a way of unmerging these fields on the export?Cheers Dave |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-07-30 : 05:57:11
|
Merged?Can you explain to that even we who donn't have direct access to your excelfiles can understand what you mean with merge?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-30 : 06:32:35
|
quote:
Originally posted by DaveC11
I have a report that exports into a excel document on subscription. The problem I'm having is that some of cells have merged on the export making the spreadsheet impossible to use! Is there a way of unmerging these fields on the export?Cheers Dave
how is the report viewing in report viewer? is column merged there also? |
|
|
|
shilpaa
Starting Member
6 Posts |
Posted - 2008-07-31 : 06:46:13
|
| Hello,To avoid Merging Cells in Excel.Report Definition Language Supports different measurements for the position and size of the cells. But internally the Excel format wants everything to be in points.One inch is 72 points.So Better to use Points(pt) instead of inches(in) for the cell size and Location.Hope this Helps.Shilpa Reddy |
|
|
|
|
|
|
Excel cells merge prob!