I need to show on one page several rows of data, such as:
ID, Name, Address
ID can be from 1 to 5 characters long
Name can be from 10 to 200 characters long
Address can be from 0 to 255 characters long
I need to display all the text on one A4 page.
What happens when I add the data selection:
I takes the rows belonging to the first page, where Name is 50 characters (so the text box gets resized to 50) and the Address is 60 characters.
When i go to the second page the Name and Address are 100 characters and the text overflows to the right box (I've set resizing to NONE).
I need to make the longer text split over several lines, in which I've succeeded, but what happens is:
ID Name Address
001 Alexander Rome
002 the Great Venice
Nero
It should be ID 001, Name Alexander the Great, Address Rome
ID 002, Name Nero and Address Venice is the next line of data.
So i need to make all the lines jump to next recort at the same position.
Any ideas how to do this?