Export Band at Runtime

[hminot]

Is there any way to specify (or override) the report band you which to be exported to an Excel Xls file at runtime? My report works fine when I run it interactively and specify, for instance, a level 2 footer export. I wish to run it unattended and thus will not be able to respond to the export dialog box. When I attempted to run unattended, the detail line of the report was the source of the data being exported to the Excel Spreadsheet file. I see no way, or am unaware, of specifying via a RI_* parameter at runtime the band level to be exported. My report was saved with the specific footer that I want to be exported, but the detail line was exported instead.____Thank you.____Harvey Minot

[kfleming]

You need to open the report in the designer, select the export band line and the save the report. That saved band type will then be the one that gets exported.____Kathleen__R&R Support

[hminot]

Thank you for your response. I found my problem was that I specified __RI_PRINTER=X instead of RI_PRINTER=W. When I specified the later, The exported spreadsheet was based on the saved footer band, whick is what I required. When I specified RI_PRINTER=X, the exported file was really a DBF, even though I named it with a suffix of XLS. This exported file consisted of detail lines, and not the footer band which I saved as a spreadsheet export.