title: How to set a Global Variable in SSRS Report Builder
body: <p>Condition:</p>
  
  <p>When value of one field in a row is greater than 1,000,000 then it's font size must be set to 6pt, otherwise, default 9pt</p>
  
  <p>I used this expression formula for that:</p>
  
  <blockquote>
    <p>=IIF(Fields!UNIT_RATE.Value > 1000000, "6pt", "9pt")</p>
  </blockquote>
  
  <p>for the uniformity of the report, other fields in all row must follow its font size based on the font size of this field.. but the challenge is, the formula is testing this condition per row..</p>
  
  <p>so it results to something like this</p>
  
  <p><a href="https://i.stack.imgur.com/hvDVm.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hvDVm.jpg" alt="enter image description here"></a></p>
  
  <p>Is there ways or right approach to fix this? where in the second row must also follow to that of first row, which auto adjust based on the condition provided?</p>
  
  <p><strong>My initial solution</strong> </p>
  
  <p>I am thinking of creating a GLOBAL VARIABLE TO CHECK first if there is a unit rate in the dataset which value is more than 1,000,000 then this global varible mist be TRUE.otherwise False, this will then be used as a varibale in each fields font size formula expression..</p>
  
  <p>BUT I DONT KNOW how to implement this as I am new to REPORT BUILDER</p>