November 3, 2011 at 5:35 am
Hi All
I have designed a report, which is padding out text in the text boxes although the columns in the table are set to centered (please see attached JPG for the design view and the report)
Query the table asking for the column and the length of the column are a match, so I dont see how RS is padding this out, any help is appreciated.
November 3, 2011 at 5:58 am
I think this is just BIDS trying to wind me up, and succeding. :angry:
Deployed the report the server, run it, all its all fine, no padding, the row isn't expanding. :crazy:
November 3, 2011 at 11:01 am
This indicates to me that you have trailing spaces on your data. Try adding RTRIM (I would probably also add LTRIM) to your data, or a TRIM to your textbox. HTML will drop more than 1 consecutive space so reports in Report Manager may look the way you want however exports to other formats may not so you may want to dig into this just a little more.
November 3, 2011 at 12:43 pm
that's what I thought but the data isn't padded in the db with extra spaces, that was my first check, it must be something in bids which is doing it
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply