tips:revmedia:v2i1a4

QTIPS - Break-On Date Fields

Published ByDateVersionKnowledge LevelKeywords
Sprezzatura Ltd01 MAY 19901.15+EXPERTBREAK-ON, DATE

When breaking on a value such as a date, it is frequently desirable to include the date in the heading rather than display it for every record listed. This would normally be achieved using a syntax similar to

   LIST TIME_SHEETS BY DATE BREAK-ON DATE "'B'" HEADING "'B'"

Unfortunately this results in the date in INTERNAL format being displayed in the heading. To get round thus create a symbolic dictionary item (eg DS) with a display length of 0 and a formula similar to

   @ANS = {DATE} "D2/E"

and change the list statement to be

   LIST TIME_SHEETS BY DATE BREAK-ON DS "'B'" HEADING "'B'"

(Volume 2, Issue 1, Page 7)

  • tips/revmedia/v2i1a4.txt
  • Last modified: 2024/06/19 20:20
  • by 127.0.0.1