BiLog: QBE - Extending thru QBRQBE (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
|