else 0 in a table

Hi,
Is it possible to display 0 in a table?
i have a table that drills down into Region and say for instance when
a region has no sales for that day i would like it to show as 0 not
not show on the report in crystal i would simply use a else 0 anynow
know how to achieve this in SQL reporting?
cheersOn Jun 12, 9:52 am, blueboy <matt_me...@.hotmail.com> wrote:
> Hi,
> Is it possible to display 0 in a table?
> i have a table that drills down into Region and say for instance when
> a region has no sales for that day i would like it to show as 0 not
> not show on the report in crystal i would simply use a else 0 anynow
> know how to achieve this in SQL reporting?
> cheers
If I am understanding you correctly, you should be able to include an
'if' statement as the expression for the cell/column you want to show
zero. Something like this should work:
=iif(Fields!Sales.Value is nothing or Len(CStr(Fields!Sales.Value)) <
1, 0, Fields!Sales.Value)
This basically says: if Sales is null/blank, return 0, else return the
Sales value.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Many thanks will give this a shot right now :-)|||Enrique
in my detail Row i have
Region Sales
=count(Fields!Region.Value) =SUM(Fields!Sales.Value)
i have 4 regions 1-4 what i want is it to show regions 1-4 even when
no sales have been done for that day. I have tried the above but it
doesnt seem to work and just returns the same value for the 2 regions
that have done sales and nothing for the 2 that have not.
i have used different variations of below in the column expression and
the detail expression
=iif(count(Fields!ARN.Value) is nothing or Len(CStr(count(Fields!
ARN.Value))) <
1, 0, Fields!ARN.Value)
Please can you point out where im going wrong?
Many Many thanks in advance