Web Connection
Passing lcExtraReportClauses to xfrx
Gravatar is a globally recognized avatar based on your email address. Passing lcExtraReportClauses to xfrx
  Michael Hogan (Ideate Hosting)
  All
  Feb 1, 2017 @ 02:02pm

I'm having trouble passing extra report clauses through wwXFRX.

I've tried the following:

lcReportFilter = "FOR dar_id=" + ALLTRIM(STR(vdar_id)) THISFORM.pdfReport1.PrintReport("dar_inv", lcFilename, lcReportFilter)

lcReportFilter = "'FOR dar_id=" + ALLTRIM(STR(vdar_id) + "'") THISFORM.pdfReport1.PrintReport("dar_inv", lcFilename, lcReportFilter)

In both cases, I appear to get a zero record

Does anyone have a working format for this?

Gravatar is a globally recognized avatar based on your email address. re: Passing lcExtraReportClauses to xfrx
  Michael Hogan (Ideate Hosting)
  Michael Hogan (Ideate Hosting)
  Feb 1, 2017 @ 02:13pm

Nevermind - apparently, you just leave out the FOR... Doh!

Gravatar is a globally recognized avatar based on your email address. re: Passing lcExtraReportClauses to xfrx
  Rick Strahl
  Michael Hogan (Ideate Hosting)
  Feb 1, 2017 @ 07:16pm

Hmmm...

Are you using the wwXFRX or the XFRX9 class? The wwXFRX9 class will require the FOR command I think...

REPORT FORM (m.lcReport) OBJECT this.oPDF NOPAGEEJECT &lcExtraReportClauses

The plain wwXFRX class uses the XFRX object and I'm not sure what it needs, but I suspect that's what you're calling?

this.lSuccessful = this.oPDF.ProcessReport(m.lcReport, m.lcExtraReportClauses)

+++ Rick ---

© 1996-2024