Aggregated functions on Date fields

Comments

• gpi

  April 2011 edited 7:40PM

  Do you have a records with blank date fields?
• Mick.pl

  April 2011 edited 7:40PM

  And yet make sure you call agregate function from memos on any summary band or from within its events.
  If this is OK try to find out as Gpi suggests by testing value of your data field like
  
  select MyData, IfNull(MyData, 'Y', 'N') as IsMyDataNull from AnyWhere
  
  Mick
  
• Leonardo Herrera

  April 2011 edited 7:40PM

  gpi wrote: »

  Do you have a records with blank date fields?

  
  No, I'm actually using the date field as filter in my query 'where' section.
  
• Leonardo Herrera

  April 2011 edited 7:40PM

  Mick.pl wrote: »

  And yet make sure you call agregate function from memos on any summary band or from within its events.
  If this is OK try to find out as Gpi suggests by testing value of your data field like
  
  select MyData, IfNull(MyData, 'Y', 'N') as IsMyDataNull from AnyWhere
  
  Mick

  
  Ah, I see. I was trying to use it in my Title band. How can I put this summary as a title in my report? Do I have to resort to scripting?
• Mick.pl

  April 2011 edited 7:40PM

  There are few options to do so.
  
  One of them is to make a report double pass, and within first pass calculate all as you need and put the values into variables. And within final pass use these variables to fill memos at TitleBand.
  
  Another is to make an extra query that will give you summary values at once without double pass report or waiting for any summary bands.
  
  Mick