Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
M_nwadibia
Resolver III
Resolver III

Rollup Using SSRS Expression and make a row bold

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.

 

M_nwadibia_0-1673044851583.png

 

3 REPLIES 3
Medina
Helper II
Helper II

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!

Yes I only want the last row made bold.

Hi,

Medina_0-1674853046977.png

To produce the output shown above, you need to:

  1. Create a blank report
  2. Create a data source, select "Enter Data" as your Connection Type, and click OK
    Medina_1-1674853464732.png

     

  3. 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
    Medina_2-1674853705345.png

     




  • Right-click on the detail row [Company] and select Text Box property
    Medina_4-1674853839703.png

     

  • 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.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.