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.

 

Marcações:  qbe hoc ibmpa bilog ad v7 analysis data reports qbr