export multi vs export ascii

Dennis Malen dmalen at malen.com
Sun Oct 4 17:12:01 PDT 2009


Is there any way when using "export multi" such as:



export multi exp=(pn) r=1 f=1



to identify which row and column that I would like information placed? 
"Export multi" works when run a report in sequence. As the report runs it 
places the information in the appropriate cell.



For instance I can use plain text "export ascii" command such as:



export ascii exp=/tmp/asciicost2.xls r=\r r=\n -x -a



If I use an export command such as:



exp(5)="C;Y1;X3;K\""&7&"\""&chr("10")



the information is placed in row 1, column 3.



Can I do something similar to that using "export multi"?



Reason: I have no problem when I manipulate where export multi places 
information. What I do need is a recap of totals that I want at the top of 
the spreadsheet. When I get to the end of the report with export multi I 
would like to place the totals I have accumlated somewhere at the 2nd, 3rd 
or 4th rows and in a particular column. When the report is run I have 
already passed those rows.



Can this be done? I can do it with "export ascii" but would like to save 
programming time and not have to define each cell such as 
"C;Y1;X3;K\""&7&"\""&chr("10"). Export multi would do that for me. What I 
need would only reside in two or three cells at the top of the spreadsheet 
but the information (totals) would only be available at the end of the 
report.



Dennis Malen
516.479.5912 



More information about the Filepro-list mailing list