what does it take to make an M2M report exportable?

[Gloria Dyok]

Currently there is one M2M report we use a great deal.  It is the indented costed bill of material (BOMICS—accessed via PROD/REPORTS/BOMS, Routings & Resources/Indented Costed BOM).  I can display it (and I can print it) but it does not link to an RP type report which has the parameter of exporting to a file.   There is a similar indented BOM report (RPBMID) but this report does not bring any costs with it. 

Would it be a difficult customization to have the data exported to excel where it is much more usable?  I am forever creating spreadsheets and adding the dollars manually.

Any help would be appreciated.  Apologies for missing the meeting today—this would have been one of my questions.

Gloria Dyok

Cost Accountant

Malibu Research Assoc., Inc.

3760-A Calle Tecate

Camarillo, CA  93012

 

gd...@maliburesearch.com

ph. 805-383-1829 xt. 107

fax 805-383-1859

[Ray Collazo]

Gloria:

  Having the report modified to export to an excel spreadsheet is fairly simple to do: Please contact me via email and send me the code of the report and I can send you back what you need to put in and where and how.

 

Ray

[RajW]

Hi Gloria. We did miss you at the meeting! But we had fun anyways!

This is a good question. There is no .prg (at least not in the prg
folder or anywhere else in the m2mdata folder) that is running that
report. I figure its one of those "Layout Programs" but without there
being a way to get to it from RPMAKE. I however found the layout
(rpbomics.frx) in the templates folder and opened it up to look for
the cursor which is named "CSRCSTBOM", and I looked for that, but no
luck there either. I even looked for the report through the Openlink
window and nothing there as well.

Then, while I had the layout open in VFP, I ran the report again but
since the layout was open, it errored out, "Access Denied", and later
I was able to find it in the error log. Attached here is that portion
of the error log that might help Ray or somebody find the rest of the
program...

