Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.
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.
![[Webinar] Lessons on Recovering from Petya](https://filedb.experts-exchange.com/files/public/2017/7/11/dcb3272a-62a8-4274-a34e-d1771610ec3b.png)
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
Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Written by Valentino Vranken.
Introduction:
The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source. The data…
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data.
But that feeling is fleeting. Attacks these days can happen in many w…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day.
…
Suggested Courses
Course of the Month8 days, 4 hours left to enroll
610 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.