Question “How do I keep a running total of the previous page(s) in the header band of the current page being viewed?” Solution Place a TppVariable inside the footer band of the report to keep track of the running total until that point.  Then assign that value to a TppVariable located inside the header band  Full Article…

Question “How do I display totals calculated inside a subreport in my main report?” Solution Delphi: Update the main report variables directly inside the OnCalc event of a variable inside your subreport. RAP: Declare a global TppVariable from the Module view inside the code workspace (RAP). Set the global variable equal to a TppVariable in  Full Article…

Question “How do I count only the distinct records in my dataset using ReportBuilder?” Solution Keep track of the distinct records using a TStringList object. Download: CountDistinct.zip Sample Delphi code: procedure TForm1.FormCreate(Sender: TObject); begin FDistincts := TStringList.Create; end; procedure TForm1.FormDestroy(Sender: TObject); begin FDistincts.Free; end; procedure TForm1.ppReport1StartFirstPass(Sender: TObject); begin FDistincts.Clear; end; procedure TForm1.ppDetailBand1BeforePrint(Sender: TObject); var liIndex:  Full Article…