RE: How to Create Merged Cells in Reports, Part 2 - Render Output Question

[TurboToad]

Hello, 

  I'm looking for some assistance with a reporting issue on the process outlined in How to Create Merged Cells in Reports, Part 2 by @atcodedog05  . I followed the steps but in my final excel render the header tables don't seem to be aligning properly with the defined columns. The Profiles header should be starting in column H with the other values.

If I render the table data before the layout tool it outputs as expected.

I did notice if I manually adjust the column width in the layout tool it seems to fix the issue. I set the blank column to 45% and the other to 55% and it lines up correctly. I am fairly new to the reporting tools so not sure what I'm missing. I've attached my sample workflow.

Thanks

TurboToad

[grazitti_sapna · Accepted solution]

Hi @TurboToad , The issue is not with the layout tool. You are passing header and data in separate rows to the layout tool. The layout tool will consider both rows differently(one which contains headers from both tables and other with data) and create layout for both rows separately. So you will have to use the table tool again after union and create a single table for each input to layout. I am attaching the updated workflow. If this is what you needed please accept my solution.

Thanks!!

[atcodedog05 · Accepted solution]

Hi @TurboToad 

Interesting scenario ideally it should have worked. Disclaimer reporting tools are a bit moody hence sometimes require experimentation.

If you use a table tool (uncheck show column heading) instead of a layout tool. It will give us the expected output.

Thank you for bringing this up. I will try to update the blog as well.

Hope this helps : )

[TurboToad]

 Thanks @grazitti_sapna and @atcodedog05 for the prompt responses and solutions! @atcodedog05, really appreciate the time and effort putting that blog series together, was very helpful!

[atcodedog05]

@TurboToad 

Glad you found it helpful :)

Happy to help : )

Cheers and have a nice day!

[DarshanaJ]

Thank you so much. Your reponse solved my issue.