Rollup Using SSRS Expression and make a row bold

Hi,

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
   

    

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
  

   

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