Dynamic variables in Reports

Comments

• fcs

  April 2015 edited 5:50PM

  Hello,
  
  Try to use:
  
  {$H+}
  procedure TForm1.FReport123_GetValue(const VarName: string; var Value: Variant);
  begin
  if VarName='StartDate' then Value:=startdate_dtp.Text;
  if VarName='EndDate' then Value:=enddate_dtp.Text;
  end;
  {H-}
  
  The H+/- are optional, I use short strings and I have to enable huge strings for these procedure.
  The GetValue function is an event in FastReport report.
  
  Regards
  Michal
• gordk St.Catherines On. Canada.

  April 2015 edited 5:50PM

  You can pass the value the way you are trying with out using the ongetvalue event.
  first look at the type of the value in your form is it a tdatetime value or a formated date string
  if it is a formated date string then you need to add extra string delimiters to pass it to the varaiable.
• GavinC

  April 2015 edited 5:50PM

  gordk wrote: »

  You can pass the value the way you are trying with out using the ongetvalue event.
  first look at the type of the value in your form is it a tdatetime value or a formated date string
  if it is a formated date string then you need to add extra string delimiters to pass it to the varaiable.

  
  I get the date values from a TwwDBDateTimePicker which is from Clever Components, but basically works the same as a normal TDateTimePicker. Now have tried just about every possible combination I can think of to try and manipulate the value, from DateToStr and from StrToDate and still it gives me either a Interger or Decimal value on the report.
  
  I have also double clicked on the frxReport1 component, and under Report -> Variables, I added a category and 2 variables, and then on the right screen, assigned a Date Function to the variable, but still no luck?
  
  What else could possibly be going wrong or what else could I try?
• gordk St.Catherines On. Canada.

  April 2015 edited 5:50PM

  Gavin the fact that you keep getting an integer tells me that you are passing in
  something that looks like this mm/dd/yyyy so the expression evaluator is doing division.
  dont forget that categorized variables are expressions.her is a tip to help
  empty the variable so it has no value. pass the value into the variable after loading the report
  instead of calling showreport call design report now look at the value of the variable if it is a date string it should have ' delimiters
  'mm/dd/yyyy ' not the above sample
  also check what diplay format the memo object that uses the variable is set to
  
  
• GavinC

  May 2015 edited May 2015

  gordk wrote: »

  Gavin the fact that you keep getting an integer tells me that you are passing in
  something that looks like this mm/dd/yyyy so the expression evaluator is doing division.
  dont forget that categorized variables are expressions.her is a tip to help
  empty the variable so it has no value. pass the value into the variable after loading the report
  instead of calling showreport call design report now look at the value of the variable if it is a date string it should have ' delimiters
  'mm/dd/yyyy ' not the above sample
  also check what diplay format the memo object that uses the variable is set to

  
  Thank you very much for the help. I had to use DecodeDate and manipulate the dates in order to display them correctly.