Empty /Blank Fields within Crystal

[dannyb29]

Hi All,
I am trying to bring back a value from a field when a different field is NULL, but I am struggling with syntax. Can anyone help. I will try to illustrate what I mean.

Stock count table

Date/Time ProdCode ProdDescrp NoItems UserID
11/01/10 00:00:00 0001 Salted Nuts 100
11/01/10 00:00:01 0001 Salted Nuts 80
11/01/10 01:00:00 0001 Salted Nuts 80 432

Where a UserId is present a physical stock check has taken place. I have to capture the last value of a genuine movement and the figure the member of staff has entred as past of the of stock check. In this senario I would want

ProdCode ProdDescrp System Vlaue Stock Check Value (0001 Salted Nuts 80 80) These values should be set out in tabular form like the above but I think there is a problem with this page...

I have managed to figure out how to retreive the system value but i am struggling with the Stock Check Value.

I tried something like this but to no avail. This is because the value is a NULL not a value. (

If{ServiceCentreStocks.UserId} < = 0 Then
{ServiceCentreStocks.ItemCount} else 0

Many Thanks

 

[lbass]

Well, what is the purpose of the start date if you still want to include earlier dates?

If you only want accounts where there is activity in a period, then maybe you should only use the end date in your record selection formula and then use a group selection formula that requires the maximum date to be greater than the {?startdate}.

-LB