NetwebBrowse with export button with a local variable

[MikeR]

I have a netwebbrowse
with a local field loc:totalvalue
it is calculated as tbl:untprice * tbl:quantity
in the browse it shows correctly
however on the export it exports a zero value

[Vinnie]

I am sure That's how it works.

The Export only exports from the queue but the local variable is not in the queue.

[MikeR]

Thanks Vinnie do you know if there is a embed point where I can calculate it

[Vinnie]

No Sorry Mike I can not help with an embed point.
I guess you can not change the data file structure.

I create a in memory file for the export data and export that rather then the tps file.

Not sure this is the best and only way.

[terryd]

Hi Mike
I have had this situation
If you search the source in the browse for
Start of "ExportToExcel routine After Headings"
There is a loop after this which is exporting your view to Excel
In the start of "Set Queue Record" in the loop
you can add your calculation of the local variable.
What I tend to do now with local variables that I want to export is create a Procedure routine when I create the local variable then in the browse and in this export embed I call the  ProcedureRoutine where the value is calculated (ensures that the browse and Export agree)