quote:

Originally posted by susannah:
rob,
the manual
"developing reporting applications".
Your caster job would create a database, a .foc file, at night.
your users would execute fexes you have written to read that database.
Have you had any training at all?

  

TABLE FILE CAR
SUM
	CAR          
	MODEL        
	BODYTYPE     
	SEATS		 
	DEALER_COST	 
	LENGTH		 
	WIDTH		 
	HEIGHT		 
	WEIGHT		 
	WHEELBASE	 
	FUEL_CAP	AS 'Fuel Capacity: '
   COMPUTE PROFIT/P10.2C = RETAIL_COST - DEALER_COST;
BY CAR NOPRINT
  ON TABLE HOLD AS CAR_DATA
END
-EXIT

-* Program to hold the data.
APP HOLD C758760
TABLE FILE CAR
PRINT SALES DEALER_COST RETAIL_COST
BY COUNTRY
BY CAR 
BY MODEL
ON TABLE HOLD AS CARHOLD FORMAT ALPHA
END

APP PREPENDPATH C758760
APP FI CARHOLD DISK C758760/carhold.ftm
TABLE FILE CARHOLD
SUM SALES DEALER_COST RETAIL_COST
BY COUNTRY
END

quote:

I have a large data source and what I want to do is set up a report caster job to execute a query nightly to run a report for open purchase orders meeting certain criteria and have it store/hold the file somewhere on the server.

quote:

Originally posted by PBrightwell:
Are these JD Edwards tables?

quote:

Oh don't even get me started on my JD Edwards woes! = )

quote:

Originally posted by GinnyJakes:
But back to your problem. You didn't post your first program. Here is an example using the CAR file. Please note that the string 'c758760' is a directory name on my server under the ibi/apps for the reporting server.

-* Program to hold the data.
APP HOLD C758760
TABLE FILE CAR
PRINT SALES DEALER_COST RETAIL_COST
BY COUNTRY
BY CAR 
BY MODEL
ON TABLE HOLD AS CARHOLD FORMAT ALPHA
END

Now here is a program that uses the held data:

APP PREPENDPATH C758760
APP FI CARHOLD DISK C758760/carhold.ftm
TABLE FILE CARHOLD
SUM SALES DEALER_COST RETAIL_COST
BY COUNTRY
END

I am on a UNIX platform so my slashes go the other way. But if you take my examples and change the c758760 to a directory in your installation, you should be able to see the .mas and .ftm that are created.

Let me know how you do with this example.

APP PREPENDPATH PDOFIN
APP FILE FMANAGERSPODATAHOLD DISK PDOFIN/FMANAGERSPODATAHOLD.ftm

APP HOLD pdofin
TABLE FILE T_PROD_PO
PRINT
     PO_AGE AS 'PO AGE (Days)'
     PONUM AS 'PO NUMBER'
     TOTALCOST/P12.2C AS 'OPEN PO,$ AMONT'
BY REGION
BY BSTGROUP
BY DIST
WHERE ( T_PROD_PO.STATUS NE 'CAN' ) AND (( GLDEBITACCT LIKE '4604600%' ) OR ( GLDEBITACCT CONTAINS '657004' OR '657006' OR '657007' OR '650124' OR '637000' OR '657008' OR '657009' OR '650132' OR '650130' OR '657011' OR '662000' OR '078000' OR '656000' OR '657001' OR '657003' OR '657010' OR '657020' OR '657030' OR '657040' OR '657050' OR '657000' )) AND (( ORDERDATE GE DT(2007-01-01 00:00:00) ) AND ( RECEIPTS EQ 'NONE' )) AND (( T_PROD_WORKORDER.STATUS NE 'CAN' OR 'CLOSE' ) AND ( T_PROD_PO.TOTALCOST NE .00 ));
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS FMANAGERSPODATAHOLD FORMAT ALPHA

quote:

Originally posted by Rob M.:

quote:

Originally posted by GinnyJakes:
But back to your problem. You didn't post your first program. Here is an example using the CAR file. Please note that the string 'c758760' is a directory name on my server under the ibi/apps for the reporting server.

-* Program to hold the data.
APP HOLD C758760
TABLE FILE CAR
PRINT SALES DEALER_COST RETAIL_COST
BY COUNTRY
BY CAR 
BY MODEL
ON TABLE HOLD AS CARHOLD FORMAT ALPHA
END

Now here is a program that uses the held data:

APP PREPENDPATH C758760
APP FI CARHOLD DISK C758760/carhold.ftm
TABLE FILE CARHOLD
SUM SALES DEALER_COST RETAIL_COST
BY COUNTRY
END

I am on a UNIX platform so my slashes go the other way. But if you take my examples and change the c758760 to a directory in your installation, you should be able to see the .mas and .ftm that are created.

Let me know how you do with this example.

Ok Ginny,

Here is what I put in my second file....

APP PREPENDPATH PDOFIN
APP FILE FMANAGERSPODATAHOLD DISK PDOFIN/FMANAGERSPODATAHOLD.ftm

