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 |
|
ruchikakkar
Starting Member
2 Posts |
 Posted - 2010-07-28 : 01:35:01
|
| I want to use stored procedure in which more then one query is written use this stored procedure in reporting servies to create charts .when i use stored query only first query is executed and show only first query result but i need all query results to show in a chart. plz help me how to do this. |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-07-28 : 01:37:57
|
| Yes. that is true. In report manager one must use only one Select statement per Dataset. Or only one Procedure per dataset. Break down your select statements per several datasets and you can join at the end all the datasets on|in one report.Regarding charts, i suggest you to pre-prepare the data such way you do not need to modify it later in report manager. |
 |
|
|
|
|
|
Charts in Reporting Services