Hi Dblank,
happy new year
I tried several things but no correct results.
i have the following set up in my report:
Group 1 (Dock)
4 Group 2 (Cargo) loaded loading started
A Y
B Y
5
C Y
D N Y
7
F N
8
G N
9
H N
10
X N Y
15
Y N
17
Z N
what i want to do is ,add textobjects in one section,every textobject represents the dock,
and give background colors when criteria's are matched.(status 1 or 2 or 3)
I want to give three colors:
Red: if the dock is occupied,means not loaded
Orange: if the dock is under loading,means loading started
Green: if there is no record,means dock is available.
As you can see,at one dock there can be more cargo's,example above:
dock 5 :cargo C is loaded ,cargo D is under loading,so this should get orange color in the textobject as backgroundcolor.
I have already created a formula for the status of the dock,which returns 3 values:
status 1:Occupied (RED)
status 2:Busy (Orange)
status 3:Not occupied (Green)
So,what i need to do is the following:
first:
create a formula for group 1 (dock) and check every record (group 2) and return one of the above values.
i thought it was possible with Recordnumber mod,but this did not worked.
second:
create a formula for the background-color for an textobject ,which checks every record on grouplevel.
if the formula finds a record ,and depending on the status it gives the correct color.
if he doesnot find a record it will be green.
i think i have to use local variables or shared variables,but i am not familiar with this syntax.
i hope it is clear for you.
regards,
memoli
IP Logged
