Post reply

Excel headers - using SimplePageHeaders deviceinfo setting

  • March 8, 2006 at 6:13 am

    #168002

     I want to try out placing the report header in the Excel page header instead of the worksheet.  I have seen forum references to updating the config files to switch on SimplePageHeaders deviceinfo setting, but I can find no reference to this in the documentation and it appears to be ignored when I try it out.  Is this in RS 2005 only?  (I'm using 2000 SP2).

    Would this get round my current problem of having lots of additional columns/merged cells to accommodate all the header layout when exported to Excel?  Ideally I want the data structure in Excel to be a straight forward matrix of the data values in the report table which isn't feasible when exported to Excel with our default headers which contains a lot of labels containing context information.

  • March 9, 2006 at 5:41 am

    #625631

    You can do this with RS2000 SP2 (I think it was introduced with SP1).  However the only way I found to set this information is to drive the reports from a web page (not using the Reporting services front end to open the report).

  • March 10, 2006 at 5:53 am

    #625912

    Thanks for the response.  I've tried setting the device info in the URL, but it doesn't generate the Excel file at all - when I tcptrace it, it shows a ReportRendering Exception (I think because the xls file didn't get generated.)

    I assume I'm configuring the URL correctly (adding &rc:SimplePageHeaders=True), since passing device info for documented options such as RemoveSpace or OmitFormulas works OK.

    Any suggestions as to what's going wrong?

  • March 10, 2006 at 12:59 pm

    #626081

    I did it using the post headers rather than through the URL.

    The form is constructed of:

    <FORM style="height:0" name="reportform" id="frmRender" action="http://servername/reportserver?/reportname" method="post">

       <INPUT type="hidden" name="rs:Command" value="Render">

       <INPUT type="hidden" name="rc:LinkTarget" value="main">

       <INPUT type="hidden" id="rsFormat" name="rs:Format" value="EXCEL">

       <INPUT type="hidden" name="rcarameters" value="False">

       <INPUT type="hidden" name="rc:SimplePageHeaders" value="True">

       <input type="hidden" name="rcmitFormulas" value="False">

    I hope this helps.

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

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