We help IT Professionals succeed at work.

RS report layout looks fine when displayed in windows form, changes when viewed in browser

PACCAST-DEV
PACCAST-DEV asked
on
359 Views
Last Modified: 2011-10-19
My RS report looks just like it does in the RS "preview" pane in VS when I run a windows program with the report view component that displays it. However when viewed in IE all the text in the labels and textboxes grow beyone the controls and gets cut off. Why does this happen and what can I do about it short of reducing the text size in all the controls. I would really like to be able to design once, check it out in one format, and be assured it will look ok in the other (ie, the browser) without having to check each report's display in each format.

PS. I am using "normal" fonts - Arial, Times New Roman.

thanks,
bmutch
Comment
Watch Question

Author

Commented:
report displaying in web page
heatsheet1.JPG

Author

Commented:
report displaying in windows form
heatsheet2.JPG
jgv

Commented:
From a quick look it appears that you have a font problem. This is especially noticable with the "METAL IN" and "CONTROL PROGRAM" in the centre of the report. Double check the fonts being used by each of the fields. Export the IE report to PDF and also print it to see if the layout is still messed up. I have had reports where a line is not visible on the window but shows up when printed or exported to another format. Have you tried running the report from another pc to rule out IE as the problem?
jgv

Commented:
Something else to check. In IE, open the Internet Options window and go to the Advanced tab. Check if the "Always use ClearType for HTML" is selected. If it is, uncheck it, close & reopen IE and run the report.

Author

Commented:
Hi jgv,

Yes, I inherited this report and imported it from Access, and you're right those 2 fonts were some strange thing - Normal, Haettenschweiler so that explains those 2.

But the rest are either  Arial or Times New Roman.

I unchecked Always use ClearType for HTML but it looks the same. I look at the "View Source" of the web page generated and the style it is applying looks the same size and font that I am setting in the designer.

I looked at the page in 2 other computers and it is the same.

I exported to pdf and it solved most of the problems (except it totally lost the "Heat Sheet" label in the title.
but then it added more problems, now it prints one "good" page, followed by about 10 pages with nothing but the title, leaving me with a document with 250 pages instead of 25.

So far I am not too pleased with RS as it does not seems to be fulfilling it promises of a better reporting tool after our company just moved to it from Crystal Reports.

Uploaded is some of how the pdf looks after exporting...



heatsheetPDF.JPG
jgv

Commented:
If you can upload the report it might be easier to look at it directly. If there's any sensitive info, remove it first. You will have to rename the file from a .rdl to .xml; EE does not allow .rdl's to be uploaded.

Author

Commented:
here it is. It wouldn't let me do .xml, so I used .txt...
HeatSheet.txt
jgv

Commented:
Ok, the reason you are getting all of the extra pages is because you have the list object and report body width set to 87.04161 inches wide. As far as page width and height, the designer is WYSIWYG with the exception of margins. Reduce the width of the list object and report body below 8 inches and most of the extra pages will go away (use the "Size" Height and Width properties to see the width/height and to quickly change them).

For the title (Heat Sheet), increase the height of the text box and move the field just below it (Furnace #) down just a little; you want to prevent overlapping with textboxes.

Also, make sure you are running the latest service pack which is service pack 2 (both SSRS 2000 and 2005). Sometimes weird issues (like font rendering) are resolved in a service pack. It's a good place to start anyways.

Author

Commented:
thanks, I the list is now .75 in. But it won't let me reduce the width of the body at all..
Maybe this came about because I imported the report from Access, just didn't notice it...

Author

Commented:
Never mind, thought you were talking about the list control object. All is ok now.
jgv

Commented:
Yeah, it can be frustrating working with SSRS especially when you first start out. I find that there are many poorly implemented features or features missing altogether but it is a decent reporting system overall and there are some features that I really like. It also hasn't been around that long so it will continue to improve. Hang in there and try not to get too discouraged :)

Author

Commented:
Thanks.
Well, I meant all was ok with the extra pages in the pdf file, the text formatting issues and difference between windows display and web display remain.

do you see the issues in the report I sent you in web display?
jgv

Commented:
I just looked at it in a dev environment I have a home. It is screwed up after it's published and I suspect that it was due to being imported from access. Import utilities rarely work properly and you are seeing some of the problems you can have.

For the textboxes that have the bottom line cut off, you are going to have to remove the value from the LineHeight property (it should be blank) and set the VerticalAlign to "Top" (which is the default). You are going to have to increase the height of some of these textboxes as well because some of them are just too short to properly display the text.

Try applying these changes and let me know if there are other specific issues.

Author

Commented:
ok, I'll check these out. It just annoys me however that it looks ok in the designer, and in the windows form, but not in the web page.
jgv

Commented:
Once you make those changes the differences will not be as radical as they are now.

Author

Commented:
yes, I accept that. It just seems that you should be able to have it display in whatever viewer you are using the same as it displays in the designer.

Author

Commented:
Thanks,
Don't know how I'd known about the LineHeight issue if you hadn't mentioned it. I clicked help on the textbox , and lineheight is not in the member list. I found it searching for lineheight in help but this is all it had to say:

Describes the height of a line of text.
LineHeight contains an expression that evaluates to a point size. The minimum value for the LineHeight element is 1 point. The maximum value is 1000 points.
LineHeight applies only to text box, subtotal, title, and legend report items.

Again, is annoying it looked ok in designer but in on web page...
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
thanks for all you help jgv.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.