Reports with a little work...

[Marcelo Rojas O.]

Hi everyone...



I have the database working, but i have to make a print report (okidata 321) with this apparience:

Client....|............ State ..........| other data
..............1.......2.......3.......4...|....... ........
--------------------------------------------
client 1 | 12/03......................| blablabla
client 2 | ...............15/03.......| (idem)
client 3 | .......15/03...............| (idem)
client 4 | ......................10/03| (idem)
client 5 | 14/03......................| (idem)

and so on for another clients...

It's easy to make this:

Client....| State | other data
---------------------------
client 1 | 1........| blablabla
client 2 | 3........| (idem)
client 3 | 2........| (idem)
client 4 | 4........| (idem)
client 5 | 1........| (idem)

But i have to explain the report more graphically..

The State field asume four possible state: 1, 2, 3, 4.
The "10/03" is indicating the actual client's state (the date when arrive to the state)).

Can i put a "If.. then" in place of state on the report? as this
Client....|....................................... ................. State .................................................. ..............................| other data
...........|..............1....................... .......2................................3......... .......................4.......................... .....|
client1...|.(If 1 then view)............(If 1 then hide).............(If 1 then hide)............(If 1 then hide)........................|
client2...|.(If 3 then hide).............(If 3 then hide).............(If 3 then view)...........(If 3 then hide)........................|
client3...|.(If 2 then hide).............(If 2 then view).............(If 2 then hide)............(If 2 then hide)........................|
client4...|.(If 4 then hide).............(If 4 then hide).............(If 4 then hide)............(If 4 then view)........................|
client5...|.(If 1 then view)............(If 1 then hide).............(If 1 then hide)............(If 1 then hide)........................|

How to make it? any ideas?

Thanks... Please, ask me for more details if you need more... can i to write a link with this entire work?

[RuralGuy]

I don't know if I completely understand yet but you can certainly post your db. Just Compact and Repair and then zip it up first.

[Xipooo]

Use an IIF() function in the control source to either display the value or display a blank space:

=IIF(<FieldName>=1, <FieldName>, "")

or if you don't want the value to show when it is equal to 1.

=IIF(<FieldName><>1, <FieldName>, "")