08-23-2024 06:17 AM
Hey there,
We have created a BI Viewer and we want to extract the BI viewer to excel but through a button in a different dashboard. Is there way to get the data in the Bi Viewer through a Business Rule, create an excel workbook and save it to File Explorer>Application Database>users>(userName) ?
I know how to create a workbook from a dataTable or a dataset in the BR and save it, but I am having a hard time getting data from the Bi Viewer to the business rule.
Thanks
08-23-2024 07:12 AM
BiViewer is meant to display data, but in itself it doesn't contain anything. The data will come from the Data Adapter (s) attached to the BiViewer component. You can execute the adapter directly in a business rule, search the object helper tree for "ADO" methods and you'll find what you need.