Preview Does Not Match Website
SSRS 2008 R2
IE 8.0.6
I created a text box in Visual Studio 2008 with the following expression:
=
"Backlog:" & chr(10)
& " All: " &
format(Sum(Fields!Total_Backlog.Value, "backlog"),
"C") & chr(10)
& " Past Due: " & format(Sum(Fields!Past_Due_Backlog.Value,
"backlog"),
"C")
When I preview my report, it shows multiple spaces between the ":" and "$" the way I want it to. However, when I deploy and view it in IE8 it only shows one space.
How do I make the preview and IE allways match and how do I get IE to show the extra spaces?
Thanks,
Scott
May 11th, 2011 11:43am
Hi, Scott
This is the behavior of the HTML rendering extension. There are subtle differences in the way each renderer outputs text. I would recommend that you place the label text (i.e. "All:", "Past Due:", etc.) and the field values in separate textboxes.
I typically use a table with separate columns to ensure that they align correctly.Paul Turley, MVP, www.SQLServerBIBlog.com *Please vote if helpful*
Free Windows Admin Tool Kit Click here and download it now
May 11th, 2011 12:42pm
Not the answer I wanted but it makes sense.
Thank you!
May 11th, 2011 12:45pm