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 |
|
arputham_thi@yahoo.co.in
Starting Member
2 Posts |
 Posted - 2008-02-07 : 01:35:04
|
| Hello, I am new to this sql server reporting server technology. I have a requirement like the table header should repeat in all pages of the exported excel's print preview. So I have created the header columns with fixed lenths as same as table's header in the page header of the report. Then only the Header will repeat in all pages of the print preview. But the problem is when doing like this, many of the columns have been merged together. The report layout is ok. But cant sort the data. It says a message "This operation requires the merged cells to be identically sized." In some forms i have found the header control's edges need to be sized identically with the tables' columns edges. I did it. But still the columns are merged when exporting. Please help me out from this.Thanks in advance.Arputharaj.D |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-07 : 01:50:05
|
| I dont think you need to merge header rows for repeating them in each page.You just need to enable 'Repeat header rows on each page' property |
 |
|
|
arputham_thi@yahoo.co.in
Starting Member
2 Posts |
Posted - 2008-02-07 : 05:42:02
|
| when enabling repeat header, its worked fine in pdf but not in excel print preview. thats why i have moved the table header to the page header.Thanks,ArputharajArputharaj.D |
|
|
|
shilpaa
Starting Member
6 Posts |
Posted - 2008-07-25 : 02:05:28
|
| Hello,To avoid merging in excel sheets, give the Textbox sizes and Locations Exactly.i.e If the textbox width is 1in then give the next TextBox location as 1in and then for the Next Textbox, 2in in this manner, Only in this way you can avoid merging the cells in ExcelShilpa Reddy |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-25 : 11:03:12
|
quote:
Originally posted by shilpaa
Hello,To avoid merging in excel sheets, give the Textbox sizes and Locations Exactly.i.e If the textbox width is 1in then give the next TextBox location as 1in and then for the Next Textbox, 2in in this manner, Only in this way you can avoid merging the cells in ExcelShilpa Reddy
even in that case, the textboxes while exported to excel wont grow like they do in reports so that if some lengthy data comes they would still wrap in excel. |
|
|
|
|
|
|
|
|
cant Sort data in exported excel file from sql ser