Aggregated functions on Date fields

Leonardo Herrera

Hello,

Is it possible to use aggregated functions (MIN, MAX) in Date fields? I just get blanks.

Regards,
Leonardo Herrera

gpi

Do you have a records with blank date fields?

Mick.pl

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

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

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

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