2 Replies Latest reply on Jun 1, 2016 12:00 PM by laguna92651

    Navigate Summary Report With Script


      I have a To Do list that is broken up by categories (Buy, Call, Email etc.), using a summary report. I would  like to set up a popover or dropdown (I would probably prefer a dropdown) on the report header to navigate to the various category sections of the summary report. The Go To functions don't seem to be applicable to this, any ideas on how to go about this? Thanks

        • 1. Re: Navigate Summary Report With Script

          Are you ever printing this "report" out? If not, then why not just have the script find for the category you want from the dropdown. That way you're not navigating at all.


          Since subsummaries do not exist in browse/preview until a layout is sorted, they're not really addressable by script.


          What you would need to do is a simple loop script that goes to records until you reach a record that matches what you're looking for. then stop.



          Set Variable [ $cat ; Table::globalCategorySelection ]

          Go To Record/Request/Page [ first ]


             Exit Loop If [ Table::Category = $cat ]

             Go To Record/Request/Page [ next ; exit after last ]

          End Loop

          • 2. Re: Navigate Summary Report With Script

            Boy, that was fast. The loop worked great, thanks. I used a Record/Request/Page [Next] after the End Loop to move the list up, is there a more elegant way to move the list up instead of adding a bunch of Record/Request/Page [Next]'s at the end of the script.