8. Working with RBF Report Specifications : Archive Operation—Archive a Report Definition : Comment Blocks in Archived Reports : Union Select Comment Block
 
Share this page                  
Union Select Comment Block
The following is an example of a union select comment block:
/*
DO NOT MODIFY. DOING SO MAY CAUSE REPORT TO BE
        UNUSABLE.
*
The union clause is commented out because a selection
criteria on a detail table is specified.
*/
/*
union select poheader.orderno, poheader.orddate,
       poheader.vendorno, poheader.invoiceno,
       poheader.status,'' as partno,' ' as qty,
       ' ' as unit_pr,' ' as unit_pr, ' ' as det_tot
       from poheader poheader where not exists(select *
       from podettot podettot podettot.orderno '$det_tot'))
*/
RBF generates the union select comment block for Master/Detail JoinDef reports that have a selection criteria on a column in a detail table. You must not modify or delete this comment block.