topic Re: Rollup Using SSRS Expression and make a row bold in Report Server

Rollup Using SSRS Expression and make a row bold

M_nwadibia — Fri, 06 Jan 2023 22:44:37 GMT

Hello,

I have a requirement to make the total row bold but when I try this expression it makes the entire field bold.

=IIf(Fields!Submitted_Surveys_with_LMI.Value="Total","Bold","Default"). I want only the Row Total bold. If this cannot work how can I write an expression for RollUP for each field to get the total so that I can have control over fields.

Re: Rollup Using SSRS Expression and make a row bold

Medina — Thu, 26 Jan 2023 23:17:51 GMT

Hi,
Reading the expression, made me think the "TOTAL" is part of the recordset, if that is the case, I would apply the formatting condition on each column.
Please, let me know if I am not reading your question correctly.
Thanks!

Re: Rollup Using SSRS Expression and make a row bold

M_nwadibia — Fri, 27 Jan 2023 17:40:59 GMT

Yes I only want the last row made bold.

Re: Rollup Using SSRS Expression and make a row bold

Medina — Fri, 27 Jan 2023 21:14:55 GMT

Hi,

To produce the output shown above, you need to:

Create a blank report
Create a data source, select "Enter Data" as your Connection Type, and click OK
Create a Datasets, use the Data Source --> Query Type (Text) created in Step 2. Use the following, XML as the source

<Query> <XmlData> <Data> <Row> <Company>ACME USA</Company> <Total_A>100</Total_A> <Total_B>50</Total_B> <RowOrder>0</RowOrder> </Row> <Row> <Company>ACME Canada</Company> <Total_A>100</Total_A> <Total_B>40</Total_B> <RowOrder>1</RowOrder> </Row> <Row> <Company>ACME Mexico</Company> <Total_A>40</Total_A> <Total_B>100</Total_B> <RowOrder>2</RowOrder> </Row> <Row> <Company>Total</Company> <Total_A>240</Total_A> <Total_B>190</Total_B> <RowOrder>3</RowOrder> </Row> </Data> </XmlData> <ElementPath>Data{}/Row{Company(String),Total_A(Float),Total_B(Float),RowOrder(Float)}</ElementPath> </Query>

Add the table to the report
Right-click on the detail row [Company] and select Text Box property
Click the Fill option and enter the following expression
=IIF(Fields!Company.Value="Total","LightSteelBlue","Transparent")
Repeat Step 6 for the other columns

I hope it helps. Unfortunately, the forum does not allow me to upload the rdl or any other file format.