Page 1 of 1

Creating Dynamic Reports based on Query Results

Posted: Wed Sep 12, 2018 11:30 pm
by JeffK
Hi Everyone,
I'm trying to make a single report file that can handle reporting on a survey results that vary in question type and number of questions. For example, I have a query in my datastore that will fetch results of a survey. This survey has an indeterminate number of questions and each question is one of a finite set and I would like to have a single graphic for the results of each question. i.e. a likert scale question needs a bar graph, and a categorical question needs a bar chart). Is this possible?
So really my question is 2 parts.
1. can I conditionally display different graphs for a query based on the results of the query?
i.e. if( questions.questionType == "lickert"){ make bar graph}
else if(questions.questionType == "catagorical"){ make pie chart}

2. can I dynamically produce charts based on my query results
i.e. my query returns 10 rows, I have 10 graphs
my query returns 5 rows, I have 5 graphs

Thank you in advance!
-Jeff

Re: Creating Dynamic Reports based on Query Results

Posted: Fri Sep 14, 2018 1:44 pm
by Lech Kulikowski
Hello,

> 1. can I conditionally display different graphs for a query based on the results of the query?

Yes, it is possible, you can place Charts for all types and show necessary by Conditions.

> 2. can I dynamically produce charts based on my query results

Please place Chart component on the databand.
http://demo.stimulsoft.com/#Net/ChartOnDataband

Thank you.