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 |
|
ReshmaRoseVincent
Starting Member
10 Posts |
 Posted - 2008-09-17 : 02:48:17
|
| Hii.. I'm generating graphical report using SSRS 2005 charts. As datasource to the report, i'm passing a table which has got 'Timestamp' field (X axis), 'ParameterName' field (series in legend) and 'MeasurementValues' (Y axis). The report is getting generating but i have a requirement to display seperate charts in single report based on another field in the table, named 'GraphName'. i.e. whichever parameters that are grouped under one graph name, should be displayed as a different chart within the same report. Hence a report can contain multiple charts and that is purely dynamic. IS THIS POSSIBLE WITH SSRS???? plsssss help me... Thanks in advance. :) |
|
|
reddyshekar
Starting Member
4 Posts |
Posted - 2008-09-18 : 06:44:02
|
| Hi,I think you can try by creating separate dataset for each chart.ThanksShekar |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-18 : 12:50:36
|
quote:
Originally posted by ReshmaRoseVincent
Hii.. I'm generating graphical report using SSRS 2005 charts. As datasource to the report, i'm passing a table which has got 'Timestamp' field (X axis), 'ParameterName' field (series in legend) and 'MeasurementValues' (Y axis). The report is getting generating but i have a requirement to display seperate charts in single report based on another field in the table, named 'GraphName'. i.e. whichever parameters that are grouped under one graph name, should be displayed as a different chart within the same report. Hence a report can contain multiple charts and that is purely dynamic. IS THIS POSSIBLE WITH SSRS???? plsssss help me... Thanks in advance. :)
You can create several charts inside same report. Just set them to your dataset and use 'GraphName' field to determine their visibility property. |
|
|
|
ReshmaRoseVincent
Starting Member
10 Posts |
Posted - 2008-09-19 : 03:26:53
|
| Well. as i told, i cannot insert multiple charts at design time coz i can never predict how many charts can be there in one report.. As i told its all pure dynamic data. :( . ane possible solutions to it..:( i need to fix this 2day itself... |
|
|
|
|
|
|
Help required to Group charts in SSRS