Rearrange Report Fields after hidden some other fields

[alvingenius]

Hello
this is my first post here in this great forum

any my question is :

i have a DB for employees data

and i want to create a printed report to tell the employee to complete the missing fields on his profile and i want to mention this specific fields to fill only on this report

my way is to create a report and in LOAD event

if isnull (@@@)then
me.@@@.visible=true
else
me.@@@.visible=false

for all fields

and this trick works but my problem is to rearrange empty (null) fields
see the blank space between fields in 1.png / 2.png

sample db attached

if you have a better idea or a fix for this problem tell me

thanks in advance

 

[arnelgp]

suggestion. why not use image to highlight those fields that need to be filled up instead of hiding the field (see sample).

another thing, why did you not use the form instead of report?

 

[alvingenius]

it's a printed report to fill , your suggestion is to fill it in form
and i want to print Null Fields only

 

[arnelgp]

i see, please try this.

 

[alvingenius]

i see, please try this.

i think you didn't get me right

lets say i have this report :

name : xxxxxxxxxxxxx
phone :
address:
email :xxx@xxx.xxx
Website:

what i want is a report have null fields reorderd like

phone:
address:
website:

NOT LIKE :

phone:
address:

website:

 

[arnelgp]

i got you right, if you view the report in print preview it will do what you want it to appear.
anyway, i already fixed it also in report view.