Page 1 of 3

Report Drill Down

PostPosted: Tue Jan 12, 2016 10:43 pm
by 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.

Re: Report Drill Down

PostPosted: Wed Jan 13, 2016 11:38 am
by Antonio Linares
Darrell,

Could you post a screenshot of such feature ? thanks

Re: Report Drill Down

PostPosted: Wed Jan 13, 2016 12:02 pm
by cnavarro
What he means is:
The items and contents of the report are type of link?

Re: Report Drill Down

PostPosted: Wed Jan 13, 2016 12:12 pm
by 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

Re: Report Drill Down

PostPosted: Wed Jan 13, 2016 3:32 pm
by MGA
the fastreport do it!!!

Re: Report Drill Down

PostPosted: Wed Jan 13, 2016 4:01 pm
by cdmmaui
Thank you for your feedback.

Where can I find fast report?

Re: Report Drill Down

PostPosted: Wed Jan 27, 2016 9:55 pm
by 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.

Re: Report Drill Down

PostPosted: Wed Jan 27, 2016 10:54 pm
by 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!

Re: Report Drill Down

PostPosted: Wed Jan 27, 2016 11:06 pm
by 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.

Re: Report Drill Down

PostPosted: Thu Jan 28, 2016 12:58 am
by cdmmaui
Thanks Reinaldo! I sent you an email.

Re: Report Drill Down

PostPosted: Thu Jan 28, 2016 9:37 am
by Silvio.Falconi
WHY not we all try to create it with Treport class ?

Re: Report Drill Down

PostPosted: Fri Jan 29, 2016 8:33 am
by Antonio Linares
Reinaldo, Silvio,

DrillDown reports n-level deep


Could you provide some screenshots to review it ? thanks

Re: Report Drill Down

PostPosted: Fri Jan 29, 2016 3:59 pm
by 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.

Re: Report Drill Down

PostPosted: Fri Jan 29, 2016 5:45 pm
by 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.

Re: Report Drill Down

PostPosted: Fri Jan 29, 2016 6:05 pm
by 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.