Reporting tool customize the sheet order

[vijaylnyadav]

Hi,

I am using layout and render tool in my workflow and the output i am getting is the at the order of the sheets is in alphabetical order so can we customize the order of sheets.

can we get any solution for this.

[SeanAdams]

If the sheets are always going to be consistent - you could set up the format before-hand on some pre-formatted sheets and then write into a hidden sheet which is used almost like a data store.

You then populate the formatted sheet using pre-defined formula / references.

I know its a long way round - but @MarqueeCrew has been able to do some pretty awesome reporting using this exact method.

[aihnen]

First create a text input tool with the correct numbered order. Then join by position to the layout tool output. Then use a sort tool and sort by the correct order finally putting a render tool after. Then it writes using the correct order that you manually sorted to after the layout.