Label9OnGetText " is not a valid Integer value

Comments

• nicocizik

  January 2023

  Hi Rajeev,
  
  This issue is in your RAP code. An empty string '', is not a valid integer so when you make a call to StrToInt with an empty string, the error will occur. Check the value of the DBCalc(s) before converting them to an integer. Also, I highly recommend using an intermediate variable to hold the integer sum before converting back to text.

  Best Regards,
  
  Nico Cizik
  Digital Metaphors
  http://www.digital-metaphors.com
• rajeev_kumar

  January 2023 edited January 2023

  Hi Nico,
  
  This is the formula which we are assigning in Label9OnGetText procedure.
  
  procedure Label9OnGetText(var Text: String);
  begin
  Text := (IntToStr(StrToInt(DBText2.Text) +
  StrToInt(DBText3.Text) +
  StrToInt(DBText4.Text)) ;
  end;
  
  As we are new in Report builder can you help on this to rewrite it.
  
  Thanks
  Rajeev
• nicocizik

  January 2023 edited January 2023

  Depending on the type of field value you are accessing with your DBText components, it is better to access the data directly from the database (pipeline).
  
  Also, since you are making calculations, I suggest using the OnCalc event of a TppVariable rather than the OnGetText of a TppLabel (which is extremely inefficient). Be sure to set the variable type to an Integer
  
  Assuming your fields are Integer types...

  procedure Variable1OnCalc(var Value: Variant);
  begin
  
    Value := MyPipeline['MyField1'] + MyPipeline['MyField2'] + MyPipeline['MyField3'];
  
  end;

  I suggest taking a look at the main RAP demo provided with ReportBuilder. This will give you a good idea how to us RAP code and the various features. Demo #1 shows how to make a calculation using a variable and pipeline values.

  Best Regards,
  
  Nico Cizik
  Digital Metaphors
  http://www.digital-metaphors.com
• rajeev_kumar

  January 2023

  Hi Nico,
  I will try this and let you know.Thanks for quick reply and support.
  
  Thanks
  Rajeev