title: Unable to get data from stored procedure to ssrs report
body: <p>i am try to access data from stored procedure to ssrs report. but i don't get the answer. </p>
  
  <p>it shows the error "[rsRuntimeErrorInExpression] The Caption expression for the chart ‘Chart 4’ contains an error: The query returned no rows for the dataset. The expression therefore evaluates to null."</p>
  
  <p>I got data, when i execute the stored procedure in server management studio. but i don't get data in ssrs report.</p>
  
  <p>when i searched for the solution for this problem, some sites ask to add the following code in the beginning  </p>
  
  <pre><code>   declare @FMTONLY bit
  
     if (1=0) begin
         set @FMTONLY=1;
          set FMTONLY off;
    end
  </code></pre>
  
  <p>and end of the stored procedure</p>
  
  <pre><code>  if @FMTONLY=1
      begin
          set FMTONLY on;
      end
  </code></pre>
  
  <p>i did this but it is not working for me.</p>
  
  <p>i like to know what is the reason for getting this error?
  and how can i solve this error?</p>
  
  <p>thanks in advance</p>