Reports designers comparison

Re: Reports designers comparison

Postby TimStone » Mon Jul 15, 2013 5:04 pm

After a short vacation, I'm back at the computer.

I also use the Print class to develop reports. I actually have no problems doing so. The main reason is some of my reports are not typical row and column. For example, consider an invoice for a service ticket. It includes the following:

Company information on top of each page
Customer and vehicle information, boxed for clean appearance
Workorder information boxed for clean appearance and repeated on each page
Parts Information
Labor descriptions ( multi line text )
Recommendations ( multi line text )
Notes
Pricing revision information
Disclaimer ( fine print text )
Signatures
Totals ( by type, subtotal, taxes, fees and grand total )
Payment information
Advertising

All of the information comes from separate databases. A document that is this comprehensive could be pretty difficult to do with a report generator. The FWH Print class makes it very easy, and including a watermark and graphics is also easy.

I look forward to seeing how far this project can go. I'm sure there will be many reports that can be generated that will be very helpful.

Antonio, here are a couple of thoughts for what should be added:
+ Make sure the report can be exported as an Excel spread sheet
+ Include graphs and graphics
+ Remember data must be filtered, and drawn from multiple databases
+ An includable user interface is a nice benefit for our clients so they can create their own reports.

Tim
Tim Stone
http://www.MasterLinkSoftware.com
http://www.autoshopwriter.com
timstone@masterlinksoftware.com
Using: FWH 23.10 with Harbour 3.2.0 / Microsoft Visual Studio Community 2022-24 32/64 bit
User avatar
TimStone
 
Posts: 2944
Joined: Fri Oct 07, 2005 1:45 pm
Location: Trabuco Canyon, CA USA

Re: Reports designers comparison

Postby Silvio.Falconi » Thu Jul 18, 2013 8:49 am

I 'm working tocreate a Small class to print a invoice but I found some problem to create structure ( lines, box, image)

perhaps we can search something to load models in this class as txt extern files

When I call the class I send 3 groups of array Header, Body, Footer

for each group I send the fieldname, the titles, the sizes, if show or not , the picture and the total if we need made a total, and the position on the invoice

then the alias for these groups

then I can show a dialog with folders and insert on each folder a xbrowse with each groups
( if we wants show the field or change te size or change the position order or change the position x,y on the invoice)

then I create a oprn Object

do you like my idea ?
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)
I use : FiveWin for Harbour November 2023 - January 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
User avatar
Silvio.Falconi
 
Posts: 7058
Joined: Thu Oct 18, 2012 7:17 pm

Re: Reports designers comparison

Postby arthursilvestre » Thu Jul 18, 2013 12:34 pm

Silvio.Falconi wrote:I 'm working tocreate a Small class to print a invoice but I found some problem to create structure ( lines, box, image)

perhaps we can search something to load models in this class as txt extern files

When I call the class I send 3 groups of array Header, Body, Footer

for each group I send the fieldname, the titles, the sizes, if show or not , the picture and the total if we need made a total, and the position on the invoice

then the alias for these groups

then I can show a dialog with folders and insert on each folder a xbrowse with each groups
( if we wants show the field or change te size or change the position order or change the position x,y on the invoice)

then I create a oprn Object

do you like my idea ?




Exactly, you have to use FastReport this option to work upon an object. is very simple and practical. (Remembering again is no longer necessary from an external file to generate the report.)

Antonio Liniares if you can, send me your email to send le routine to generate a report in FastReport without the *. Fr3
User avatar
arthursilvestre
 
Posts: 32
Joined: Thu Sep 20, 2012 7:29 pm

Re: Reports designers comparison

Postby Antonio Linares » Thu Jul 18, 2013 12:51 pm

Arthur,

I have received your source code, thanks :-)

Is it yours ? Could you post it here for all the interested users ?
regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
Antonio Linares
Site Admin
 
Posts: 42099
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Re: Reports designers comparison

Postby arthursilvestre » Thu Jul 18, 2013 1:06 pm

Antonio Linares wrote:Arthur,

I have received your source code, thanks :-)

Is it yours ? Could you post it here for all the interested users ?



Staff at the request of Antornio Liniares am publishing this code FastReport, a way to generate the report without using an external file.

Function: Rela_Rescisao2 ()


Link: https://mega.co.nz/#!jVFSQZ4a!GcjvYlg11 ... eiQ4dUcEuY
User avatar
arthursilvestre
 
Posts: 32
Joined: Thu Sep 20, 2012 7:29 pm

Re: Reports designers comparison

Postby Antonio Linares » Thu Jul 18, 2013 2:08 pm

regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
Antonio Linares
Site Admin
 
Posts: 42099
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Re: Reports designers comparison

Postby arthursilvestre » Thu Jul 18, 2013 2:15 pm

Antonio Linares wrote:Arthur,

Thanks,

I have placed a copy of it at:
https://code.google.com/p/fivewin-contributions/downloads/detail?name=FRESCFUN.prg




ok, all right, if you need assistance to implement (if the FR is chosen) I am available.
User avatar
arthursilvestre
 
Posts: 32
Joined: Thu Sep 20, 2012 7:29 pm

Re: Reports designers comparison

Postby Antonio Linares » Thu Jul 18, 2013 3:18 pm

Arthur,

thanks :-)
regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
Antonio Linares
Site Admin
 
Posts: 42099
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Previous

Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: cmsoft and 44 guests