Hi
I have a report that I need to remove the blank space in. An example is my procedure returns data in several columns. if column 1 has 5 rows and column 2 has 1 row, the report shows column 2 in the detail portion actually on line 6. I looked at the documentation (sybase infomaker) for removing white/blank space and it says to autosize the height of the columns and under the position tab in infomaker to set the slide uo to the "all above" or "directly above" (I tried both) but this does not move the columns up. In this example I would want column 2 in the detail section of the report to start on line 1 instead of line 6.
Has anyone else had an issue with this? All reponses are appreciated.
Thank you Joe
Hi Joe,
My understanding is that the Autosize and Slide Up functions only work if the data all comes from the same row - for example, you might have a label format where you have the fields in the following layout:
esal1_desc
Street2
Street1
City State Postal_code
If the fields are all Autosize and Slide Up and Street2 is blank, the rest will move up to remove the white space. This is because all the data is coming from the same row of data.
If I understand you properly, I don't believe it's possible to do what you're asking. This is because what I think you are looking to do is move data from returned row to another. Using a spreadsheet analogy, the fields in the label format above all come from row 1 and will be repeated for row 2. It sounds like what you're trying to do is move the data from cell B2 into cell B1 if B1 is empty.
Does that answer the question? Sorry if I've misunderstood your post!
Martin
Thank you Martin and yes, that answered my question
Joe