Render Warning when adding footer - Warning: Render (125): Horizontal Rules cannot be plac

Question

HI All, I am getting the below error when i add a footer before the render tool to output into excel.

Warning: Render (125): Horizontal Rules cannot be placed into Excel Headers or Footers.
Warning: Render (125): Text color other than black in Headers or Footers for Excel 2007 or later is not currently supported.

I have attached screenshots of the footer and render tool configurations. I have a vertical toollayout to footer to render tool.

Not sure why i am getting the error.

geraldo · Answer

@SR

I made an example. But even in the render tool it worked correctly. I believe due to the complexity of your report and the configuration for the render tool, this error may be occurring

reportrender.yxzp

SR · Answer

do you have a exmaple of how you did that.

geraldo · Answer

@SR

I put my header and footer as tools and I do the table tool and I put a multiple join by position and in the layout tool I do the vertical break
I've never used the footer in the render tool.