Solved

SSRS Side by Side Reports

Posted on 2014-03-20
4
1,273 Views
Last Modified: 2014-03-22
I have just finished creating a series of SSRS reports and while I was showing the users the reports they had commented how they would like to see some of the reports side by side in the same report as opposed to having to run each report separately. Several of the reports take up only a portion of the screen and could easily fit either side by side or on top of each other. Is it possible to position reports side by side using SSRS in one report? This would be W2008 R2.
0
Comment
Question by:rwheeler23
  • 2
  • 2
4 Comments
 
LVL 39

Expert Comment

by:lcohan
ID: 39943406
Try to put two tables inside the same rectangle sitting side by side in one single SSRS report.


http://www.sqlservercentral.com/Forums/Topic842229-147-1.aspx
0
 

Author Comment

by:rwheeler23
ID: 39943470
So I should be able to just make the text box big enough to hold two reports and put one on top of the other? How will it handle the datasets? The are different for each report.
0
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 39943613
"So I should be able to just make the text box big enough to hold two reports and put one on top of the other?"

Yes indeed but side by side not "one on top of the other"

" How will it handle the datasets? The are different for each report. "


I suggest you choose one of them and copy the data set(or create new one identical with the one) from the second report, then copy (or create new) Tablix from second report and place them side by side.
0
 

Author Closing Comment

by:rwheeler23
ID: 39947820
Looks like subreports are the way to go with this. The trouble is one of geometry. There is only so much space on the screen.

Thanks for the tips.
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now