Is it possible to have multiple breakfields in GET SUMMARY? I have two fields DATE and TRIP NO. which i need the summary for.
Personally, I would would ExecuteSQL instead.
Dont have any experience using ExecuteSQL. Couyld you pls assist me. How would i set up ExecuteSQL to find the summary based on two fields called Date & Trip No.? Thanks.
What kind of summary do you want? Do you want to add up all of the Trip No.s? Do you want to average the dates or get the highest or lowest? You probably just need a Summary field in the Sub Summary or Trailing Grand Summary part of the layout. Give us a better description of the records you have and what you want in the summary.
Retrieving data ...