Creating Dynamic Reports based on Query Results

Stimulsoft Reports.WPF discussion
Post Reply
JeffK
Posts: 2
Joined: Wed Sep 12, 2018 4:19 pm

Creating Dynamic Reports based on Query Results

Post 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
Lech Kulikowski
Posts: 6254
Joined: Tue Mar 20, 2018 5:34 am

Re: Creating Dynamic Reports based on Query Results

Post 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.
Post Reply