Creating reports and dashboards | Stimulsoft community forum

Hi,

Is it possible to create the following chart?
1. In orders table,
X axis: Months (1~2 or Jan~Dec)
Y axis: Number of orders(base on OrderDate) at that month

2. In Employees table
X axis : City
Y axis : Number of employees lives that city.


Thanks

Hello,

jkoo wrote:Is it possible to create the following chart?
1. In orders table,
X axis: Months (1~2 or Jan~Dec)
Y axis: Number of orders(base on OrderDate) at that month

At this time it's only possible if the month will be as separate column of the table.

jkoo wrote:2. In Employees table
X axis : City
Y axis : Number of employees lives that city.

Please check the report sample in the attachment.

Thank you.

Thanks. Your sample is very helpful to me.
One more question,
I'd like to create a chart to number of orders per month over a past year.
So I can create one by adding a calculated column(OrderMonth) from OrderDate.
But, for example, if there is no data on October, there is no "October" argument on chart.
Instead, is there any way to show 0 values for "October"arguemnt on the chart?
So is it possible to display 12 arguments always even if there is no data for that argument?

Thanks

Hello.

jkoo wrote:Thanks. Your sample is very helpful to me.
One more question,
I'd like to create a chart to number of orders per month over a past year.
So I can create one by adding a calculated column(OrderMonth) from OrderDate.
But, for example, if there is no data on October, there is no "October" argument on chart.
Instead, is there any way to show 0 values for "October"arguemnt on the chart?
So is it possible to display 12 arguments always even if there is no data for that argument?

Unfortunately, there is no such feature. You should prepare data for chart by self.

Thank you.