Automatically generate sheets with tree in Report Designer Add-in

I know this question has been raised many times, and seem to recall that there is an enhancement coming to do this.  Could someone please confirm that it's a feature that will be added soon?  And if so, how soon?   As a Sage 500 partner, I know it will come later than for 100/300.   So I hope folks in the 100/300 world can tell me if this feature is coming and when.

Current tree functionality in RDA -

1. Build a report template

2. Copy that sheet, then drag and drop another tree unit to it

3. Repeat until you have all the tree units covered.

Problems with this -

1. Very tedious if you have many units on the tree (many of our clients have hundreds)

2. Performance hits when you have a huge workbook with hundreds of tabs

3. Inflexibility if you need to modify the template layout or add a tree unit in the middle

Ideal Solution that I am hoping/dreaming will be added soon

A function/macro/add-in to automatically generate sheets based on the template and tree selection.    With this, one will never have to do steps 2 and 3 above.   Instead, they will build and maintain the template, then have SI automatically generate copies of that template for different reporting units.   Essentially, how FRx works.   Can SI get to that point?

Thanks!

Parents
  • 0

    Strange - I just tested again on the latest version of SI available for Sage 500 (Core version 7.50, Metabase version 6.9.4) and was also unable to duplicate my success 3 years ago.The Generate Output File option will only output the first worksheet tab to PDF, not the entire book... Now I am curious why I thought it had worked.

    Anyway, would appreciate your solution as well, Peter.  Thanks as always!

Reply
  • 0

    Strange - I just tested again on the latest version of SI available for Sage 500 (Core version 7.50, Metabase version 6.9.4) and was also unable to duplicate my success 3 years ago.The Generate Output File option will only output the first worksheet tab to PDF, not the entire book... Now I am curious why I thought it had worked.

    Anyway, would appreciate your solution as well, Peter.  Thanks as always!

Children
No Data