But when I try to use that I get the following error when I try to save the fex file "Error Parsing Report Request - >APP< APP PREPENDPATH PDOFIN"

FYI here is the code for the first file, it seems to be working just fine, it is outputting FMANAGERSPODATAHOLD.mas and .ftm to my directory.

APP HOLD pdofin
TABLE FILE T_PROD_PO
PRINT
     PO_AGE AS 'PO AGE (Days)'
     PONUM AS 'PO NUMBER'
     TOTALCOST/P12.2C AS 'OPEN PO,$ AMONT'
BY REGION
BY BSTGROUP
BY DIST
WHERE ( T_PROD_PO.STATUS NE 'CAN' ) AND (( GLDEBITACCT LIKE '4604600%' ) OR ( GLDEBITACCT CONTAINS '657004' OR '657006' )) AND (( ORDERDATE GE DT(2007-01-01 00:00:00) ) AND ( RECEIPTS EQ 'NONE' )) AND (( T_PROD_WORKORDER.STATUS NE 'CAN' OR 'CLOSE' ) AND ( T_PROD_PO.TOTALCOST NE .00 ));
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS FMANAGERSPODATAHOLD FORMAT ALPHA

quote:

Originally posted by Rob M.:

quote:

Originally posted by GinnyJakes:
But back to your problem. You didn't post your first program. Here is an example using the CAR file. Please note that the string 'c758760' is a directory name on my server under the ibi/apps for the reporting server.

-* Program to hold the data.
APP HOLD C758760
TABLE FILE CAR
PRINT SALES DEALER_COST RETAIL_COST
BY COUNTRY
BY CAR 
BY MODEL
ON TABLE HOLD AS CARHOLD FORMAT ALPHA
END

Now here is a program that uses the held data:

APP PREPENDPATH C758760
APP FI CARHOLD DISK C758760/carhold.ftm
TABLE FILE CARHOLD
SUM SALES DEALER_COST RETAIL_COST
BY COUNTRY
END

I am on a UNIX platform so my slashes go the other way. But if you take my examples and change the c758760 to a directory in your installation, you should be able to see the .mas and .ftm that are created.

Let me know how you do with this example.

Ok Ginny,

Here is what I put in my second file....

APP PREPENDPATH PDOFIN
APP FILE FMANAGERSPODATAHOLD DISK PDOFIN/FMANAGERSPODATAHOLD.ftm

But when I try to use that I get the following error when I try to save the fex file "Error Parsing Report Request - >APP< APP PREPENDPATH PDOFIN"

FYI here is the code for the first file, it seems to be working just fine, it is outputting FMANAGERSPODATAHOLD.mas and .ftm to my directory.

APP HOLD pdofin
TABLE FILE T_PROD_PO
PRINT
     PO_AGE AS 'PO AGE (Days)'
     PONUM AS 'PO NUMBER'
     TOTALCOST/P12.2C AS 'OPEN PO,$ AMONT'
BY REGION
BY BSTGROUP
BY DIST
WHERE ( T_PROD_PO.STATUS NE 'CAN' ) AND (( GLDEBITACCT LIKE '4604600%' ) OR ( GLDEBITACCT CONTAINS '657004' OR '657006' OR '657007' )) AND (( ORDERDATE GE DT(2007-01-01 00:00:00) ) AND ( RECEIPTS EQ 'NONE' )) AND (( T_PROD_WORKORDER.STATUS NE 'CAN' OR 'CLOSE' ) AND ( T_PROD_PO.TOTALCOST NE .00 ));
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS FMANAGERSPODATAHOLD FORMAT ALPHA

APP HOLD pdofin
TABLE FILE T_PROD_PO
PRINT
     PO_AGE AS 'PO AGE (Days)'
     PONUM AS 'PO NUMBER'
     TOTALCOST/P12.2C AS 'OPEN PO,$ AMOUNT'
BY REGION
BY BSTGROUP
BY DIST
WHERE ( T_PROD_PO.STATUS NE 'CAN' ) AND (( GLDEBITACCT LIKE '4604600%' ) OR ( GLDEBITACCT CONTAINS '657004' OR '657006' OR '657007' OR '650124' OR '637000' OR '657008' OR '657009' OR '650132' OR '650130' OR '657011' OR '662000' OR '078000' OR '656000' OR '657001' OR '657003' OR '657010' OR '657020' OR '657030' OR '657040' OR '657050' OR '657000' )) AND (( ORDERDATE GE DT(2007-01-01 00:00:00) ) AND ( RECEIPTS EQ 'NONE' )) AND (( T_PROD_WORKORDER.STATUS NE 'CAN' OR 'CLOSE' ) AND ( T_PROD_PO.TOTALCOST NE .00 ));
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS FMANAGERSPODATAHOLD FORMAT ALPHA

APP PREPENDPATH PDOFIN
APP FI FMANAGERSPODATAHOLD DISK PDOFIN/FMANAGERSPODATAHOLD.ftm
TABLE FILE FMANAGERSPODATAHOLD