SET ASNAMES = ON
SET HOLDLIST=PRINTONLY

DEFINE FILE VUSER_ROUTING_CODES_AND_LIMITS
NEWDOLLARLIMIT/P20 = EDIT(DOLLAR_LIMIT)
END

TABLE FILE VUSER_ROUTING_CODES_AND_LIMITS
PRINT
VUSER_ROUTING_CODES_AND_LIMITS.VUSER_ROUTING_CODES_AND_LIMITS.TO_USER AS 'USER'
VUSER_ROUTING_CODES_AND_LIMITS.VUSER_ROUTING_CODES_AND_LIMITS.JOB_GROUP
VUSER_ROUTING_CODES_AND_LIMITS.VUSER_ROUTING_CODES_AND_LIMITS.NEWDOLLARLIMIT
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.NEWDOLLARLIMIT NOPRINT
ON TABLE HOLD AS LIMIT FORMAT FOCUS
END

TABLE FILE LIMIT
SUM MAX.JOB_GROUP AS 'JOB_GROUP'
USER
COMPUTE NEWDOLLAR/A16='>'||NEWDOLLARLIMIT; AS 'DOLLAR_LIMIT'
BY JOB_GROUP NOPRINT
END  

quote:

What am I doing wrong.

quote:

Originally posted by kpiracha:
Hello, I have the following code in my report.

SET ASNAMES = ON
SET HOLDLIST=PRINTONLY

DEFINE FILE VUSER_ROUTING_CODES_AND_LIMITS
NEWDOLLARLIMIT/P20 = EDIT(DOLLAR_LIMIT)
END

TABLE FILE VUSER_ROUTING_CODES_AND_LIMITS
PRINT
VUSER_ROUTING_CODES_AND_LIMITS.VUSER_ROUTING_CODES_AND_LIMITS.TO_USER AS 'USER'
VUSER_ROUTING_CODES_AND_LIMITS.VUSER_ROUTING_CODES_AND_LIMITS.JOB_GROUP
VUSER_ROUTING_CODES_AND_LIMITS.VUSER_ROUTING_CODES_AND_LIMITS.NEWDOLLARLIMIT
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.NEWDOLLARLIMIT NOPRINT
ON TABLE HOLD AS LIMIT FORMAT FOCUS
END

TABLE FILE LIMIT
SUM MAX.JOB_GROUP AS 'JOB_GROUP'
USER
COMPUTE NEWDOLLAR/A16='>'||NEWDOLLARLIMIT; AS 'DOLLAR_LIMIT'
BY JOB_GROUP NOPRINT
END  

When I run this code I get the following error:


(FOC280) COMPARISON BETWEEN COMPUTATIONAL AND ALPHA VALUES IS NOT ALLOWED

If I comment the line

COMPUTE NEWDOLLAR/A16='>'||NEWDOLLARLIMIT; AS 'DOLLAR_LIMIT'

I don't get any errors. I need that line so that I can insert the > sign in front of the dollar limit.

What am I doing wrong.

Also the reason I have the DEFINE field 'NEWDOLLARLIMIT/P20 = EDIT(DOLLAR_LIMIT) so that the sorting are based on dollar amount low to high. Without it the sorting was not working.

Please help.

 DEFINE FILE CAR
NCOST/A17 = FTOA(RETAIL_COST,'(D7)','A17') ;
ALPHA_COST/A20 = '> ' || NCOST ;
END
TABLE FILE CAR
SUM ALPHA_COST AS 'RETAIL,COST'
    MODEL
BY HIGHEST RETAIL_COST NOPRINT
END 

quote:

There is really only one way to learn how to do something and that is to do it.

quote:

Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.