title: display specific number of significant figures rather than decimal places in crystal reports 2008
body: <p>Good Morning!</p>
  
  <p>I am working in Crystal Reports 2008 &amp; have a report template that I'd like to use with various dynamic parameters (called in a downstream application). </p>
  
  <p>My data can vary from being on a scale of 0-1 to a scale of 1,000-10,000.</p>
  
  <p>I'd like to display it with 3 significant figures so when the report pulls in a dataset that </p>
  
  <p>looks like this --> displays like this</p>
  
  <p>0.76895 --> 0.769</p>
  
  <p>0.6672 --> 0.667</p>
  
  <p>1.0335 --> 1.03</p>
  
  <p>but when the data set</p>
  
  <p>looks like this --> displays like this</p>
  
  <p>12,125.65 --> 12,100</p>
  
  <p>956.35 --> 956</p>
  
  <p>4,352.22 --> 4,350</p>
  
  <p>My current work around is to make two templates-- one to use with my small value data, set to display 3 decimal places; and another to use with my large value data, set to display no decimal places.</p>
  
  <p>I was wondering if there was a way to set significant figures displayed rather than decimal points?</p>
  
  <p>Oh! I would do it in SQL first and pass it in as a string but I need these as numeric values so I can summarize them elsewhere in the report. Thanks.</p>