Hello, I have the following code in my report.

SET ASNAMES = ON

TABLE FILE VUSER_ROUTING_CODES_AND_LIMITS
PRINT
VUSER_ROUTING_CODES_AND_LIMITS.VUSER_ROUTING_CODES_AND_LIMITS.TO_USER
VUSER_ROUTING_CODES_AND_LIMITS.VUSER_ROUTING_CODES_AND_LIMITS.JOB_GROUP
VUSER_ROUTING_CODES_AND_LIMITS.VUSER_ROUTING_CODES_AND_LIMITS.DOLLAR_LIMIT
BY VUSER_ROUTING_CODES_AND_LIMITS.VUSER_ROUTING_CODES_AND_LIMITS.JOB_GROUP NOPRINT
BY VUSER_ROUTING_CODES_AND_LIMITS.VUSER_ROUTING_CODES_AND_LIMITS.DOLLAR_LIMIT NOPRINT
WHERE DOLLAR_LIMIT NOT LIKE '-%';
ON TABLE HOLD AS LIMIT
END

TABLE FILE LIMIT
SUM MAX.JOB_GROUP AS 'JOB_GROUP'
TO_USER AS 'USER'
DOLLAR_LIMIT 
BY JOB_GROUP NOPRINT
ON TABLE HOLD AS LIMIT2
END
 
TABLE FILE VUSER_ROUTING_CODES_AND_LIMITS
PRINT
JOB_GROUP
FROM_USER AS 'USER'
DOLLAR_LIMIT 
BY JOB_GROUP NOPRINT
WHERE DOLLAR_LIMIT NOT LIKE '-%';
ON TABLE HOLD AS LIMIT3
END

MATCH FILE LIMIT3
PRINT
USER
DOLLAR_LIMIT
BY JOB_GROUP
RUN

FILE LIMIT2
PRINT
USER
DOLLAR_LIMIT
BY JOB_GROUP 

AFTER MATCH HOLD OLD-OR-NEW
END

When I print the report, it lists the records to the sides but I want to list the record to the bottom. For example.

Currently with the code using above I get the data as follows:

JOB_GROUP USER DOLLAR_LIMIT USER DOLLAR_LIMIT

0001872 MVOGT 250000 MOOREKM 250000
0001872 TMALINAR 10000 . .
0001872 SGILLS 0 . .

I need to print the records as follows:

JOB_GROUP USER DOLLAR_LIMIT

0001872 MVOGT 250000
0001872 TMALINAR 10000
0001872 SGILLS 0
0001872 MOOREKM 250000


How can I do it?

Thanks

This message has been edited. Last edited by: kpiracha,

hi,

Instead of MATCH or JOIN try using the USE command for focus files or APPEND for ALPHA files...you can achieve what you are looking to do...


thanks
Sashanka

Assuming FROM_USER and TO_USER have identical formats, universal catenation ("MORE") is a simple solution:

TABLE FILE LIMIT3
PRINT
DOLLAR_LIMIT
BY JOB_GROUP
BY USER
ON TABLE HOLD
MORE
FILE LIMIT2
END

Yes.
I missed that. lot more simpler.

thanks
Sashanka

you guys are just amazing....thanks a bunch.

Using MORE fixed the issue.