Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 To: Khurram Tahir
  Where is Khurram Tahir?
 Karachi
 Pakistan
 Khurram Tahir
 Tags
Subject: RE: Printing & udf
Thread ID: 112206 Message ID: 112237 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Reports and Printers
Date: Monday, November 06, 2006 2:05:50 PM         
   


> > > I am reading in a thread that if i create a udf function in which i am calling skip and i have to copy my detail band controls and udf sits between them then i can print 2 records report of half size on Letter size(8.5*11) page
> > >
> > >
> > > Can anyone tell me the following
> > >
> > > 1. Coding of udf in which skiping
> > > 2. I have to copy controls of group header,footer band too
> > > 3. If i have 2 detail bands i have to copy both of the bands controls

> >
> > Khurram,
> >
> > It will be difficult to do this with two detail bands. I am unsure of how you would do it, but a UDF to skip to the next record is fairly simple:
> >
> > FUNCTION Skip2Next
> > LPARAMETER lcTableName
> > IF VARTYPE(lcTableName) = [C]
> >    SKIP 1 IN SELECT(lcTableName)
> > ELSE
> >    MESSAGEBOX([Invalid Parameter],16,[Skip2Next()])
> > ENDIF
> > ENDFUNC
> > 

> >
> > Ken
> >
> >
> > You shall know the truth - and the truth shall set you free. (John 8:33)

>
> Thanks for udf please
>
> Next problem
> How can i print group header & footer after skip for next record


Khurram,

I asume that you are talking about the page header and footer. You will need to create data groupings and place what you currently have in the page header and footer into the group header and footer.

I don't really think that this is going to work for you. You are basically trying to spoof VFP into printing two pages on one peice of paper. Page headers and footers are therefore going to be a problem.

I was thinking about your problem yesterday, and I thought of another option. You could try is to print the report as a lable with two lables per page. I haven't tried it, but it may be worth a look.

Ken
You shall know the truth - and the truth shall set you free. (John 8:33)

ENTIRE THREAD

Printing & udf Posted by Khurram Tahir @ 11/6/2006 7:12:07 AM
RE: Printing & udf Posted by Ken Murphy @ 11/6/2006 1:27:18 PM
RE: Printing & udf Posted by Khurram Tahir @ 11/6/2006 1:38:53 PM
RE: Printing & udf Posted by Ken Murphy @ 11/6/2006 2:05:50 PM