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 |
|
v_kash
Starting Member
45 Posts |
 Posted - 2011-04-08 : 11:01:09
|
| hope this makes sense..i have a request to replicate a report that was done in excel. it has 4 matrix tables in a list , and then I need to display a graph. To keep it simple - after the 4th matrix that displays gross profit by month, i need to display a chart. The data for the chart is in a different data set. I put the graph in its own list control. Everything (both the matix and graph) is grouped by 'store name'. Right now, when running, the graphs do not show up after the matrix. They all show up after the last page of the 'matrix' has run. I want to keep the graph and the matrix together, but am having difficulties. Any help would be appreciated |
|
|
ssrstips.com
Starting Member
5 Posts |
Posted - 2011-04-12 : 09:56:08
|
| I think I read your post on another forum but didn't understand it (I'm not sure if I posted a reply saying that or not). Anyhow this is much clearer!The only way to do what you want is to create a subreport that takes a parameter which is the store name. Then you can have the matrixes and the chart in the report with two different datasets based off of the parameter provided. The list in the main report calls the subreport with the store name ... and it will all order correctly. |
 |
|
|
v_kash
Starting Member
45 Posts |
Posted - 2011-04-12 : 11:52:07
|
| So it would be an internal parameter? (i hope so, because all stores need to be returned on this report, with the graph showing up at the end of the last table for each store) |
|
|
|
|
|
|
2 Datasets - 1 is a matrix/ 1 is a graph - error