Wizard graph
Wizard graph
(OP)
I have a problem to display the value of date on one specific Graph (See Below)
I want to display the information Date (result of my query) on the field "Serie".
Because I am using a query "Group By" I am not able to force any column name.
And
I would like as well to display the result of the query when we click a bar on the Graph.
I just can't get it to work
{ PAGE NewComputer
{ LABEL NewComputerDaily
CAPTION = "<HR><B>New Computer Daily for the last Month</B><BR>"
}
{ CHART GraphNewComputerDaily
3D = 1
BACKGROUND = 0
{ CLICK =
Dim l As Long
l = amOpenScreen("amPortfolio", "", "dAssignment =" & {GraphNewComputerDaily.serie}, "", "")
}
COLORS = "255|16777215|255|16777215|255|16777215|255|16777215|255|16777215|255|16777215|255|16777215|255|16777215|255|16777215|255|16777215|255|16777215|255|16777215|255|16777215|255|16777215|255|16777215"
DISPLAYLABELS = 1
DISPLAYLEGEND = 0
ELEVATION = 60
FORMAT = "Long"
INDEX = -1
INTERACTIVE = 1
ROTATION = 20
SERIE = 0
SERIES = ""
VALUES = ""
}
{ COMMANDBUTTON ButtonNewComputerDaily
CAPTION = "Refresh"
{ CLICK =
amRefreshProperty("TimerNewComputerDaily.timer")
}
}
{ TIMER TimerNewComputerDaily
AUTO = 1
ENABLED = 0
INTERVAL = 5000
{ TIMER =
dim c0 as string
dim l as long
c0 = amDbGetString("SELECT Count(lPortfolioItemId) FROM amportfolio WHERE lPortfolioItemId <> 0 and Model.Parent.BarCode = 'SERV' or Model.Parent.BarCode = 'LTOP' or Model.Parent.BarCode = 'DTOP' group by dAssignment")
dim toto as string
toto = c0
l = amSetProperty("GraphNewComputerDaily.values", toto)
}
VALUE = 0
}
{ TRANSITION TRANSITION1
TO = "Workflow"
}
}
I want to display the information Date (result of my query) on the field "Serie".
Because I am using a query "Group By" I am not able to force any column name.
And
I would like as well to display the result of the query when we click a bar on the Graph.
I just can't get it to work
{ PAGE NewComputer
{ LABEL NewComputerDaily
CAPTION = "<HR><B>New Computer Daily for the last Month</B><BR>"
}
{ CHART GraphNewComputerDaily
3D = 1
BACKGROUND = 0
{ CLICK =
Dim l As Long
l = amOpenScreen("amPortfolio", "", "dAssignment =" & {GraphNewComputerDaily.serie}, "", "")
}
COLORS = "255|16777215|255|16777215|255|16777215|255|16777215|255|16777215|255|16777215|255|16777215|255|16777215|255|16777215|255|16777215|255|16777215|255|16777215|255|16777215|255|16777215|255|16777215"
DISPLAYLABELS = 1
DISPLAYLEGEND = 0
ELEVATION = 60
FORMAT = "Long"
INDEX = -1
INTERACTIVE = 1
ROTATION = 20
SERIE = 0
SERIES = ""
VALUES = ""
}
{ COMMANDBUTTON ButtonNewComputerDaily
CAPTION = "Refresh"
{ CLICK =
amRefreshProperty("TimerNewComputerDaily.timer")
}
}
{ TIMER TimerNewComputerDaily
AUTO = 1
ENABLED = 0
INTERVAL = 5000
{ TIMER =
dim c0 as string
dim l as long
c0 = amDbGetString("SELECT Count(lPortfolioItemId) FROM amportfolio WHERE lPortfolioItemId <> 0 and Model.Parent.BarCode = 'SERV' or Model.Parent.BarCode = 'LTOP' or Model.Parent.BarCode = 'DTOP' group by dAssignment")
dim toto as string
toto = c0
l = amSetProperty("GraphNewComputerDaily.values", toto)
}
VALUE = 0
}
{ TRANSITION TRANSITION1
TO = "Workflow"
}
}
RE: Wizard graph
Can you send to whole wizard over to me. I'll look at it for you.
thomaj3@hotmail.com
Jason Thomas
AssetCenter Consultant
www.corviz.com