report export to excel differs from print preview and print

When using Visual Foxpro 8, I notice that my subtotals based on 2 report variables that calculate sums per group in the 4th data grouping are continuing to accumulate instead of resetting after each group when I export to excel but appear fine when I do a print or print preview. I tried deleting and re-adding the grouping only to get the same result. Strangely, I also notice some of my text labels have also shifted over to the right. Has anyone experienced this or know of any suggestions or solutions Please advise, thanks.

Answer this question

report export to excel differs from print preview and print

dowens - msft
This seems to be more a vendor related problem, since your application is using some additional code / tool to add those functionality to the native VFP reportengine. Therefor you should contact your softwares programmer / company with that problem.
PaulHetherington
I intend to report to the vendor this problem as my workaround was to create another field on the temporary report table and populate them with the correct subtotals.
a_b_c
I wonder if this is a bug with Visual Foxpro 8 or Microsoft Excel as I still get reporting differences even after I installed the latest service pack for Visual Foxpro 8. Unfortunately, upgrading to VF9 is not an option.
John Cass
I am using Report variables for various subtotals which get formatted for specific output layouts.

We use a print dialog which comes with the software we use to customize the report which has the feature to export to excel, html, xml, text & PDF at least. I notice the html output also looks erroneous as well.

If using report variables seems to be a problem, I may have to somehow add a lookup field as a patch. I wonder if because I am using 4 levels of subtotals that this is happening. The last service pack did not seem to rectify this problem.
Vishnuprasadh
Hi,

how exactly are you doing the export to Excel from inside the Report

Report variables work only inside the Report engine, which by itself can do only a real print or a preview.
report export to excel differs from print preview and print

Answer this question