Robert I have not looked at your report at all.
Two things spring to my mind. 1) if the report could be produced in excel could you not use ODBC to extract the data from 4D(Not my prerered option but it it should be feasible) 2) More practically(and something i did recently). Could you not create a template in Excel(nice headers and all that bananas). and then inject the data into it from 4D(this is not actually complicated especially on OSX as you can use LEP)…i recently had something i was converting where the users told me that ‘it used to make the document into an excel document..i mean on oS9..and nobody has done anything to fix it! I wrote some code to put the columns and rows into an excel document-i pick up an existing template in which widths etc are already set and fill the rows(pretty snappy too). I did not bother about how to get say a totals column on the template to automatically be updated because it was not in the scope of what i was doing but i believe that should be possible. For anyone interested here is the (pretty agnostic) code i used-it-i think its pretty straigthforward reading. https://www.dropbox.com/s/6dyd0uk6m2u6mx0/TabDeltoXL.txt?dl=0 If you are on OSX > On 30 Jun 2017, at 18:54, Robert ListMail via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I was tasked with creating this report in 4D where I chose to use Print > Form…. Since it took me an embarrassingly long time to create this and since > it could be done from scratch in Excel in 20 minutes… I wanted to hear from > the smarter 4D Developers at large. So, how would you build a report like > this in 4D? Also, how much time might you budget or estimate…? > > https://www.dropbox.com/s/c0kgzg9uwed840i/2017_06_27_16_52_46_OCR.pdf?dl=0 > > Thanks, > > Robert > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************
