×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Wizard graph

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"
  }
}

RE: Wizard graph

Oliver

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close