Totals Row in matrix not completely underlined
I'am using a matrix with a total row. I have set the BorderStyle top and Bottom to solid. This works fine if there is data for every column but when a column does not contain data, the line is interrupted. How can I make sure that there always is an uninterrupted line at the top and bottom of the total row?
November 24th, 2010 5:45am
Is this showing once the report is deployed, sometimes the preview in BIDS isn't an accurate representation of how the deployed report will look.My Blog "Karl Beran's BI Mumble"
November 24th, 2010 6:30am
It occurs in preview BIDS. When the report is deployed it looks fine but I need to export the report as pdf. In the pdf the problem occurs again.
November 24th, 2010 7:44am
Hi, Based on your description, I tried to reproduce this issue in my environment. However, the report works fine in Business Intelligence Development Studio, Report Manager and exported PDF. So could you post an example of the matrix and the specific version of your Reporting Service? If possible, please also send your report with sample dataset and one exported PDF to the E-mail address below. Then I will try to figure out the problem. E-mail: sqltnsp AT microsoft.com (Please replace the AT with @, and remove additional spaces) Thanks, Tony chainPlease remember to mark the replies as answers if they help and unmark them if they provide no help
November 26th, 2010 1:33am
Hi, I have received your E-mail and I’m glad you have solved the underline problem by using expression to the Color property. In addition, as another approach to hide the cell in which the value is 0, we can also modify the expression in the Data cell to =IIf(Sum(Cdec(Fields!ReportItemValue.Value))=0,Nothing,Sum(Cdec(Fields!ReportItemValue.Value))) However, when export the report to PDF, the width of the borders renders inconsistently. So I will continue to observe this issue and give you update if have some progress. You can also submit it at https://connect.microsoft.com/SQLServer/. Your feedback is valuable for us to improve our products and increase the level of service provided. If you have any more questions, please feel free to ask. Thanks, Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help
November 29th, 2010 12:10am