August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!
COURSE of the MONTH
10 days, 5 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Report items spread out when report is rendered in Report Builder 3.0
Posted on 2016-07-28
I have a large report, and have designated the InteractiveSize and Page Size as 17in,11in. When I render the report in Report Viewer, the charts and other items spread out and become unevenly spaced. If a .pdf is then created, the items appear evenly spaced as designed. The person that configured the Report Viewer is using the max width and height for display. How can I make my items stick together?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
6-
6
12 Comments
Are some items on top of other items in the design. See this article for more information about this:
https://msdn.microsoft.com/en-us/library/dd255248.aspx
If this doesn't solve the problem could you upload the design of your report here? Or at least describe the design in some more detail.
https://msdn.microsoft.com/en-us/library/dd255248.aspx
If this doesn't solve the problem could you upload the design of your report here? Or at least describe the design in some more detail.
Active today
Thanks, Nico. It was good information, but did not solve the problem. I am unable to upload the design because I would have to cut out too many things.
I had a couple of header rows above a 'grid' of 9 charts. In Preview and when making a PDF from the rendered report, the charts are in the correct location. However, in ReportViewer that has been designed for a 17in, 11in page, the 9-grid chart area moves down and leaves a 1.5 - 2 in gap below the header rows.
The columns for the charts below sometimes become uneven, but I sort of solved that by finding one that renders better in that way, copied it, then removed each chart and replaced it with the ones from the 'bad' rendering report. So that is sort of solved.
I am also having problems with some drillthrough links that I grouped into rectangles. Only one group/rectangle is visible on each report. When rendered in ReportViewer, they move out to the right beyond the main body of the report. I thought the article you referenced helped me solve that by unstacking those groups and giving them all their own space. But, that still did not solve the problem.
I guess my biggest problem now is the gap between the header and body.
I had a couple of header rows above a 'grid' of 9 charts. In Preview and when making a PDF from the rendered report, the charts are in the correct location. However, in ReportViewer that has been designed for a 17in, 11in page, the 9-grid chart area moves down and leaves a 1.5 - 2 in gap below the header rows.
The columns for the charts below sometimes become uneven, but I sort of solved that by finding one that renders better in that way, copied it, then removed each chart and replaced it with the ones from the 'bad' rendering report. So that is sort of solved.
I am also having problems with some drillthrough links that I grouped into rectangles. Only one group/rectangle is visible on each report. When rendered in ReportViewer, they move out to the right beyond the main body of the report. I thought the article you referenced helped me solve that by unstacking those groups and giving them all their own space. But, that still did not solve the problem.
I guess my biggest problem now is the gap between the header and body.
Active today
Here is the design.
EE-Design.JPG
EE-Design.JPG
I'm afraid I don't have an explanation for this problem. I don't use ReportViewer so I can't try to reproduce your problem.
What is the size of your design area (the body of the report). This is probably smaller or bigger than the 17/11in you set for your page size. You could try to set the body size of your report to 17/11in also.
Also you could try to set the Interactive size of the report to width: 0; height:0.
You can also set the background color (and/or border color) of the body of the report. That way you can see where the body of the report ends on the report viewer and on the pdf.
Maybe you can fix the problem by placing the charts inside rectangles. This is a rather frustrating process but rectangles saved me a few times when I had problems with positioning. You add a rectangle to the report and then drag a chart to the upper left corner of that rectangle. Then move the rectangle to the position where the chart was.
If all that fails I'm afraid you have to do step by step experimentation. Start with a new empty report and start placing items on it. Checking the position after every few items you place. As soon as items are getting misplaced in the ReportViewer resize and/or rearrange them until you see the logic in how ReportViewer messes things up.
Nice report BTW. I didn't know you could have concave pies and rounded borders in SSRS.
What is the size of your design area (the body of the report). This is probably smaller or bigger than the 17/11in you set for your page size. You could try to set the body size of your report to 17/11in also.
Also you could try to set the Interactive size of the report to width: 0; height:0.
You can also set the background color (and/or border color) of the body of the report. That way you can see where the body of the report ends on the report viewer and on the pdf.
Maybe you can fix the problem by placing the charts inside rectangles. This is a rather frustrating process but rectangles saved me a few times when I had problems with positioning. You add a rectangle to the report and then drag a chart to the upper left corner of that rectangle. Then move the rectangle to the position where the chart was.
If all that fails I'm afraid you have to do step by step experimentation. Start with a new empty report and start placing items on it. Checking the position after every few items you place. As soon as items are getting misplaced in the ReportViewer resize and/or rearrange them until you see the logic in how ReportViewer messes things up.
Nice report BTW. I didn't know you could have concave pies and rounded borders in SSRS.
Active today
The size of the report is smaller than 17/11, but I set it that large so that it would create a PDF with no page breaks. I will try the different back ground size, but I can't do it right away because we are without a dev environment at the moment.
I did try putting the whole thing into a rectangle, but not the individual items in their own rectangle. I did do that however, with the links in the top right but it didn't help. I will try that when I get dev back, along with the step-by-step build. I could have tried a fix right away, but not intermediate diagnostics.
I did try putting the whole thing into a rectangle, but not the individual items in their own rectangle. I did do that however, with the links in the top right but it didn't help. I will try that when I get dev back, along with the step-by-step build. I could have tried a fix right away, but not intermediate diagnostics.
I'm sorry. You question reminded me about the different rendering with overlapping items in HTML and ReportViewer. But since that seems not to be the cause of your problems, I'm afraid I don't have the solution for you. All I can do is give you some suggestions about how to try and find the solution. But most of those you'll have thought of yourself already.
One more thing about the rectangles. I find it difficult to see if an item is inside a rectangle or not. When I place a textbox inside a rectangle it is linked to the rectangle, but when I place a rectangle over a textbox they are overlapping. But in design those two situations look exactly the same. The only difference is the Location of the text box. When it is in the rectangle the location is relative to the upper left corner of the rectangle. So when the charts are not inside the rectangles, the rectangles could even be the cause of the displacement. To check this you can give your rectangles a distinct border color. Then you can see where they are placed on the report.
One more thing about the rectangles. I find it difficult to see if an item is inside a rectangle or not. When I place a textbox inside a rectangle it is linked to the rectangle, but when I place a rectangle over a textbox they are overlapping. But in design those two situations look exactly the same. The only difference is the Location of the text box. When it is in the rectangle the location is relative to the upper left corner of the rectangle. So when the charts are not inside the rectangles, the rectangles could even be the cause of the displacement. To check this you can give your rectangles a distinct border color. Then you can see where they are placed on the report.
Active today
That's a good point, Nico. I actually went into the rdl in xml format and unnested some of the rectangles and adjusted the relative positions inside the rectangles for the links. But, the charts are not in rectangles and their positions are relative to the report body container.
Active today
Nico, I suppose you deserve points because of so many good suggestions. I did not find the solution to my problem but appreciated your suggestions.
No, no problem. I'm not here for the point but to learn about SSRS. And due to a change in EE I could mark my own answer as the solution. So I wanted to try that. Maybe the best option is to delete the question so nobody with the same problem thinks the answer can be found here. Or you could request attention, briefly explain the situation and ask the moderator what the best option is in this situation.
Featured Post
![[Webinar] How Hackers Steal Your Credentials](https://filedb.experts-exchange.com/files/public/2017/5/20/3315d9d8-8110-4d52-be94-a5aacdd83e4b.png)
Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Introduction
As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset. This makes it troublesome when you need to display data from more than one dataset in the same data region. SQL Serve…
Hi All,
I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash"
After Shake : http://www.videocopilot.net/presets/after_shake/
All lightning effects with instructions : http://www.mediaf…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB.
To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month10 days, 5 hours left to enroll
762 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.