| Author |
Topic |
|
Joshrinn
Posting Yak Master
118 Posts |
 Posted - 2012-05-22 : 09:54:26
|
| 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? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-23 : 15:45:20
|
| are the matrices nested? if not, you should be able to change dataset properties to make it point to another dataset------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-05-24 : 08:12:00
|
| 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 |
|
|
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-05-24 : 09:51:28
|
| 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? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-24 : 15:15:14
|
quote:
Originally posted by Joshrinn
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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-24 : 15:15:44
|
quote:
Originally posted by Joshrinn
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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-05-24 : 20:58:04
|
| Thanks. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-25 : 09:55:01
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-05-25 : 10:26:28
|
| 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? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-25 : 10:29:13
|
quote:
Originally posted by Joshrinn
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 canput the matrixes one parallel to other inside a rectangleMake sure you set report body size parameters in such a way that it comes in landscape mode rather than in portrait modealso 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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-05-25 : 10:36:03
|
| And in the meantime I had to display the charts too as there is a matrix and a chart and another matrix and a chart. Thanks for the above info |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-25 : 10:37:55
|
quote:
Originally posted by Joshrinn
And in the meantime I had to display the charts too as there is a matrix and a chart and another matrix and a chart. Thanks for the above info
so where does chart come? below each of matrices?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-05-25 : 10:47:11
|
| 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 |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-25 : 15:45:09
|
| 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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-05-25 : 15:57:29
|
| 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'. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-25 : 16:03:08
|
quote:
Originally posted by Joshrinn
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 itPage break on groups is fine. I was asking on page group after container (matrix) property------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-05-25 : 16:32:56
|
| 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? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-25 : 16:43:08
|
quote:
Originally posted by Joshrinn
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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-05-25 : 16:58:07
|
| 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> |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-25 : 17:05:28
|
| 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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-05-26 : 08:05:16
|
| 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 |
|
|
|
Next Page
|
Data sets in SSRS