Devart Forums

Hello,

I have two simple questions regarding generating reports.
1. I have a query, where I get the number of sold products group by month and department from.
Now I want to have a chart for each department where I can see the number for 1 department.
If I add a chart to the GroupFooter, it shows all departments in 1 chart and I dont find an option to select or filter this. How can I achive this?

2. If I create a report through command line, the file receives the datetime as suffix with spaces.(e.g.:name 20160819 1414). Is there are an option to change the suffix or is it possible to replace the spaces with underscores?

Thank you in advance
Pascal

1. I have a query, where I get the number of sold products group by month and department from.
Now I want to have a chart for each department where I can see the number for 1 department.
If I add a chart to the GroupFooter, it shows all departments in 1 chart and I dont find an option to select or filter this. How can I achive this?

We recommend you to see the demonstration project Sakila that contains the samples of using data reports http://blog.devart.com/quick-start-in-d ... oject.html

Also, we recommend you to see the 'Creating simple Data Report' demo video https://www.devart.com/dbforge/oracle/s ... -more.html

and the following material:
https://www.devart.com/dbforge/mysql/st ... eports.htm
https://www.devart.com/dbforge/sql/stud ... tml#header
https://www.devart.com/dbforge/sql/stud ... tml#header

2. If I create a report through command line, the file receives the datetime as suffix with spaces.(e.g.:name 20160819 1414). Is there are an option to change the suffix or is it possible to replace the spaces with underscores?

This can be performed as follows: Please also see https://www.devart.com/dbforge/mysql/st ... d_line.htm

For more help on the command, please type the following in the command line prompt:

Thank your for your answer.
I tried the the demonstration project and the links, but they weren't useful.
I have the following structure:

Groupheader (group by year)
Groupheader (group by department)
Detail
Month: xxx Count:xxx
Groupfooter
HERE: I want to have a line chart only with the values for 1 department for 1 year, which I group by.
Problem: I get a chart with the values for each department in 1 chart
Groupfooter

Or do I need for each diagramm an extra query?

My Query is like:
Select department,month,year,count(number)
from records
group by department,month,year

2. I used an older version of dbForge, so I hadn't this option.

Sorry for the delay on this.

Unfortunately, we didn't quite understand what you are aiming to achieve. You may need to find out what relation exactly needs to be specified on the diagram and, specify a column for arguments along with a column for values in the data source settings of the the chart wizard.

I want to have a chart, which contains the data for one department(I group by) and will be render for each department.
Reportstructure:
(Group By Department)
---------------------------------------------
Department 1:
Month: January Amount:200
Month: February Amount:20
...
Month: December Amount:3000

Line Chart with the data of Department 1
--------------------------------------------
Department 2:
Month: January Amount:20
Month: Feb Amount:2000
...
Month: Dezember Amount: 2312

Line Chart with the data of Department 2
--------------------------------------------------
So the question is, is there an option to use only the data I have in this group or do I have to create for each department another chart and query?
Or in other words: is the chart only bound to the query or is it possible to bind it to the query and the group, which contains the chart, to filter?

If I use auto-created series the chart contains all departments are in one chart and if I use series-bindung I have 1 line with multiple values.

In the 'Data -> Series Binding' section of the the Chart wizard, you can setup the filter for which you need to manually specify a concrete value. If the filter needs to be calculated, a separate query have to be made and defined as a data source for the chart.

Thank you for answering my question.
Too bad that's not possible to generate the chart as easy as the data.
Maybe this could be a new feature?

Unfortunately, this won't be implemented in the nearest future.