Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XFRX Previewer processes output to EXCEL very slowly
Message
From
12/08/2005 20:32:41
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Third party products
Title:
XFRX Previewer processes output to EXCEL very slowly
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01040643
Message ID:
01040643
Views:
75
I use the following code to drive the XFRX Previewer. After the preview shows, I use the toolbar to select output to EXCEL. The report takes twenty three minutes to process:
loSession = xfrx("XFRX#INIT")
lnRetVal = loSession.SetParams(,,,,,,"XFF") && no name = just in memory
If lnRetVal = 0
   *
   * initialize the previewer 
   *
   loPreview = CREATEOBJECT("frmPreviewer")
   loPreview.windowtype = 1 && modal
   *
   * the finalize method returns the XFRX#DRAW object reference
   *
   loSession.ProcessReport(m.lcRepName, m.lcCondition)
   loPreview.cmdopen.Click(loSession.finalize()) && show the document
   loPreview.show(1)
   *
ENDIF
However when I use the following code which bypasses the XFRX previewer, the same report processes within four minutes.
loSession=xfrx("XFRX#INIT")
lnRetVal = loSession.SetParams(ForceExt(m.lcRepName,[xls]),,,,,,"XLS")
If lnRetVal = 0

   loSession.SetOtherParams("NEXT_SHEET_NAME", m.Title1)
   loSession.ProcessReport(m.lcRepName, m.lcCondition)
   loSession.finalize()

Endif
Any advice would be greatly appreciated.
Barry Taft
i am only worried in the short term. once there is a problem, the solution usually presents itself.
Next
Reply
Map
View

Click here to load this message in the networking platform