My client has 6 lines in the center header section of his MR reports. The problem is when exporting a group of reports that have been generated to excel. If we use the option to include the header lines in the header section of Excel, it does not pull in all 6 lines. If we change to the option to include the header lines in the Excel worksheet body, all six lines come in, but when printing or saving to a pdf, there are no header lines on pages 2 through xx.
*This post is locked for comments
Mike, I tested having 6 lines in the report header, and in Report Viewer I see all 6 (just as in your browser screen shot), but when I exported it to Excel, only the top 5 lines show.
I found a workaround, but it is NOT dynamic, and you would probably have to play with it to get it "just right" for your needs.
Anyway here goes: I copied the 5 header lines to a blank worksheet, and added the 6th line below. Next, I centered the text in the column, and then turned off the gridlines. (View > Show > Gridlines).
Then I took a screen shot of the text & saved it as an image. (I used .bmp, but MR also supports .jpg & .png)
Next, delete all of the lines in the 'Second section' of the headers, then click in the first line of the second section & then click on the Images button (to the right of the 'Insert Auto Text' button) and select your image.
Two things I found when doing this:
1) In Report Viewer the header looks perfect, but when I exported it to Excel the image was very narrow.
2) You can only enter Text or an Image in one header section, not both.
The second point is important, because as I mentioned earlier, an image isn't dynamic, and at least from what I can see, you have the report date in the 6th line.
My suggestion would be to maybe abbreviate some of the text & try to combine two lines into one.
Or if possible put one of the lines in one of the other header (or footer) sections, if it make sense to present it that way.
P.S. FWIW I tested in Excel & was able to enter eleven header lines. (I stopped at eleven because, well who needs THAT many, and I like Stranger Things!)
I'd like to hear how you decide to move forward with this limitation.
Top snip is the browser with 6 lines of header. Bottom snip is Excel with only 5 lines of the header. I expanded the top margin to 1.25 inches. Is it limited to only 5 lines when exporting to Excel.
Hi Mike,
I would try changing the margins in MR to see if that helps.
Open the report & Go To Settings > Other
Then change the Top Margin
Let us know if this works.
#1
André Arnaud de Cal...
292,468
Super User 2025 Season 1
#2
Martin Dráb
231,289
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
