Solved

Report items spread out when report is rendered in Report Builder 3.0

Posted on 2016-07-28
12
43 Views
Last Modified: 2016-11-10
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?
0
Comment
Question by:edison04
  • 6
  • 6
12 Comments
 
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 41738938
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.
0
 

Author Comment

by:edison04
ID: 41739185
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.
0
 
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 41739210
A screenshot of your design then maybe with all the confidential stuff blanked out?
0
 

Author Comment

by:edison04
ID: 41739237
Here is the design.
EE-Design.JPG
0
 
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 41739667
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.
0
 

Author Comment

by:edison04
ID: 41739745
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.
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 22

Accepted Solution

by:
Nico Bontenbal earned 500 total points (awarded by participants)
ID: 41740259
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.
0
 

Author Comment

by:edison04
ID: 41741011
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.
0
 
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 41765028
Nice that I'm able to reward myself point now on EE. :-)
0
 

Author Comment

by:edison04
ID: 41784949
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.
0
 
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 41785174
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.
0
 

Author Comment

by:edison04
ID: 41882438
We found the solution to this. The problem turned out to be caused by inhereted css that our group was using as a standard template for all our stuff. Once the ReportViewer was given its own css class (cancelling out the inheritance) the problem was fixed.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

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…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

706 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

15 Experts available now in Live!

Get 1:1 Help Now