Multiple lines on graph

[trwalker]

Hi Guys,

 

I have generated a simple line graph using a query, using the report query, and passing the necessary data to the graph, great, woohoo I hear you say. However, I need to actually have 4 sql queries, returning 4 sets of results, that I need to display on the graph as 4 traces. What is the easiest way for me to do this? I have tried to create a subdataset, but as far as I can see, this only lets me add one to the graph. Is there a way of creating 4 queries in iReports, and including them on the graph??

 

Thanks.

[trwalker]

i.e. I have created four subdatasets each having the same sort of query, but returning a different result. How do I access the returned fields from the subdatasets, and print them on the graph? Or am I barking up the wrong tree?

 

trwalker wrote:

Hi Guys, I have generated a simple line graph using a query, using the report query, and passing the necessary data to the graph, great, woohoo I hear you say. However, I need to actually have 4 sql queries, returning 4 sets of results, that I need to display on the graph as 4 traces. What is the easiest way for me to do this? I have tried to create a subdataset, but as far as I can see, this only lets me add one to the graph. Is there a way of creating 4 queries in iReports, and including them on the graph?? Thanks.

[kuchroo]

Its very simple to display multiple lines. For this you don't have to write any subdata query or multiple queries. You can simply select for multiple values by declaring a Parameter for multiple values eg: value in ($P!{parameter})

 

Giving a syntax like this will enable you to give multiple values for a single query. Also note that in GROUP BY clause give a group by of "value".

 

Hope this will solve your problem.