RE: Difference bet. Primary and Full procedural file.

["Mangavalli, Ramanujam" <RamM@xxxxxxxxxxx>]

Lets say I want to print Unit of measure totals for each UOM under a product
level break. Example:

Product|Bin |Warehouse|.... Quantity|UOM|.....
xyz    |AA1 |  T1     |      125.00 |LB |.....
xyz    |AB1 |  T2     |      100.00 |EA |......
xyz    |AB2 |  T2     |       10.00 |BX |......

Totals For Product xyz in Std. UOM EA-Each   99999.99
                     EA-Each        100.00
                 LB-Pounds      125.00
                 BX-Boxes        10.00
When I get a product level break, I am supposed to show the product totals
and the UOM for that product totals... Do I make any sense?

I tried using the cycle and could not get it to work. I finally used
multiple occurrence Data Structures. But as Doug suggested, I should have
tried using the same Lx indicator for those fields. But I used SQL to do
this and turned out to be pretty easy.

The other case was when the user wanted to see a summary by say account
number at the end. This report had more than 9 level breaks. Tried to
convince them that they don't need it but being a consultant was tough
especially when you work for the person who signs your check. :-)

Another example that I had to deal with was when the user wanted to pick and
choose control breaks and sorting. With SQL dealing with the "pick and
choose" was far more easier than doing it in the cycle.

-----Original Message-----
From: Richard B Baird [mailto:rbaird@esourceconsulting.com]
Sent: Wednesday, May 22, 2002 4:32 PM
To: rpg400-l@midrange.com
Subject: RE: Difference bet. Primary and Full procedural file.


Ramanujam,

I'm confused.  describe what you mean by a control break within a control
break, and tell me how using L2 for the 1st, and L1 for the break within
the break wouldn't work?

Rick


---original message---
Ramanujam said:
Thanks for the reply Doug. I have had just 1 program that required more
than
10 levels.

Actually, one of the reports that I was working on has to have a control
break within a control break. I wanted to use the cycle logic for this one
but I guess I cannot. I used SQL Unions to get both detail and summary
lines
in the same result set and the stuff came out pretty good.
Thanks for the help though.


_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.