Showing active customers in report, when ExpireDate is NULL

[#1]

Hi,

I wonder how I can get my report to show only active customers.

I have a customer.qvd contains

Company_Id,

CompanyName,

StartDate,

ExpireDate

I want my report to show all customers where ExpireDate is NULL. I've tried to fix this in the SQL Select, in the load and as an Expression in my Company list box. Does anybody have a simple solution of this issue?

[#2 · Accepted solution]

Hello SEA,

As you tried a lot of different things my suggestion would be using a new field as a flag. Create it during loading with e.g.

Load .... if (Len(ExpireDate) =0, 0, 1) AS Expired; ..... From customer.qvd

In your charts etc. it is very easy to use like sum(Value * Expired). And even a simple listbox with Expired is useful.

HtH

Roland

[#3]

Thanks,

It worked.