Formatting Excel / PDF Export RRS feed

  • Question

  • I was hoping to find an easy answer to this question:

    I've designed several reports. In Report Viewer, the fields/cells are set to auto increase in size and height. What my users are having an issue with is when they export the report to Excel or PDF. One of the fields is a DESCRIPTION field that can have an extrmely long character string and can take up anywhere from one to two lines. I looks fine in Report Viewer, but the user has to do a ton of reformatting once the report is exported.

    They would like to have the format of the report to be the same as in Report Viewer.

    I found one possible solution that requires me to save the Excel docment that has the correct formatting as an SSML(?), and then take that "code" and modify the .rdl of the report. Is this the only way?

    Any help would be appreciated!

    A. M. Robinson
    Friday, August 6, 2010 9:10 PM