Hi there,

Just wondering if anyone has been using XFRX, I recently downloaded the

latest version, it seems a good program. I downloaded the demo, it

worked as expected.

Now when I attempt to copy the source code to create a PDF from the demo

into a blank PRG file to run the exact same code, I never seem to

progress far.

I have a report which has the tables in a private data session within

the report, these tables are all related via relationships.

Below is the quote I am attempting to run in this stand alone prg file.

When I run the program I only get a wait window "Progress" and it seems

that the program has hung, but as I said when I run it through the demo

it works fine.

Any suggestions? Would be greatly appreciated.

close all

loSession=xfrx("XFRX#Init")

SET PATH TO c:\a_m

SELECT 0

USE quote.DBF order quote_no IN 0

SELECT quote

GO TOP

loProgress = createobject("progress")

lnRetVal = loSession.SetParams("QUOTE",,,,,,"HTML")

If lnRetVal = 0

loSession.setProgressObj(loProgress,2)

loSession.ProcessReport("RPTQUOTE.FRX","quote_no = '48450 '",,)

loSession.finalize()

EndIf

define class progress as custom

procedure updateProgress

lpara tnReport,tnPage,tnPercentage

wait window nowait "Page #: "+allt(str(tnPage))+" Report #:

"+allt(str(tnReport))+" ("+allt(str(tnPercentage))+"%)"

enddef

I'm using it to generate PDFs and Word documents and have been very

pleased with the results. However I made a conscious decision to only

support it in VFP 8 or later. It was a good excuse to get my clients to

upgrade the version of VFP they were running. You can turn on logging by

calling the InitLog method of your XFRX object. It might offer some

insight. (Also, you are generating an HTML file in your example, not a

PDF.) I've also found that Martin

This is the class I created for testing purposes when I was evaluating

XFRX for use in my main app. I also tested two other products at the

time but I've stripped out the stuff that tested them and tried to make

it a little less specific to my environment. You pass it 3 params; an

object reference to the calling form, the report you want to run (which

I store as a property of my base form class), and the alias that holds

the main cursor for the report. I did not implement the report scope, as

you are in your example, but maybe this will be helpful in

troubleshooting your problem.

*!* Program: RETEsting.prg

*!* Author: Richard Kaye

*!* Date: 10/20/04 10:11:32 AM

*!* Copyright: RFC Systems 2004

*!* Description: Class to facilitate testing report engines

*!* Call like this:

*!* SET PROCEDURE TO RETesting ADDITIVE

*!* LOCAL loRETest

*!* loRETest=NEWOBJECT([RETesting])

*!* loRETest.RETest(this.Parent,thisform.ReportForm, ALIAS())

*!* loRETest=NULL

*!* RELEASE PROCEDURE retesting

*!* RELEASE loRETest

DEFINE CLASS RETesting AS Custom

PROCEDURE RETest

LPARAMETERS toForm, tcReportForm, tcAlias

ASSERT VARTYPE(toForm)=[O] MESSAGE [Must pass object reference to parent

form!]

ASSERT VARTYPE(tcAlias)=[C] AND NOT EMPTY(tcAlias) MESSAGE [Must pass

current alias!]

LOCAL lcReportForm, s

s=SELECT()

IF VARTYPE(tcReportForm)=[L] OR (VARTYPE(tcReportForm)=[C] AND

EMPTY(tcReportForm))

IF NOT EMPTY(toForm.ReportForm)

lcReportForm=toForm.ReportForm

ELSE

RETURN .f.

ENDIF

ELSE

IF EMPTY(tcReportForm)

lcReportForm=toForm.ReportForm

ELSE

lcReportForm=tcReportForm

ENDIF

ENDIF

IF VERSION(2)>0 && debug mode

SELECT (tcAlias)

#IF VERSION(5)>=800

IF MESSAGEBOX([Test XFRX?],4+32,[Report Engine Testing])=6

LOCAL loSession, loProgress, lnRetval

*!* - rk - 2004-11-30 - macroize to avoid build errors

cCmd=[loSession=xfrx("XFRX#Init")]

&cCmd

*!* loSession=xfrx("XFRX#Init")

loProgress = NEWOBJECT("progress",[progress.prg])

loSession.InitLog()

lnRetVal = loSession.SetParams(lcReportForm,,,,,,"PDF")

IF lnRetVal = 0

loSession.setProgressObj(loProgress,2)

loSession.setThisform(toForm)

*!* loSession.setThis(THIS)

loSession.ProcessReport(lcReportForm,,,)

loSession.finalize

ENDIF

ELSE

MODIFY REPORT (lcReportForm)

ENDIF

#ENDIF

ENDIF && m.debug

