Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Removing blank lines
Message
 
To
25/07/2002 07:37:00
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00682168
Message ID:
00682512
Views:
19
This message has been marked as a message which has helped to the initial question of the thread.
>That would work if my report was as simple as just a letter. I can't seem to do what I want to with the report writer in foxpro. I have about 100 fields to put on a form I have created and have arranged them in 2 columns on a single page in the report designer. Everythings works fine when the text and fields from one of the columns, lines are removed when blank. But then I put the 2nd column of fields on the page this doesn't happen. I assume that it is because there are fields in the same horizontal space. This is where I am having my problem and I have yet to find a way around it.
>
>Rob Newell


The only suggestion I have is to use memo fields or arrays and build the data ahead of time. For example, you can use one memo field for the left column and one for the right column. Then you would have to preprocess your data, building a giant string with the data and CHR(13)+CHR(10) to break up each different line. The down side is that if you have to line up figures and stuff, you pretty much have to use a non-proportional font to make this work. I've created some pretty complex reports using this trick and the end results works .. it's just a PITA to deal with.

The only other thing you can try is to create some data groups based on the expression of RECNO(). I've used this trick when I've had tons of fields and had to help keep chunks of information lined up within one specific detail band. It's hard to say if this would help you without knowing the specifics .. but it's a suggestion that you could play with.

Cathy
Cathy Pountney, Microsoft Visual FoxPro MVP
Memorial Business Systems, Inc. (www.mbs-intl.com)

My Website: (www.frontier2000.com)
My Blog: (www.cathypountney.blogspot.com)
My Book: The Visual FoxPro Report Writer - Pushing it to the Limit and Beyond
Free MSDN Article: What's New in the VFP 9.0 Report Writer
Free MSDN Article: The VFP 9.0 Report Writer In Action
Previous
Reply
Map
View

Click here to load this message in the networking platform