problem export to excel

  • Hi all,

    I'd like to export to excel from reporting services because I want to use excel's freeze pane for this very wide report.  User can continue to see key information while scroll to the right of the report.

    I found out after I export to excel, one of the textbox (that is inside of a rectangle which resides at the first row of a matrix) got into the next row all by itself.  I have tried to narrow the adjacent textbox, it seems working.  But then another textbox behaved the same way - move to the next row all by itself.

    There's nothing strange if view from the browser.  So I guess my question is does reproting services provide freeze pane functions?  If not, how do I make each textbox align to the matrix's field (or grid) to avoid the strange behavior?

    Tahnk you very much for your help,

  • This was removed by the editor as SPAM

  • I finally got it fixed. To work around, I have to make the textbox smaller (acts like header) than the column width and make the rectangle borderstyle solid to get rid of the problem.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply