Information générale
Catégorie:
Gestionnaire de rapports & Rapports
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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement