assign value to a null 1

[Durango122]

Hi all
CR 9.0
ms sql
i have a field that contains a null value
when i run the report it works fine
my problem i would like to cast the null value to my selected paramter value parameter

my parameter is channel and if i select PC
i get pc but i need to see the null
is there a way to cast the null value to my paramter value
it's a string
thanks


Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[MrBillSC]

If I understand you correctly, you want a null value to be one of your default parameter values. If this is what you want, add a default value of "null" (without the quotes).

In you record select formula enter:
(IsNull({table.channel}) and
{?YourParameter} = "null") or
{?YourParameter} = {table.channel}

If you always want to see null values plus the parameter values enter:
IsNull({table.channel}) or
{?YourParameter} = {table.channel}

MrBill