Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
XFRX Previewer processes output to EXCEL very slowly
Message
De
12/08/2005 20:32:41
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Produits tierce partie
Titre:
XFRX Previewer processes output to EXCEL very slowly
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01040643
Message ID:
01040643
Vues:
74
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform