Report Field Move Up

[engan]

Hi all,

I need to create a report which might look like this :

Name : XXXXX
Address : XXXXXXXX
XXXXXXXX
XXXXXXXX
XXXXXXXX
City : XXXXXXXX
Country : XXXXXXXX

If the address is only 2 rows then city and country will move up 2 Rows (Label and field will move up). So the result will be :
Name : XXXXX
Address : XXXXXXXX
XXXXXXXX
City : XXXXXXXX
Country : XXXXXXXX

How do we design the report using vfp report writer ? When I provide 4 Row High in my design, The third and fourth row will be filled with blank.

Thanks
Eng An

 

[Stefan5627]

doubleclick the field,
in the print when dialog box check the 'remove line if blank' checkbox
This will automaticly move up your rows

good luck,

Stefan

 

[engan]

Stefan, The data that I have for my address is memo field type. So if someone type in 2 lines instead of 4 lines address, the report writer will not consider the third and fourth line as a blank line. Unless the memo is empty then it will consider as a blank line. So If I design 4 lines of row in my report writer and my memo data is 2 lines, then the 3rd and 4rd row is showing up as blank and it will make a gap between the address and city. Any clue on this situation ?

Thanks
Eng An

 

[JRB-Bldr]

You might want to consider putting your data into a cursor before sending it (the Cursor) to the Report Form.

By doing so you would extract the memo field data and put it into its own fields within the cursor. Then Stefan's suggestions would work fine.

Altermatively you could use MEMLINES to pre-determine how many lines there are within each Memo field and then use that value in a field and/or variable to control the Report Form lines' Print When... expression.

Good Luck,
JRB-Bldr

 

[Stefan5627]

Make the field just one line high, in the propertie's dialog box mark the 'stretch with overflow' field

 

[engan]

JRB-bldr, I could use the suggestion using memlines if the case is for my address (max 4 lines).The thing is I want to use this kind of reporting with other memo field which the number of lines is unknown until the user type in the data. How are we gonna design in our report writer ? we cannot reserved 5,10, or 15 consecutive line to hold the data extracted using memlines because the data is variable length. Any other suggestion ?

Thanks
Eng An