Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.
Course Of The Month
5 days, 1 hour 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.
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.
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.
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.
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.
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] Learn How Hackers Steal Your Credentials](https://filedb.experts-exchange.com/files/public/2017/5/21/e0b7778f-e79e-4b5d-9ec6-5496e40be42e.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. Thursday, July 13, 2017 10:00 A.M. PDT
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
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…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss. This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in. And this behavior is only see…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you!
In this Micro Tutorial, you'll learn yo…
- Microsoft Applications
- Windows 10
- Windows OS
- Fonts Typography
- Windows 7, Microsoft Word
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses
Course of the Month5 days, 1 hour left to enroll
688 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.