Does anyone have any details on how to get drill down to work?

Cheers

--

Michael Hawksworth

Visual Fox Solutions

Michael@foxpro.co.uk

www.foxpro.co.uk

Things so far.

Both systems offer a good extension to the native reporting engine.

XFRX

1) Does not support drill down in this version (due in next release)

despite their website/splurb saying it does. (naughty, naughty)

2) Help files are not brilliant and you have to find third party examples.

3) The help desk is very good, and well helpful

4) Trial version is a little problematic

5) Licence includes all upgrades for 12 months

6) More people use it so there is a greater depth of knowledge

FRX2ANY

1) Very quick to get going.

2) Very good help file and examples except for vfp 9 report listener.

3) Licence includes all updates for modules you have purchased.

4) Has easy drill down and charting.

5) Viewer much better

6) Haven't had to call/email the helpdesk so can't comment!

As we need the drill down it is almost certain we will buy FRX2ANY ( a

few tests to do yet) however, my staff feel that FRX2ANY is the better

product (so far).

--

Michael Hawksworth

Visual Fox Solutions

Michael@foxpro.co.uk

www.foxpro.co.uk

Michael,

Thanks for sharing your results. Can you comment on FRX2ANY's charting

capabilities? Specifically, ease of implementation and quality of chart

output? Also, can charts be integrated with drilldown so that they

recalculate during drilldown navigation?

Malcolm

Haven't got that far yet but I will let you know.

Regards

--

Michael Hawksworth

Visual Fox Solutions

Michael@foxpro.co.uk

www.foxpro.co.uk

>From the vendor www.eqeus.com with apologies for the formatting (copied

and pasted from HTML).

Vendor contact: "Martin Haluza" <eqeus@eqeus.com>

This product continues to impress!

Malcolm

<quote>

We are happy to announce that we've just released a new version

of XFRX (11.3):

New features/Updates

* XFRX Advanced Previewer

o Tabbed interface The advanced previewer can now preview

multiple documents using the popular tabbed interface

approach. o Custom event hyperlinks (drill-down)

XFRX now recognizes two types of hyperlinks:

+ “normal” hyperlinks (printed in blue), which navigate

to other places in the report or to an external web

address and

+ “custom event” hyperlinks (printed in green), where

XFRX allows for assigning a custom VFP code that will

be called when users click the hyperlink.

This “custom event” hyperlink feature can be used to invoke

application specific actions (information forms, custom

processes, etc.) or for implementing drill-down

functionality – invoking detailed report where the field

user clicked on is taken as a parameter for the report (for

example, clicking a customer name in the report listing all

customers can run a report with detail information about

this specific customer). The new report can be directed to a

new page of a multipage previewer, which could provide a

comfortable environment for “drilling down” specific

information – with the ability to go back to the original

report without closing the current one, side by side report

comparison, exporting / printing selected reports, etc.

Please find more information about this feature as well as

a step-by-step example in the Developer's guide,

"Implementing custom event hyperlinks (drilldown) in XFRX

previewer" chapter. o Fake toolbar option The previewer can

now optionally replace the default toolbar with a toolbar-

like control placed above the previewer control. This

option can be very useful if the previewer form is not

inside the main VFP screen. o New toolbar icon - "Export"

If the user clicks at the new Export icon, a dialog with

the output type and the file name selection is displayed

and the output document is generated based on options

selected. o Previewer extension handler The extension

handler allows for extending the functionality of the basic

classes without need of creating subclasses. All you need

is to create a custom class, which implements certain

methods. The custom class is registered with the XFRX

previewer class (using SetExtensionHandler method) and the

previewer calls the extension methods on appropriate

events. o The previewer instantiation is now significantly

simplified A complete standalone-window previewer is now

shipped with XFRX - all you need to do to make it work is

to instantiate a class and call one of its methods with an

XFF file to preview as a parameter. Alternatively, you can

use the prepared single document or multiple documents

(tabbed interface) controls to your forms.

Please find more information about the advanced previewer in

the Developer's guide, "XFRX previewer" chapter. o German

localization is now available

* PDF output format o Hebrew code page (cp 1254) is now supported

o Pictures are binary comparised to reduce the size of PDF

documents with repeated pictures o VFP 9: DynamicLineHeight

property is used to control if the text field background color

should fill the whole textbox (VFP 9 default behavior) or only the

actual text printed (VFP 8 backward compatibility behavior)

* General o Target image DPI can be specified (large pictures can

be downsampled to reduce the result document size) [see

PictureDPI property for XFRXListener and XFRXSession classes at

Developer's guide, "Properties and methods common in XFRXListener

and XFRXSession classes" chapter]. o Image quality can be

specified for ActiveX objects [see DefaultPictureFormat property

for XFRXListener and XFRXSession classes at Developer's guide,

"Properties and methods common in XFRXListener and XFRXSession

classes" chapter].

</quote>

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

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

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