How to convert the below statement into SSRS expression

• mcfarlandparkway

  SSCertifiable

  Points: 7699

  More actions

  May 5, 2014 at 10:17 am

  #396707

  Hello,

  I have an active report code where

  this.txtHdFiscalYear.Text=reportDataSet.Tables[1].Rows[0]["FiscalYear"].ToString();

  this.lblJulCount.Text= Convert.ToString(Convert.ToInt32(this.txtHdFiscalYear.Text) -3) + " Meal Count";

  this.lblSepCount.Text= Convert.ToString(Convert.ToInt32(this.txtHdFiscalYear.Text) -2) + " Meal Count";

  I am converting this into SSRS

  How can I write the above expression into SSRS ;I am trying to write in header field

  =Fields!FiscalYear.Value - 3 + " Meal Count"

  How to convert this.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  May 5, 2014 at 11:23 am

  #1710811

  Something like this should work:

  =CSTR(CINT(Fields!FiscalYear.Value) - 3) + " Meal Count"

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question