I noticed that a handful of users have been asking through our Hotline that they would like to be able to output to Excel, but also include the Record Selection Summary box at the top of the report. In their cases, it is quite helpful for them to be able to not only see the output, but also see the Record Selections that made those results.
As you may have realized, by default the record selection box is hidden. For most uses, the output table in the Excel report was all that was needed. However, if you find yourself in a spot where the Record Selection Summary box is needed in your Excel report, do the following:
- Open m-Painter and navigate to the Source code.
- Find this line “<!– Begin Error Message –>” and cut it.
- Paste the line directly above this line “<!– Begin Run Time Selection Table –>”
When complete your snippet of HTML code should look like this:
…..
<!– Begin Error Message –>
<!– Begin Run Time Selection Table –>
…..
When a report is generated to Excel m-Power looks for the <!– Begin Error Message –> line, and in an effort to keep the Excel file concise, will remove all code above this line at run-time. By moving this line up in your code, you are essentially including a portion of code (The record selection output) that would have otherwise been removed since it was originally above the <!– Begin Error Message –> line.
In summary
Originally, the Begin Error Message line occurs after the portion of code that lists your selections, thus making your Run Time selections not print to the Excel report.
After the change, the Begin Error Message line will occur before the portion of code that lists your selections, thus making your selections print to the Excel report.
<!– Begin Error Message –>