Report Drill Down

[cdmmaui]

Hello Everyone,

Has anyone created a report that allows a user to drill down on a specific report value? For example, if the user the clicks on a report value of $1,000.00 the report would display the actual items that make sure the $1,000.00. I have seen these feature in other applications and would like to incorporate this feature to a FWH application.

[Antonio Linares]

Darrell,

Could you post a screenshot of such feature ? thanks

[cnavarro]

What he means is:
The items and contents of the report are type of link?

[Silvio.Falconi]

you must use groups command on column you want make the Drill and insert a link with ssay class

or use the printer class and make to hand it perhaps with urllink class

Antonio,
just my cent
perhaps it can run on rptcolumn function to insert the option urllink and call this class but I not tried it
I think we must modify METHOD Say( nCol, xText, nFont, nPad, nRow ) of Treport a and insert a call to urllink class
or Say( nRow, nCol, cText, oFont, nWidth, nClrText, nBkMode, nPad ) CLASS TPrinter because say of report depend from say of printer class

[MGA]

the fastreport do it!!!

[cdmmaui]

Thank you for your feedback.

Where can I find fast report?

[reinaldocrespo]

Hello Darrell;

To expand on a previous comment; among many other features, with Fastreports you can make DrillDown reports n-level deep. Now deceased, Sergi Spirin, had the rights to distribute and maintained a fastreports class for harbour [very-very-very good and advanced tool].

FastReports works with just about every modern computer language and is quite popular among Delphi programmers. Nothing else in the xbase world comes close.

Unfortunately, since Sergi's passing, only the people at xalier is working with a harbour implementation of FastReports. They call it FRX and claim that it works with FWH. I say "unfortunately" because I was hoping someone in the FWH community would take on the project but that hasn't happened. Too bad, since this is --hands down--, the very best reporting class available to us. https://www.fast-report.com/en/

I think those of us in the FWH world using FastReports are still using Sergi's code. I'm still producing reports that would be impossible otherwise but always worried that my fastreports will stop working for me and have to return to less advanced tools.

Best regards,



Reinaldo.

[cdmmaui]

Dear Reinaldo,

Happy New Year!

I did contact them and they were not very helpful. They basically said product was dead.

I am going to create an HTML / CSS report that will allow user to click a report row then will drill down to the details.

I wish I could have purchased the report class from someone.

Thanks for your help!

[reinaldocrespo]

Thank you Darrell;

Write me an email reinaldo dot crespo at gmail and I will send you that link where you can purchase fastreports for harbour.


Reinaldo.

[cdmmaui]

Thanks Reinaldo! I sent you an email.

[Silvio.Falconi]

WHY not we all try to create it with Treport class ?

[Antonio Linares]

Reinaldo, Silvio,

DrillDown reports n-level deep

Could you provide some screenshots to review it ? thanks

[reinaldocrespo]

Hello Antonio;

On a Drill down report you can double click on a group header and the detail for that group will open or close. Think of it as dynamic opening or closing a group detail. It works that way also with a saved report. You can deliver a saved Fp3 report to a user as a summary report. The user can then double click on a group header to see the detail for that group.

FastReports has many other features that makes for dynamic reports. For example you can click on a signature line to have the user's [saved] signature appear above the signature line. I have pathology reports that are signed by the pathologist by clicking on the signature line.

I may be preaching in the wilderness here or I may be missing something. I mean -if other xbase companies have acquired fastreports representation and have rolled out what they claim to be an (x)harbour implementation of fastreports that works even for fw users, then fw should have invested their time and effort on fastreports instead of easyreports which doesn't even come close. More on fastreports: https://www.fast-report.com/en/

Best regards,



Reinaldo.

[James Bott]

I am not clear on this, but from the FastReport website it appears that you have to pay for a license for each company that is going to use FastReports. And these licenses are very expensive running from US$4000 to US$9000. This is probably too expensive for most of our customers.

[reinaldocrespo]

James;

Not so. -and don't bother trying to purchase fastreports from the website unless you are planing on using some .net language or Delphi.

I assure you all fw fastreports users didn't pay $4k. I didn't. ...and for everyone's information - there is another commercial xbase company -whose name I will not quote here- selling fastreports for (x)harbour including to fwh users. I think it costs around $300.

Hope that helps,


Reinaldo.