Parallel Summary
What is parallel summary
At times users want to see the same report in multiple fashion, just below the same report They may like to print the details optionally in the same report. They don’t want to fire the different report for the same report. So the solution is to create parallel summary which involves increasing the number of rprt_sends for each detail line with some of extra sort field of higher order with some specific sort field values only, copying the same after.field layout with new report layout sequence and assigning print conditions wrt its highest sort fields. An example will illustrate this clearly .
Example
Problem
Originally the following report (Screen 1) did not contain the 1st sort field sumflag . The next 3 sort fields metc , ststr and mtstr were present only as input variable and not as sort fields .
Users wanted summaries for each of sort field (viz 2,3,and 4 ) at the end of the report and optionally the details (which is what the original report is ) .Screen 1
Solution
The solution to this was following.1. We introduced a sort field of highest order sumflag as can be seen above in screen 1.
2. We created further sort fields for metc , ststr and mtstr and assigned them sort order higher than the ones for the prevailing sort fields as can be seen in screen 1.
3. For each of summary sort fields ( viz metc , ststr and mtstr ) , separate after field and or before field layouts were created and a separate sumflag value was assigned to them in order to be able to use in the print condition for respective layouts . (Screen 2 & 3 ) .
4. In the program script , increase rprt_send for each sort field with respective sort field only and other higher sort field set to 0 or “” (except highest sort field sumflag) . Highest sort field should be set to the value used in the print condition for the respective summaries.
Screen 2
Conclusion
This kind of programming definitely accomplishes the user requirements. But it definitely slows down the programming due to multiplicity of rprt_sends. Lot of disk IO increases.
It is here that QSS functions and performance dll helps user to increase the speed of the report substantially .
In this kind of report, code generator has to be used for each parallel summary ie 3 times in the example above.
FastTrack to ERPJEWELS :
Latest Trend | Hot Links | Jewels of ERPJewels | Jewels of Baan | Jewels of Excel