My users have asked that I code a single-click option to run all Bookmarks in a specified Bookmark Organizer Folder to NativeExcel.
I know that I can form the URL to run a report with rdReportFormat=NativeExcel and I can add the LoadBookmark=True&rdBookmarkCollection=...&rdBookmarkID=..., etc. to run the report as it's Bookmark definition directly to Native Excel. However, I can't find any option in the Process Task > RunDataLayerRows to loop through these URLs.
The closest I can get is to use a Response.Report element under RunDataLayerRows with the Bookmark and Excel params as Link Parameters. This only runs the first Bookmark from the RunDataLayerRows, exports the Excel correctly, then spins on the Wait Panel until I close the browser. No second report or third, fourth, etc., no finishing up and hitting the Response.Report outside of RunDataLayerRows.
Any ideas on how to loop through the Bookmarks and run each to NativeExcel, then hit a Response.Report when done?
Please sign in to leave a comment.