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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Data sets in SSRS

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

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
Go to Top of Page

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?
Go to Top of Page

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

Joshrinn
Posting Yak Master

118 Posts

Posted - 2012-05-24 : 20:58:04
Thanks.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-05-25 : 09:55:01
welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

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?
Go to Top of Page

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 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/

Go to Top of Page

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
Go to Top of Page

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

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
Go to Top of Page

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

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'.
Go to Top of Page

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 it
Page break on groups is fine. I was asking on page group after container (matrix) property

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

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?
Go to Top of Page

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

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>
Go to Top of Page

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

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
Go to Top of Page
    Next Page

- Advertisement -