04/20/2007 03:33:35
PM:>>--------------------------------------------------------------------------------
04/20/2007 04:20:27 PM:File access is denied m:\m2mdata\reports
\template\rpbomics.frx.
04/20/2007 04:20:27 PM:>>Error Number.....:1705
04/20/2007 04:20:27 PM:>>Error Code.......:m2mlogtrans("D")
04/20/2007 04:20:27 PM:>>Line Number......:0
04/20/2007 04:20:27 PM:>>Program..........:PROCEDURE
FRMCOSTEDBOM.PRINTREPORT
04/20/2007 04:20:27 PM:>>Current Alias....:CSRCSTBOM (C:
\DOCUME~1\RAJESHW\LOCALS~1\TEMP\9EIW05WJ.TMP)
04/20/2007 04:20:27 PM:>>Object Involved..:M:\M2MDATA\REPORTS\TEMPLATE
\RPBOMICS.FRX
04/20/2007 04:20:27 PM:>>User Name........:RWALIA
04/20/2007 04:20:27 PM:>>Company Number...:04
04/20/2007 04:20:27 PM:>>Cmd Processing...:No
04/20/2007 04:20:27 PM:>>Active Window....:BOMICS
04/20/2007 04:20:27 PM:>>...Mode..........:VIEW
04/20/2007 04:20:27 PM:>>...CurrentState..:PARENT
04/20/2007 04:20:27 PM:>>Stack Trace......:
04/20/2007 04:20:27 PM:>>...Level.........: 1
04/20/2007 04:20:27 PM:>>...Program.......: c:\program files
\made2manage\m2m.exe
04/20/2007 04:20:27 PM:>>...Object........: symain
04/20/2007 04:20:27 PM:>>...Source File...:
04/20/2007 04:20:27 PM:>>...Line Number...: 0
04/20/2007 04:20:27 PM:>>...Level.........: 2
04/20/2007 04:20:27 PM:>>...Program.......:
04/20/2007 04:20:27 PM:>>...Object........:
adsactionbar.btnprint.click
04/20/2007 04:20:27 PM:>>...Source File...:
04/20/2007 04:20:27 PM:>>...Line Number...: 0
04/20/2007 04:20:27 PM:>>...Level.........: 3
04/20/2007 04:20:27 PM:>>...Program.......:
04/20/2007 04:20:27 PM:>>...Object........: frmcostedbom.printreport
04/20/2007 04:20:27 PM:>>...Source File...:
04/20/2007 04:20:27 PM:>>...Line Number...: 0
04/20/2007 04:20:27 PM:>>...Level.........: 4
04/20/2007 04:20:27 PM:>>...Program.......: syerror.fxp
04/20/2007 04:20:27 PM:>>...Object........: ON...
04/20/2007 04:20:27 PM:>>...Source File...:
04/20/2007 04:20:27 PM:>>...Line Number...: 0
04/20/2007 04:20:27 PM:>>...Level.........: 5
04/20/2007 04:20:27 PM:>>...Program.......: syerror.fxp
04/20/2007 04:20:27 PM:>>...Object........: syerror
04/20/2007 04:20:27 PM:>>...Source File...:
04/20/2007 04:20:27 PM:>>...Line Number...: 0
04/20/2007 04:20:27 PM:>>End Trace........:
04/20/2007 04:20:27
PM:>>--------------------------------------------------------------------------------
04/20/2007 04:20:40 PM:File access is denied m:\m2mdata\reports
\template\rpbomics.frx.
04/20/2007 04:20:40 PM:>>Error Number.....:1705
04/20/2007 04:20:40 PM:>>Error Code.......:
04/20/2007 04:20:40 PM:>>Line Number......:0
04/20/2007 04:20:40 PM:>>Program..........:PROCEDURE
FRMCOSTEDBOM.PRINTREPORT
04/20/2007 04:20:40 PM:>>Current Alias....:CSRCSTBOM (C:
\DOCUME~1\RAJESHW\LOCALS~1\TEMP\9EIW05WJ.TMP)
04/20/2007 04:20:40 PM:>>Object Involved..:M:\M2MDATA\REPORTS\TEMPLATE
\RPBOMICS.FRX
04/20/2007 04:20:40 PM:>>User Name........:RWALIA
04/20/2007 04:20:40 PM:>>Company Number...:04
04/20/2007 04:20:40 PM:>>Cmd Processing...:No
04/20/2007 04:20:40 PM:>>Active Window....:BOMICS
04/20/2007 04:20:40 PM:>>...Mode..........:VIEW
04/20/2007 04:20:40 PM:>>...CurrentState..:PARENT
04/20/2007 04:20:40 PM:>>Stack Trace......:
04/20/2007 04:20:40 PM:>>...Level.........: 1
04/20/2007 04:20:40 PM:>>...Program.......: c:\program files
\made2manage\m2m.exe
04/20/2007 04:20:40 PM:>>...Object........: symain
04/20/2007 04:20:40 PM:>>...Source File...:
04/20/2007 04:20:40 PM:>>...Line Number...: 0
04/20/2007 04:20:40 PM:>>...Level.........: 2
04/20/2007 04:20:40 PM:>>...Program.......:
04/20/2007 04:20:40 PM:>>...Object........:
adsactionbar.btnprint.click
04/20/2007 04:20:40 PM:>>...Source File...:
04/20/2007 04:20:40 PM:>>...Line Number...: 0
04/20/2007 04:20:40 PM:>>...Level.........: 3
04/20/2007 04:20:40 PM:>>...Program.......:
04/20/2007 04:20:40 PM:>>...Object........: frmcostedbom.printreport
04/20/2007 04:20:40 PM:>>...Source File...:
04/20/2007 04:20:40 PM:>>...Line Number...: 0
04/20/2007 04:20:40 PM:>>...Level.........: 4
04/20/2007 04:20:40 PM:>>...Program.......: syerror.fxp
04/20/2007 04:20:40 PM:>>...Object........: ON...
04/20/2007 04:20:40 PM:>>...Source File...:
04/20/2007 04:20:40 PM:>>...Line Number...: 0
04/20/2007 04:20:40 PM:>>...Level.........: 5
04/20/2007 04:20:40 PM:>>...Program.......: syerror.fxp
04/20/2007 04:20:40 PM:>>...Object........: syerror
04/20/2007 04:20:40 PM:>>...Source File...:
04/20/2007 04:20:40 PM:>>...Line Number...: 0
04/20/2007 04:20:40 PM:>>End Trace........:
04/20/2007 04:20:40
PM:>>--------------------------------------------------------------------------------