General information
Category:
Reports & Report designer
Todd,
GenRepoX works by calling the GenRepoX driver as follows:
do genrepox with "report form myreport.frx"
... where myreport.frx is the FoxPro report that has been created using the FoxPro report editor.
You can put GenRepox directives in the comment snippet of a field in the FRX. So, getting back to the example I mentioned in my previous message, I could put the following directives in the snippet of the "profit" field:
*:IF_COLOR PROFIT > 0.00 AND PROFIT <= 300.00 COLOR RGB(0,0,255,0,255,0) Font "Arial",8 STYLE "B"
*:IF_COLOR PROFIT > 300.00 COLOR RGB(0,255,0,255,255,255) Font "Arial",8 STYLE "B"
*:IF_COLOR PROFIT <= 0.00 COLOR RGB(255,0,0,255,255,255) Font "Arial",8 STYLE "BI"
"PROFIT" is the expression of the field in the FRX.
This example actually comes from a report the first runs a SQL statement:
SELECT ALL;
CARS.MAKE,;
CARS.MODEL,;
CARS.MILEAGE,;
CARS.SALEPR - CARS.PURCHPR AS PROFIT
FROM "CARS" CARS;
INTO CURSOR GRX1;
WHERE (Cars.Saledt<>CTOD("");
AND Cars.Make+Cars.Model<>"FORD");
ORDER BY 1, 4
... after this SQL is run, and the cursor GRX1 is populated, then the GenRepoX program can be run as stated above.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only