There are two matrices on my report. Both matrix diagram share a common data set . I want the first matrix to share one data set and the other to use another data set. How do I configure this?
Yes Visakh they are nested actually. But if I want to add another matrix on te bottom I can change te datasets but it doesn't show up in my report. Also could you tell me how I can add a new rdl file on the existing solution please
I found how to add rdl file to existing solution. Now there is a chart that I have to change the dataset property for. Where would be the dataset properties for chart?
Yes Visakh they are nested actually. But if I want to add another matrix on te bottom I can change te datasets but it doesn't show up in my report. Also could you tell me how I can add a new rdl file on the existing solution please
Can you post a screenshot? I cant understand what exactly you're trying to do.
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
I found how to add rdl file to existing solution. Now there is a chart that I have to change the dataset property for. Where would be the dataset properties for chart?
just like table, matrx etc you can take properties of chart and link to dataset inside it
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
Hi Visakh. I took the nested property off from the report actually I created a separate report by putting 2 matrices. My problem now is I wanted both the matrix to display parallel on te same page but it gets displayed one matrix per page which is not how I wanted it. Can this be solved?
Hi Visakh. I took the nested property off from the report actually I created a separate report by putting 2 matrices. My problem now is I wanted both the matrix to display parallel on te same page but it gets displayed one matrix per page which is not how I wanted it. Can this be solved?
it can put the matrixes one parallel to other inside a rectangle
Make sure you set report body size parameters in such a way that it comes in landscape mode rather than in portrait mode also make sure combined width of matrices is not going beyond normal a4 page length else it will break over to next page when printed
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
Yes. Also what I did right now was inserted a rectangle and inside it put both the matrices parallel to each other but still displays one. Bare with me here Visakh because there might be something that I didn't do correctly
what happened when you used rectangle? is matrix still going to next line? have you set any property for page break for any of matrices? Also is total width falling with page width? Have you change report dimensions as suggested to make it landscape?
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
when i used the rectangle it just shows the first matrix. Yes a row group page breaks has been used, where I have checked marked on 'between each instance of a group'.
when i used the rectangle it just shows the first matrix. Yes a row group page breaks has been used, where I have checked marked on 'between each instance of a group'.
does that mean second matrix is not shown at all? Are you sure its inside rectange and not beneath it. sometimes if not drag it properly inside it will not be inside container but it will outside and beneath it so that when report renders it will be invisible as rectange comes over it Page break on groups is fine. I was asking on page group after container (matrix) property
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
Yes Visakh I put everything inside the container and it displays both the matrices in the same page thanks to you. What I did earlier probably did not match. But there is one another issue. Under row group properties of the matrix, if I check 'between each instance of a group', then it just displays one matrix. I don't know what is doing this?
Yes Visakh I put everything inside the container and it displays both the matrices in the same page thanks to you. What I did earlier probably did not match. But there is one another issue. Under row group properties of the matrix, if I check 'between each instance of a group', then it just displays one matrix. I don't know what is doing this?
so ideally how should it behave? once you give that property it will obviously break over to next page after each group. so unless it coincides with grouping in next matrix you'll have issues
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
actually both the matrices displays about 20 rows each. What I wanted was to display 1 row from each matrix in a single page going parallel for the next 20 pages. if you remember that day I had put a screenshot of months. It should display on the format shown below. http://i48.tinypic.com/25i18gn.jpg>
for that you might have put the data inside same container itself rather than two containers and apply grouping with page break commonly on same container
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
So I can still use different datasets or have to use the same, if I put it in a same container. Can you please give me details of what exactly needs to be done
Data sets in SSRS
Posted - 05/22/2012 : 09:54:26
