Seems to me you need 2 rows available but sometimes the 'footer' can only allow one row before it starts to overlap the next record.
Here's a suggestion.
Trap the SVC line as the detail line.
Create an append template using the same trap as for the detail and make it a 2 line sample.
In one of the rows paint in the field positions for the YTDREVO field positions, name them appropriately and, for each, indicate that they require a preceding string of YTDREVO before they can be populated.
On the other row paint the field positions for YTDFRQO and set each of those to have a preceding string of YTDFRQO.
I have not yet tried it with V5 but it should work.
I am assuming that only the rows that start with those strings are of interest for your extraction.
I hope this helps.
Hello! I am working on a variable-line trap (seems to be a common problem!). need to end up with a report that shows has the columns "svc cd","description", "Total YTD Revenue" (the ytdrev lines), and "Total YTD Frequency" (the ytdfrq lines), "Blue Cross YTD Revenue", "Blue Cross YTD Frequency", etc.
When I set the 'svc cd' line as my detail, it seems to only let me pull in one line for a footer. When I set the "YTD" lines as detail, it repeats data from the previous line when the "YTDREV" field is blank. Can I get someone with a fresh set of eyes to look at this and recommend how to get the information I need? Thank you so much!
(I do not know if the code below is going to display accurately, I would be glad to email someone a file.)
I am working on Standard V5.0 (yeah, I know). I have convinced my boss to get the new version, but she needs the report now, not later - know what I mean?! =)
SVC CD 401-0395 DESCRIPTION - "Service 1"
YTDREVO A 20.00 20.00 0.00
YTDFRQO A 4 4 0
SVC CD 401-0403 DESCRIPTION - "Service 2"
CURFRQO A 4 0 1
YTDFRQO A 42 11 12
SVC CD 401-0404 DESCRIPTION - "Service 3"
CURREVO A 46.00 23.00 23.00
YTDREVO A 230.00 138.00 46.00
CURFRQO A 2 1 1
YTDFRQO A 10 6 2
SVC CD 401-0435 DESCRIPTION - "Service 4 (no REV, just FRQ)"
YTDFRQO A 1 0 0
[size="1"][ September 09, 2004, 08:14 PM: Message edited by: Grant Perkins ][/size]