Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: mk sharma
  Where is mk sharma?
 mumbai
 India
 mk sharma
 To: Rahul Moudgill
  Where is Rahul Moudgill?
 Toronto
 Canada
 Rahul Moudgill
 Tags
Subject: RE: Original/Duplicate with Report Preview
Thread ID: 373512 Message ID: 373549 # Views: 47 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Reports and Printers
Date: Saturday, March 23, 2013 5:49:49 AM         
   


> > How to Print "Original" on first copy and "Duplicate" on second copy ?
> >
> >
> > ** PreviewCommandButton
> > 
> > oapp.cReportTpye=""
> > Report form MyReport to print prompt preview
> > 
> > ****  Now if user print from Preview then How to display " Original "  on first Copy 
> > ****  and "Duplicate" on second copy  ?
> > 
> > 
> > ****  With Print Command Button I am using below method to print "Original" on first copy 
> > ****  and "Duplicate" on second copy. 
> > 
> > **** But How to print "Original"  or " Duplicate " when user print from Preview ?
> > 
> > ** PrintCommandButton
> > oapp.cReportTpye=""
> > 
> > for i = 1 to 2
> > do case
> > case i = 1
> > oapp.cReportTpye="Original"
> > Report form MyReport to print prompt
> > case i = 2
> > oapp.cReportTpye="Duplicate"
> > Report form MyReport to print prompt
> > endcase
> > endfor
> > 

> >
> >
> >
> > Warm Regards,
> > mk.
>
>
> Select YourCursor.*,;
> 	Cast(Trans(YourCursor.PK)+[Copy01] as Char(20)) as CopyGrp,;
> 	Cast([Original Copy] as Char(20)) as CopyRemarks;
> 	From YourCursor ;
> union All ;
> Select YourCursor.*,;
> 	Cast(Trans(YourCursor.PK)+[Copy02] as Char(20)) as CopyGrp,;
> 	Cast([Duplicate Copy] as Char(20)) as CopyRemarks;
> 	From YourCursor ;
> INTO YourNewCursor
> 
> * Create DataGroup with CopyGrp
> 
> Report form MyReport to print prompt
> 
> 

>
> Rahul

Thank you,

I think this will show the report two time in preview ?

Is any possibility when we set COPIES = 2 in report expr like :

** Below code in Expr field :
DRIVER=winspool
DEVICE=Auto HP LaserJet 1020 on sarda2
OUTPUT=\\SARDA2\HPLaserJ
ORIENTATION=0
PAPERSIZE=512
COPIES=2 && Here i have set Copies = 2 and it is showing copies = 2 in Printer Dialog.
DEFAULTSOURCE=7
PRINTQUALITY=600
COLOR=1
DUPLEX=1
TTOPTION=0
COLLATE=0


Warm Regards,
mk.

ENTIRE THREAD

Original/Duplicate with Report Preview Posted by mk sharma @ 3/22/2013 8:16:54 PM
RE: Original/Duplicate with Report Preview Posted by Rahul Moudgill @ 3/23/2013 2:56:11 AM
RE: Original/Duplicate with Report Preview Posted by mk sharma @ 3/23/2013 5:49:49 AM
RE: Original/Duplicate with Report Preview Posted by Rahul Moudgill @ 3/24/2013 8:16:32 AM
RE: Original/Duplicate with Report Preview Posted by Jignesh Parekh @ 3/23/2013 5:10:03 AM
RE: Original/Duplicate with Report Preview Posted by mk sharma @ 3/23/2013 6:16:20 AM
RE: Original/Duplicate with Report Preview Posted by Jignesh Parekh @ 3/23/2013 2:11:25 PM
RE: Original/Duplicate with Report Preview Posted by mk sharma @ 3/23/2013 4:19:55 PM
RE: Original/Duplicate with Report Preview Posted by Jignesh Parekh @ 3/25/2013 5:03:42 AM
RE: Original/Duplicate with Report Preview Posted by mk sharma @ 3/25/2013 5:52:53 AM
RE: Original/Duplicate with Report Preview Posted by Manish Swami @ 3/23/2013 5:28:13 AM