|
sz1
Constraint Violating Yak Guru
United Kingdom
294 Posts |
 Posted - 03/06/2013 : 06:56:04
|
Hi
I have a table with changing colours that tell me what stage a ticket is at, for example RED = today, GREEN = tomorrow and BLUE = before today.
The date returned is good which I've grouped together the colours based on sort: Agreed_Solved_Date_Time, Status, I want the Status field to always Z-A so they are grouped together but I also still want to keep the colours together, obviously if I remove the Agreed_Solved_Date_Time from the sort we get the Status at the top but the colour grouping is then thrown all over.
There is a colour function populating the actual colours which is:
Public Function fnGetConditionalColor(pDate as datetime) AS String
Dim d AS integer
Dim c as string
d= DateDiff("d", pDate.Date, Now.Date)
IF d<0 THEN
c="Green"
ELSE IF d =0 and d <=1 THEN
c="Red"
ELSE
c="Blue"
END IF
Return c
End Function
Can this be achieved using this method, how can I first call the function to use in the report for the first sort followed by the Status field.
Screenshot of current report.
http://www.pcfixerman.com/index.php/screenshot
As you can see I want the WIP at the top of the colours but still maintaining the colours together?
Thanks in advance.
SZ1
Learning and development is the driving force in the universe...! |
|
Grouping with colours
