Question:
Hi,
I want to put a graph in a web query (in Web App designer) but I don't find any place to select the origin of data.
Graph is always for all columns.
Any idea?
Regards.
Answer:
If I have a query with 10 columns and I want a different chart for every column, do I have to create 10 different queries??
Does not exist any way to select the query column on what I want to create the chart??
regards.
Answer:
Hi
you have to define different data providers which base on the same query.
In the data provider you select your column with
<param name='FILTER_IOBJNM' value='.....'/>
<param name='FILTER_VALUE' value='.....'/>
Hope it helps
Answer:
If I have a query with 10 columns and I want a different chart for every column, do I have to create 10 different queries??
Does not exist any way to select the query column on what I want to create the chart??
regards.
Depending on the chart type, the answer is no and yes. You don't have to create a query for each chart. You can reference the same query, but select the column(s) you want to look at by setting the number of columns and the offset (where to start pulling the columns).
I think this was discussed before in this fourm, but I can't tell you at the moment where to look in the chart editing, as its been a while since I have done this. I believe if you look at one of the bar charts you can find this somewhere in the chart options.
- Stephen
_________________
As a rule I don't answer Questions in PM.
(this is not to be a d**k, but it is to allow everyone to benefit from information. Not just one person.) Ask a question in the forum and I will answer it if I can.