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: Dan Roche
  Where is Dan Roche?
 Batavia
 Illinois - United States
 Dan Roche
 Tags
Subject: RE: Field Position for field in report disabled
Thread ID: 104004 Message ID: 104042 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Reports and Printers
Date: Thursday, August 10, 2006 10:36:59 PM         
   


> > > > > > > I have an existing report for addresses (mailing labels) and it's been requested that if there's no address line 2 that the city, state zip line to float up. I have the address2 field set to not print if blank. I can't access the Field Position options for the city, state zip line. It's disabled.
> > > > > > >
> > > > > > > If I create a new report and copy my fields from the existing report into the new report I all the sudden am able to use the Field Position options. Any ideas on why this is?
> > > > > > > Do I have to setup all new reports and copy all my controls over to them to get this to work?
> > > > > > >
> > > > > > >
> > > > > > > PC Load Letter???!!!!!!!

> > > > > >
> > > > > > Dan,
> > > > > >
> > > > > > On address line 2 you should also set the "Delete line if blank" checkbox. (I haven't used VFP 6 for a very long time, but I believe the wording is at least similar.)
> > > > > >
> > > > > > Ken
> > > > > > You shall know the truth - and the truth shall set you free. (John 8:33)

> > > > >
> > > > > Yeah Ken, I have that set. Now I just need City, State Zip line to float up in place of it. I've never used the float options so I'm hoping it does what i want it to do
> > > > >
> > > > >
> > > > > PC Load Letter???!!!!!!!

> > > >
> > > > Are you sure you have both the "Remove line when empty" and the "Do not print when empty" boxes checked? Also, make sure that there is nothing to the left or right of the Address line 2 that might interfere with the report's ability to remove the line.
> > > >
> > > > Ken
> > > >
> > > > You shall know the truth - and the truth shall set you free. (John 8:33)

> > >
> > > I don't have a "Do not print when empty" box. And if I have to remove things from the left or right of the field then it would make the report meaningless. Also, while I'm trying to solve this with a report, I'm having the same problem with a label, which doesn't have anything to the left or right of it.
> > >
> > > In either case it doesn't matter cause the report fields don't float up, only down. I'm tinkering with sending the labels to Word, which does float up, but it's proving to be quite an involved process and one that wastes a lot of label stock, heh.
> > >
> > > Thanks anyway
> > >
> > > PC Load Letter???!!!!!!!

> >
> > Sorry Dan,
> >
> > I meant Print When NOT EMPTY(MyTable.AddressLine2) rather than Do Not Print When Empty - I am going a little brain dead here - My wife and are are taking an extended weekend off - until next wed. I think we both need it.
> >
> > The other option for you would be to create a report cursor:
> >
> > SELECT cTitle, ;
> >        cFirstName, ;
> >        cInitials, ;
> >        cSurname, ;
> >        IIF(NOT EMPTY(cAddressLine2), cAddressLine1 + CHR(13) + cAddressLine2,;
> >                                      cAddressLine1) + CHR(13) + ;
> >           cCity-(" "+MyTable.State)+;
> >           cZipCode AS AddressText, ;
> >        OtherFields ;
> >    FROM MyTable ;
> >    WHERE llSomeCondition ;
> >    INTO CURSOR ReportCursor
> > 

> > Now your address is one big field - you can report it using one textbox with "Stretch with Overflow" set on.
> >
> > Ken
> > You shall know the truth - and the truth shall set you free. (John 8:33)

>
> That sir, is a good idea. I was thinking about combining fields but I wasn't thinking clearly at the time.
>
> Thank you, and enjoy your much needed weekend (rent Office Space!)
>
> PC Load Letter???!!!!!!!


Will do.

Ken

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

ENTIRE THREAD

Field Position for field in report disabled Posted by Dan Roche @ 8/10/2006 6:27:05 PM
RE: Field Position for field in report disabled Posted by Ken Murphy @ 8/10/2006 6:35:42 PM
RE: Field Position for field in report disabled Posted by Dan Roche @ 8/10/2006 6:41:24 PM
RE: Field Position for field in report disabled Posted by Dan Roche @ 8/10/2006 9:05:33 PM
RE: Field Position for field in report disabled Posted by Ken Murphy @ 8/10/2006 9:18:32 PM
RE: Field Position for field in report disabled Posted by Dan Roche @ 8/10/2006 9:46:16 PM
RE: Field Position for field in report disabled Posted by Ken Murphy @ 8/10/2006 10:13:44 PM
RE: Field Position for field in report disabled Posted by Dan Roche @ 8/10/2006 10:22:23 PM
RE: Field Position for field in report disabled Posted by Barbara Peisch @ 8/10/2006 10:29:39 PM
RE: Field Position for field in report disabled Posted by Ken Murphy @ 8/10/2006 10:36:59 PM