FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Report Drill Down
Posts: 708
Joined: Fri Oct 28, 2005 09:53 AM
Report Drill Down
Posted: Tue Jan 12, 2016 10:43 PM

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.

*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com
Posts: 44162
Joined: Thu Oct 06, 2005 05:47 PM
Re: Report Drill Down
Posted: Wed Jan 13, 2016 11:38 AM

Darrell,

Could you post a screenshot of such feature ? thanks

regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 6755
Joined: Wed Feb 15, 2012 08:25 PM
Re: Report Drill Down
Posted: Wed Jan 13, 2016 12:02 PM

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

Cristobal Navarro

Hay dos tipos de personas: las que te hacen perder el tiempo y las que te hacen perder la noción del tiempo

El secreto de la felicidad no está en hacer lo que te gusta, sino en que te guste lo que haces
Posts: 7318
Joined: Thu Oct 18, 2012 07:17 PM
Re: Report Drill Down
Posted: Wed Jan 13, 2016 12:12 PM

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

Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
Posts: 1286
Joined: Mon Feb 25, 2008 02:54 PM
Re: Report Drill Down
Posted: Wed Jan 13, 2016 03:32 PM

the fastreport do it!!!

ubiratanmga@gmail.com

FWH24.04
BCC7.3
HARBOUR3.2
xMate
Pelles´C
TDolphin
Posts: 708
Joined: Fri Oct 28, 2005 09:53 AM
Re: Report Drill Down
Posted: Wed Jan 13, 2016 04:01 PM

Thank you for your feedback.

Where can I find fast report?

*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com
Posts: 990
Joined: Thu Nov 17, 2005 05:49 PM
Re: Report Drill Down
Posted: Wed Jan 27, 2016 09:55 PM
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.
Posts: 708
Joined: Fri Oct 28, 2005 09:53 AM
Re: Report Drill Down
Posted: Wed Jan 27, 2016 10:54 PM

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!

*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com
Posts: 990
Joined: Thu Nov 17, 2005 05:49 PM
Re: Report Drill Down
Posted: Wed Jan 27, 2016 11:06 PM

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.

Posts: 708
Joined: Fri Oct 28, 2005 09:53 AM
Re: Report Drill Down
Posted: Thu Jan 28, 2016 12:58 AM

Thanks Reinaldo! I sent you an email.

*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com
Posts: 7318
Joined: Thu Oct 18, 2012 07:17 PM
Re: Report Drill Down
Posted: Thu Jan 28, 2016 09:37 AM

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

Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
Posts: 44162
Joined: Thu Oct 06, 2005 05:47 PM
Re: Report Drill Down
Posted: Fri Jan 29, 2016 08:33 AM
Reinaldo, Silvio,

DrillDown reports n-level deep


Could you provide some screenshots to review it ? thanks
regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 990
Joined: Thu Nov 17, 2005 05:49 PM
Re: Report Drill Down
Posted: Fri Jan 29, 2016 03:59 PM
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.
Posts: 4840
Joined: Fri Nov 18, 2005 04:52 PM
Re: Report Drill Down
Posted: Fri Jan 29, 2016 05:45 PM

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.

FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10
Posts: 990
Joined: Thu Nov 17, 2005 05:49 PM
Re: Report Drill Down
Posted: Fri Jan 29, 2016 06:05 PM

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.