How to solve column width problems in SSRS Tablix?

Question

I am creating a simple report from Microsoft Dynamics CRM. When I retract the following dataset:

SELECT FQD.productidname
     , FQD.NEW_PRICEBREAKS
     , FQD.NEW_WEEKSARO
     , ltrim(rtrim(FP.NEW_PRODUCTNAME)) AS NewProductDesc
     , FQD.productdescription
     , FQD.quoteid
     , FQD.quantity
     , FQD.productiddsc
     , FQD.baseamount
     , FQD.lineitemnumber
     , FQD.priceperunit
     , FQD.extendedamount
     , ISNULL(FP.productnumber, '') AS productnumber
     , ISNULL(FQD.uomidname, '-') AS Unit
     , FQD.tax AS Tax
     , FQD.volumediscountamount * FQD.quantity AS Discount
     , FQD.manualdiscountamount AS MDiscount
     , FQD.quotedetailid
     , FQD.crm_moneyformatstring
     , FQD.NEW_PRICEPERUNIT
     , FQD.NEW_PRICEPERUNIT_BASE
FROM   FilteredQuoteDetail FQD
     LEFT OUTER JOIN
       FilteredProduct FP
     ON FQD.productid = FP.productid
WHERE (FQD.quoteid = @CRM_QuoteId)

The NewProductDesc field is too large. If I close it in design, it still comes out too broadly in the presentation. I think the field comes out so wide because there is probably a bunch of spaces at the end of each description in the database field. I could not find a way to make this field in Tablix not grow horizontally, so I tried to fix it in the dataset by replacing the NewProductDesc line with:

ltrim (rtrim (FP.NEW_PRODUCTNAME)) AS NewProductDesc

However, this has no effect.

Can anyone suggest why this behavior is happening? Can someone tell me how can I make the field not grow horizontally?

Answer 1

, , : 1.25in

, Trim() , SPACE() , ? .-

,