Re: An efficient printing approach...

[Nigel Greenlee via 4D_Tech]

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
**

Re: An efficient printing approach...

[Chip Scheide via 4D_Tech]

Rboert,
these emails are archived in publicly accessible places
One I can think of -
4D, nibble, game -- probably others.


> Hi Scott, I'm in New Orleans... I appreciate your response as well as 
> the thoughtful and helpful comments from Chip, Kirk, Chuck, Jim and 
> Arnaud. The sample data provided by the client was a hand-written 
> mockup and was labeled as such via the intended link. I agree that 
> the document looks authentic and that the names should have been 
> redacted to remove any doubt. As recommended, the post was removed 
> immediately and I'll certainly redouble my efforts in this important 
> area of personal information safety and compliance. I shared the 
> document with you as though you're all on my private team, a valued 
> brain trust and wealth of 4D knowledge, my friends for more than 27 
> years. I trust that you will keep any and all information that's been 
> shared via this group as a private matter and give me the chance to 
> correct this situation.
> 
> Sincerely,
> 
> Robert
> 
> Sent from my iPhone
> 
>> On Jun 30, 2017, at 2:06 PM, cswirth via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> The form you posted...
> 
> **
> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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
**

Re: An efficient printing approach...

[Robert ListMail via 4D_Tech]

Hi Scott, I'm in New Orleans... I appreciate your response as well as the 
thoughtful and helpful comments from Chip, Kirk, Chuck, Jim and Arnaud. The 
sample data provided by the client was a hand-written mockup and was labeled as 
such via the intended link. I agree that the document looks authentic and that 
the names should have been redacted to remove any doubt. As recommended, the 
post was removed immediately and I'll certainly redouble my efforts in this 
important area of personal information safety and compliance. I shared the 
document with you as though you're all on my private team, a valued brain trust 
and wealth of 4D knowledge, my friends for more than 27 years. I trust that you 
will keep any and all information that's been shared via this group as a 
private matter and give me the chance to correct this situation.

Sincerely,

Robert

Sent from my iPhone

> On Jun 30, 2017, at 2:06 PM, cswirth via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> The form you posted...

**
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
**

Re: An efficient printing approach...

[Arnaud de Montard via 4D_Tech]

> Le 30 juin 2017 à 19:54, Robert ListMail via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> I was tasked with creating this report in 4D where I chose to use Print 
> Form…[...]

I've completely forgotten 'Print form' since 'Print object' is available. 
It's not at all the same approach but it's powerful. 

-- 
Arnaud de Montard 




**
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
**

Re: An efficient printing approach...

[Chuck Miller via 4D_Tech]

I agree you must remove this document. It is fraught with danger to keep there 
for you. There are massive fines for breaking HIPPA laws

Regards

Chuck

 Chuck Miller Voice: (617) 739-0306
 Informed Solutions, Inc. Fax: (617) 232-1064   
 mailto:cjmillerinformed-solutions.com 
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D and Sybase connectivity
  http://www.informed-solutions.com  

This message and any attached documents contain information which may be 
confidential, subject to privilege or exempt from disclosure under applicable 
law.  These materials are intended only for the use of the intended recipient. 
If you are not the intended recipient of this transmission, you are hereby 
notified that any distribution, disclosure, printing, copying, storage, 
modification or the taking of any action in reliance upon this transmission is 
strictly prohibited.  Delivery of this message to any person other than the 
intended recipient shall not compromise or waive such confidentiality, 
privilege or exemption from disclosure as to this communication. 

> On Jun 30, 2017, at 1:54 PM, 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
**

Re: An efficient printing approach...

[Kirk Brooks via 4D_Tech]

Robert,
Is the intent to replicate the look and format of the document or simply
report the data? To replicate the look of the form will take longer (for
conversation I'd say at least 2 - 3 times longer). As for assembling the
data that will depend on whether it's readily available already or not. And
if you have to write an interface to accommodate users defining the query
parameters and such that becomes a non-trivial task in itself. So I'd guess
somewhere between a long afternoon and a week.

And I agree it would be good to obscure the identifying information. I'd
suggest you do that right away.


On Fri, Jun 30, 2017 at 10:54 AM, 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…?

-- 
Kirk Brooks
San Francisco, CA
===

*The only thing necessary for the triumph of evil is for good men to do
nothing.*

*- Edmund Burke*
**
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
**

Re: An efficient printing approach

[Jim Medlen via 4D_Tech]

We use the plugin SuperReport Pro to create similar complex reports.

http://www.e-node.net/redir/EN/produit_id_63/SuperReport-Pro.html


Thanks,

Jim Medlen
Computer & Information Systems
Functional Devices, Inc.
j.med...@functionaldevices.com
phone (765) 883-5538 x 428
fax (765) 883-4262
http://www.functionaldevices.com
This email was transmitted on 100 percent recycled electrons



On 6/30/17, 3:00 PM, "4d_tech-boun...@lists.4d.com on behalf of
4d_tech-requ...@lists.4d.com" <4d_tech-boun...@lists.4d.com on behalf of
4d_tech-requ...@lists.4d.com> wrote:

>An efficient printing approach


**
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
**

Re: An efficient printing approach...

[Chip Scheide via 4D_Tech]

1st - you should have redacted the patient names - that is a HIPPA 
(read that as a FEDERAL issue) problem, and you should pull this 
document - NOW!!

2nd - The second page illegible

making assumption:
- all the primary data is in one table ([dispensations])
- using print form (I would think about using print selection but I'm 
not sure about the break between out and return)

(not real code, written in email)
set query destination(into set;"dispensed")
query([dispensations];[dispensations] dispensation_date >=$Start_Date;*)
query([dispensations];&;[dispensations] dispensation_date <=$End_Date;*)
query([dispensations];&;[dispensations] Is_Return = false)

set query destination(into set;"Returns")
query([dispensations];[dispensations] dispensation_date >=$Start_Date;*)
query([dispensations];&;[dispensations] dispensation_date <=$End_Date;*)
query([dispensations];&;[dispensations] Is_Return = true)

$header :=100//guesses as to size
$detail := 20
$break := 50
$Totals := 150
$Page_Number := 20
Max_Page_Size := 740
$Printed:=0
$Printing_Completed := false
$Printing_Dispensed:=true

For($i;1;records in set("Returns")+records in set("dispensed"))

  if ($Printed = 0)  //top of page
print form(header)
$printed := 150
  end if

 if( Printing_Dispensed)
   use set("dispensed")
   $Detail_Name:="Dispensed_Detail"
   $Set_Name:="dispensed"
 else
   use set("Returns")
   $Detail_Name:="Return_Detail"
   $Set_Name:="Returns"
 end if

  if (($printed+$detail+$Page_Number)<$Max_Page_Size)
Print form($Detail_Name)
$Printed:=$Printed+$Detail
Next record([dispensations])

if (end selection([dispensations])
  $Set_Name:="Returns"
else
  create set([dispensations];$Set_Name)
end if
  else  //not enough room
Print form("Page_footer")
$i:=$i-1
$Printed:=0
  end if
end for

if ($printed+$Totals+$Page_numbers)>$Max_Printed)
  print form("Header")
end if
print form ("Totals")
print form("page_Footer")


On Fri, 30 Jun 2017 12:54:48 -0500, Robert ListMail via 4D_Tech 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
> **
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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
**

Re: An efficient printing approach...

[cswirth via 4D_Tech]

Robert,

Where are you located? The form you posted seems to contain patient health
information and under US law this represents a reportable HIPAA breach. I
suggest you remove the file right away.

Regards,
Scott Wirth
4D developer (and HIPAA security officer)



--
View this message in context: 
http://4d.1045681.n5.nabble.com/An-efficient-printing-approach-tp5752895p5752896.html
Sent from the 4D Tech mailing list archive at Nabble.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
**

An efficient printing approach...

[Robert ListMail via 4D_Tech]

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
**