Edit Word tip for AS400 QRY

I had a user call me this early Monday morning with a request. He needed some subtotals on a query he was running. So I copied it to my library and started to work.

The first error I noticed was a "Edit word for T01.CURVAL total was not specified." So that meant we had a problem in the Report Column Formatting. A problem within the T01.CURVAL specification. The option set was 4 i.e. Edit word. It was set like this:

Edit word . . . . . ' , , 0 . -'
Edit word for
summary total . .

Nothing was set for the summary total. This was the first thing to fix. Every time I tried to set it I got a "Edit word does not match length for total summary function" error. Finally the ever helpful F1 function saved the day. It turns out that the length of a total field is 3 digits longer than the numeric field. Once I knew that it was simple.

He also wasn't getting the subtotals he wanted. His city report break was set to level "2", but hadn't set or formatted the level "2" break.

A couple of fairly easy things. I was just able to see them cause I was taking a quick look. I had fresh eyes, he had probably been working on it a while. Sometimes it just takes a fresh perspective.