2. ASPRunnerPro General questions
  3. [SOLVED]  Custom View and Chart?
This topic is locked
[SOLVED]

 Custom View and Chart?

 		1/17/2011 20:42:03
ASPRunnerPro General questions
G
 GerryT author

I made the leap and purchased ASPRunner 6.3 today.
I have my database and everything seems to work fine except a couple of items that I wish to do but can not figure it out.

  1. My database contains a main table which has a ticket number, market and owner field. I am trying to have a custom view that only displays a certain market. I have tried the query examples in the manual such as
    SELECT
    FROM escalations
    WHERE Market =Jacksonville
    which did not work, i get the following error cannot retrieve columns information. Please modify SQL query and try again. ODBC too few paramaters. I even tried to replace the SELECT     to SELECT Market which did not make a difference.
    The other thing I want to do is have a chart of how many times the market is listed under market. A chart for number of escalations by owner. Both of these from the 22nd to the 21st of each month. When I attempt to create a chart it only lets me pick the primary key as data. I am unsure of how to do this.
    THanks!
Sergey Kornilov admin 1/17/2011

In SQL you need to wrap text values by single quotes:

WHERE Market='Jacksonville'


To build charts you can only use numeric fields. If you want to chart aggregate data check this article:

http://xlinesoft.com/asprunnerpro/docs/using_sql_to_shape_chart_data.htm
G
 		GerryT author 1/17/2011

Thanks, what about a custom view to view that will only display a specific entry in the table? Example: I have a table called market, that table contains New York and New Jersey. I want only entries for New York to be displayed.
G
 		GerryT author 1/18/2011

I figured it out, thank you for directing me to the right resources.