Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
collie
Constraint Violating Yak Guru
400 Posts |
 Posted - 2009-03-14 : 10:53:40
|
Hi,
The client wants me to build him graphs.
The graph will be built based on a table tb_reported in the database that contains the fields:
app_id
subject_id int
issue_id int
date_reported datetime
agent_id
He wants to be able to have the following 2 options:
1) Be able to view how many issues or app_id or subject_id were reported between 2 dates.
Example: how many issues in total were reported between date1 and date2.
In this case for example if it's a line chart then there will be one line that will show how many issues in total were reported between the dates.
2) How many issues or app_id or subject_id were reported between 2 dates grouped by issues or app_id or subject_id
In this case for example if it's a line chart then all the different issues will be shown on different lines between the dates.
How can I know if the client wants to see on the line chart 1 or 2 above?
thanks
Whisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-16 : 14:18:05
|
| just add a parameter to decide on what grouping he needs to apply and based on data vary the category group property of chart |
 |
|
|
|
|
|
Charts in reporting services