SELECT (s)

ENDPROC && RETest

ENDDEFINE

Paul Czura wrote:

> Now when I attempt to copy the source code to create a PDF from the demo

> into a blank PRG file to run the exact same code, I never seem to

> progress far.

>

> I have a report which has the tables in a private data session within

> the report, these tables are all related via relationships.

>

> Below is the quote I am attempting to run in this stand alone prg file.

>

> When I run the program I only get a wait window "Progress" and it seems

> that the program has hung, but as I said when I run it through the demo

> it works fine.

>

> Any suggestions? Would be greatly appreciated.

>

>

> close all

> loSession=xfrx("XFRX#Init")

> SET PATH TO c:\a_m

> SELECT 0

> USE quote.DBF order quote_no IN 0

> SELECT quote

> GO TOP

> loProgress = createobject("progress")

> lnRetVal = loSession.SetParams("QUOTE",,,,,,"HTML")

>

> If lnRetVal = 0

> loSession.setProgressObj(loProgress,2)

> loSession.ProcessReport("RPTQUOTE.FRX","quote_no = '48450 '",,)

> loSession.finalize()

> EndIf

>

--

Richard Kaye

RFC Systems

Voice: 973.761.0868

Fax: 973.761.4329

For the fastest response time, please send your tech support

queries to techsupport@rfcsystems.com

---------------------------------------------------------

---------------------------------------------------------

Paul,

Can you upgrade to a newer version of VFP? I'm surprised that XFRX is

compatible with VFP 6.

Malcolm

Richard,

> I also tested two other products at the time

Curious - what other products did you look at?

Malcolm

MERE and eReports. Both worked reasonably well with standard type

reports but showed some rendering issues with some more complex ones.

XFRX has pretty much worked correctly with every report I've thrown at it.

Malcolm Greene wrote:

> Richard,

>

>

>> I also tested two other products at the time

>>

>

> Curious - what other products did you look at?

>

> Malcolm

>

--

Richard Kaye

RFC Systems

Voice: 973.761.0868

Fax: 973.761.4329

For the fastest response time, please send your tech support

queries to techsupport@rfcsystems.com

---------------------------------------------------------

---------------------------------------------------------

Richard,

> MERE and eReports. Both worked reasonably well with standard type reports but showed some rendering issues with some more complex ones. XFRX has pretty much worked correctly with every report I've thrown at it.

Thanks! I've been pleased with XFRX but I try to stay up-to-date with

other alternatives as well. I've heard good things about FRX2ANY's

charting capabilities but haven't had the time to see what's new.

Malcolm

Being able to dump a VFP report to Word is very cool. Those picky end

users can edit the layout to their heart's content, not to mention that

handling widows and orphans in the VFP report writer can be a real PITA.

Just make sure you use FDOC if you want them to be able to edit it

without an advanced degree in Word...

Malcolm Greene wrote:

> Thanks! I've been pleased with XFRX but I try to stay up-to-date with

> other alternatives as well. I've heard good things about FRX2ANY's

> charting capabilities but haven't had the time to see what's new.

>

--

Richard Kaye

RFC Systems

Voice: 973.761.0868

Fax: 973.761.4329

For the fastest response time, please send your tech support

queries to techsupport@rfcsystems.com

---------------------------------------------------------

---------------------------------------------------------

On Friday, March 24, 2006 3:21 PM Richard Kaye wrote:

>Being able to dump a VFP report to Word is very cool. Those picky end

>users can edit the layout to their heart's content, not to mention that

>handling widows and orphans in the VFP report writer can be a real PITA.

>Just make sure you use FDOC if you want them to be able to edit it

>without an advanced degree in Word...

My biggest problem with those programs that converted FRXs to Word or whatever was with grouping. It was a couple years ago, so I hope that it has improved. My last job had many reports with groupings and I tried the 3 applications out there and they all pretty much failed.

David L. Crooks

I'll have to try something like that and report back here. How many

levels of grouping were you having problems with?

David Crooks wrote:

> My biggest problem with those programs that converted FRXs to Word or whatever was with grouping. It was a couple years ago, so I hope that it has improved. My last job had many reports with groupings and I tried the 3 applications out there and they all pretty much failed.

>

--

Richard Kaye

RFC Systems

Voice: 973.761.0868

Fax: 973.761.4329

For the fastest response time, please send your tech support

queries to techsupport@rfcsystems.com

---------------------------------------------------------

---------------------------------------------------------

On Friday, March 24, 2006 3:40 PM Richard Kaye wrote:

>I'll have to try something like that and report back here. How many

>levels of grouping were you having problems with?

One. It is like none of the products knew how to handle grouping data.

David L. Crooks