Rearrange Report Fields after hidden some other fields (1 Viewer)

alvingenius

IT Specialist
Local time
Today, 18:06
Joined
Jul 10, 2016
Messages
169
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

PHP:
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
 

Attachments

  • 1.png
    1.png
    38.3 KB · Views: 83
  • 2.png
    2.png
    39.9 KB · Views: 91
  • Test.accdb
    524 KB · Views: 70

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 00:06
Joined
May 7, 2009
Messages
19,169
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?
 

Attachments

  • Test.accdb
    1 MB · Views: 65

alvingenius

IT Specialist
Local time
Today, 18:06
Joined
Jul 10, 2016
Messages
169
it's a printed report to fill , your suggestion is to fill it in form
and i want to print Null Fields only
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 00:06
Joined
May 7, 2009
Messages
19,169
i see, please try this.
 

Attachments

  • Test(1).accdb
    576 KB · Views: 60

alvingenius

IT Specialist
Local time
Today, 18:06
Joined
Jul 10, 2016
Messages
169
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

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 00:06
Joined
May 7, 2009
Messages
19,169
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.
 

Attachments

  • Test(1).accdb
    576 KB · Views: 65

Users who are viewing this thread

Top Bottom