How to read first or last or nth data record

Comments

• gordk St.Catherines On. Canada.

  June 2017 edited 3:03AM

  in reports onstaet report event movedataset to first record store field value in a variable move dataset to last
  store field value in another variable then move dataset back to first record
• witenite

  June 2017 edited 3:03AM

  gordk wrote: »

  in reports onstaet report event movedataset to first record store field value in a variable move dataset to last
  store field value in another variable then move dataset back to first record

  
  Sorry, but what is onstaet, and where do I find it. Is this something I set as script code (as a variable) or elsewhere?
  
  Another thought, is can I determine which record FastReport is presently processing (when generating a report)? For example, I know I can use <Line> to determine the line number presently being worked on in a report, but could I write some script that looks something like:
  
  if <Record> = 1 then DateVar = <frxDB."date">; // for first date record
  
  or
  
  if <Record> = <Record.Count> then DateVar = <frxDB."date">; // For last date record
• gpi

  June 2017 edited June 2017

  var StartValue, EndValue: Variant;
  
  procedure frxReport1OnStartReport(Sender: TfrxComponent);
  var DS: TfrxDataSet;                                                              
  begin
    DS:=Report.GetDataset('Items');
    DS.Open;
    DS.First;
    StartValue := DS.Value('Part Name');
    repeat DS.Next
    until DS.Eof;
    EndValue := DS.Value('Part Name');      
  end;