report export to excel differs from print preview and print

Hot Topic

cannot open up a form-- BIG TROUBLE
what is the maximum field VFP9 can handle
minimize and maximize buttons on Report Designer
newbie here...
Strange Visual FoxPro provider error
Needed help regarding VFP 9 Installation....
Coming from Excel to VFP9 and need help understanding math functions on cells
2 more questions (VFP8)
Old Fox Pro Code Please Help
Select SQL Problem

Visual FoxPro

Link data base file
Grid Resizing
records disappear forom tables
how to get information about file
Problems with Command REN ???
Zip Folder
can i just use sql to get this?
use the reccount
Date problem in VFP 6.0
foxpro exe and dbf's, fpt's, bak's, tbk's, but now prgs etc.

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

  • Dustin Campbell

    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.

  • Pietje_Gates

    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.


  • Sandman13

    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.



  • ISLAM AHMED

    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.   

  • Sowelie

    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.
  • report export to excel differs from print preview and print
Answer this question