You can use Report Builder functions to access functionality without accessing the Report Builder user interface.
For example, to automatically refresh Report Builder requests with input filters based on data pulled into Excel from other sources, use the string RefreshRequestsInCellsRange(…) function. All calls are asynchronous and they return immediately and do not wait to fully execute.
The following table lists the exposed functions.
|AsyncRefreshAll()||string||Refreshes all Report Builder requests present in a workbook.|
|AsyncRefreshRange(string rangeAddressInA1Format)||string||Refreshes all Report Builder requests present in the specified cell range address (a string expression representing a range of cell in A1 format, for example “Sheet1!A2:A10”).|
|AsyncRefreshRangeAltTextParam()||string||Refreshes all Report Builder requests present in the specified cell range that is passed through the Alternative Text of the Ms Form Control.|
|AsyncRefreshActiveWorksheet()||string||Refreshes all Report Builder requests present in the active worksheet.|
|AsyncRefreshWorksheet(string worksheetName)||string||Refreshes all Report Builder requests present in the specified worksheet (the worksheet name as it appears on the tab.)|
|AsyncRefreshWorksheetAltTextParam();||string||Refreshes all Report Builder requests present in the specific worksheet name that was passed through the Alternative Text of the Ms Form Control|
|tring GetLastRunStatus()||string||Returns a string that describes the status of the last run.|
To access the Report Builder functions, go to Formulas > Insert Function. Use the search field to search for a function or select a category to list the functions in that category.
The following example shows If the value in cell P5 is text or is blank, refresh the range that is in cell P9.
You can assign a macro to a control you created and that control can be a function that refreshes a workbook request. For example, the function AsyncRefreshActiveWorksheet will refresh all requests in a worksheet. Sometimes, though, you may want to refresh only certain requests.
Two functions that take a parameter can be used with Format Control. You must use the Alternative text: field:
To pass parameters to Report Builder functions using format control
Right-click the control and select Format Control.
Click the Alt Text tab.
Under Alternative text, enter the cell range that you want refreshed.
Open the list of Report Builder parameters under Formulas > Insert Function> Adobe.ReportBuilder.Bridge.
Pick one of the two functions that end with AltTextParam and click OK.