calculating within a TfrxMemoView

Comments

• gordk St.Catherines On. Canada.

  December 2012 edited 2:15AM

  try
  [((<frxDBDataset1."laZeitaufwand">)*(<frxDBDataset1."KostenBearbeiter">))]
  
  or try using frs built in expression builder to get your brackets in correct position.
  
• smeagol

  December 2012 edited December 2012

  wrote:

  try
  [((<frxDBDataset1."laZeitaufwand">)*(<frxDBDataset1."KostenBearbeiter">))]

  Error: "((" is not a valid Integer-Value
  

  wrote:

  or try using frs built in expression builder to get your brackets in correct position.

  are you kidding me?
  if i do that i get [<frxDBDataset1."laZeitaufwand">*<frxDBDataset1."KostenBearbeiter">] without any brackets.
  this expression resolves also in a Error!!!!!!. see my post above.
  
  and
  
  this also results in an error: "<f" is not a valid Integer-Value
  [SUM(<frxDBDataset1."laZeitaufwand">)]
  made with the expression-builder
• gpi

  December 2012 edited December 2012

  Check your field data types and null values
  See report template for FRDemo in attach - [<Customers."Cust No"> * <Customers."Cust No">] expression works OK

  test.fr3 1.5K
• technisoft

  December 2012 edited 2:15AM

  smeagol wrote: »

  are you kidding me?
  if i do that i get [<frxDBDataset1."laZeitaufwand">*<frxDBDataset1."KostenBearbeiter">] without any brackets.
  
  [SUM(<frxDBDataset1."laZeitaufwand">)]

  As far as I can see both formulations should work fine.
  
  
• smeagol

  December 2012 edited 2:15AM

  If I open the Report within the FR-Designer and after that I click on the Preview-Button it works.
  
  If I call the Report while my Programm is running (frxReport1.ShowReport) then I got the Convert-Error as I reported above.
  TfrxDBDataset knows all selected fields from the Query. The Fieldtype of "laZeitaufwand" is fftNumeric. The fieldvalue isn't null.
  
  I use FR Version 4.13.1 with Delphi XE2.
• smeagol

  December 2012 edited 2:15AM

  I've found the problem. It seems it was my mistake.
  
  If you use Expressions like Sum() the event OnNewGetValue was fired. I also have user-defined-variables in the report.
  To make it easier to find out which Varname is requiered (in the OnNewGetValue-Event) my Variables obtain a numeric prefix e.g. 01MyDate, 02MyColor.
  
  I didn't know about this circumstance and I don't check the Varname. I copied the first two Chars of the Varname and want to convert them to an Integer with StrToInt.