COMBINE THE TABLE OUTPUT AND EXCEL OUTPUT IN ONE FILE BUT DIFFERENT TAB

[RD32XU]

Can anyone help me with my challenge? I'm hoping there's a way to combine the output of Render (excel format) and Output data (excel format) in one file but different tab? Appreciate all your suggestions. Thank you.

I attached my sample use case for reference. 

[kelly_gilbert]

@RD32XU  - the easiest solution would be to convert your 2nd dataset to a table as well. Then, both datasets will be report objects, and you can output both using a Render tool.

If there is a reason why you can't convert that 2nd dataset to a table, please let us know.

This post from @Jonathan-Sherman explains the details of how to set up the Layout and Render tools to output to separate sheets.