Hi,
I have a a custom report trying to hide empty fields and shift the next field up.
It still shows and empty space.
Example:
company1
company2
company3
If when empty don't show and move company2 up or the cell of teh company2 up and not show the cell of company1 if empty.
Thank you for your help in advance.
Your english is not very clear, but I think I see what you are asking. You are pulling up info from a database or some such source. Some of the table cells at any given time may be populated, and some not. Rather than the following:
<html>
<table>
<tr><td>company 1</td><td>Ho-Chuck</td></tr>
<tr><td>company 2</td><td></td></tr>
<tr><td>company 3</td><td>Ben and Jerry's</td></tr>
</table>
</html>
you would like this:
<html>
<table>
<tr><td>company 1</td><td>Ho-Chuck</td></tr>
<tr><td>company 3</td><td>Ben and Jerry's</td></tr>
</table>
</html>
Do I understand you right?
If so, you should test for the presense of data before drawing the table row:
-
if compName <> "" then
-
'draw the row with the company
-
end if
-
If this is a problem with the custom report you are using, I would consider abandoning the custom report or seeking help from the maker of the custom report.
Jared