Skip to Content
0
Former Member
Aug 21, 2008 at 02:59 PM

How to dynamic break to different tabs in one report based on the category

13 Views

I have one report, it contains summary, and bunch of detail based on different criteria. Have Excel row limitation to save as excel file for one of the Sales Detail tab. The user wants to break down by each category desc to display each tabs. Currently, there are 11 category des in my co. I can use the add quick filter to each tab, but itu2019s a menu process since one day I could have 10 category in the summary, and the other have 12. And whenever we add the new category, then I have to add one tab also. Is there a more dynamic way to do this? Thanks in advance!