This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.
Report items spread out when report is rendered in Report Builder 3.0
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?
Who is Participating?
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.
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.
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
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.