View Full Version : SQL expression field is not displayed on the page header if no records


bossun
07-17-2008, 04:39 AM
Hello

I'm creating a quite simple report. In this report I've got a SQL expression field which returns a DateTime

I display this field on the page header section.

Everything is working fine except when my principal query doesn't return any records my SQL expression field is not displayed. It doesn't seem to be evaluated.

So, I would display this field even if my Details Section doesn't contains any record.

I hope you understand what I mean.

Can someone help me?

thanks

Kempes
07-17-2008, 07:20 AM
This is because it is a product of the displayed data.
No records = No Date to display.

Is the date a pre-determined point in time? (eg, yesterdays date, or last weeks date)???

bossun
07-17-2008, 11:21 PM
Is the date a pre-determined point in time? (eg, yesterdays date, or last weeks date)???

unfortunately not. it whould have been easy in this case but I have to fetch this information from a table.

cheers