Re: Need some help with a report

["Booth Martin" <booth@xxxxxxxxxxxx>]

You have a line where you turn on Indicator 99.  I might try commenting that
line and see what happens.   

There are other issues though.  I had trouble reading the code because my
e-mail program folded the lines, so nothing lines up.

  In similar situations in the past I have been known to comment out all the
lines, then uncomment small sections at a time until it does something I
like, or don't like.  That seems to focus the problem quickly.
 
---------------------------------
Booth Martin
http://www.martinvt.com
---------------------------------
-------Original Message-------
 
From: RPG programming on the AS400 / iSeries
Date: 05/12/05 15:57:22
To: rpg400-l@xxxxxxxxxxxx
Subject: Need some help with a report
 
I have been moving along in my feeble attempt to gain as much rpg knowledge
as I can get, however I have a report that I need to produce that has been
giving me fits for four days and if anyone can provide any assistance I
would appreciate it.
 
I will post the source below.  I have a logical file which contains branch
(location) id, customer number, stock numbers, and each record is equivalent
to one line item from our sales.  It is keyed by ilninv#a (location id),
ilnsoldto (customer number) and ilnstk (stock number), it also has a range
restriction on it for line items related to this fiscal year.  I am
attempting to print out one detail line with the sum of sales and costs for
each stock number and customer number, with a page break when the location
id changes.
 
So far, every time I run the report it spits out over a 1,000 pages and has
produced as many as 89,000 pages....it appears to keep printing the same
header file over and over again.....
 
Any help, pointers or suggestions would be appreciated.
 
Douglas