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_idsubject_id intissue_id intdate_reported datetimeagent_idHe 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_idIn 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? thanksWhisky-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