BiLog: QBE - Extending thru QBR
PamDenny 270000BXV7 Visits (5692)
QBE (Query by Example), also known as Data Download, is an excellent way for you to quickly take the results of your application query and/or filters and export them to Microsoft Excel. You can then view each of the list tab fields, and perform additional analysis, combine the data with other queries, print, or save.
However, often your users want to see additional fields in the exported data. And the fields that one user may want to see are not the same as fields another user may want to see. You can modify the list of fields that displays with the Application Designer. However, this involves resources, planning, and space limitations.
You can provide your users the ability to
Apply application filter and/or query
Select their unique fields or database attributes
Define sorting, grouping, filters and parameters
Directly Download to Microsoft Excel
Without Application Designer Modifications
thru QBR (Query Based Reporting). QBR is available from essentially any application, and provides powerful, flexible ad hoc reporting capability as shown in the sample below.
With QBR report creation process, you can quickly export your report results directly to Microsoft Excel with a few simple clicks. Additionally, you can choose whether to execute your report a single time – and discard it – or to save your QBR report and execute it regularly in the future. You can also schedule the QBR so the results appear in your email inbox – along with others - on a preconfigured time period.
You can find more details on the QBR functionality, including more details on its use and how to extend for your unique environment, at this url.
Additional detailed information, including screenshots, can be found in the reference materials referenced in this url