Stored Procedure?

[memcom]

Right before a report gets populated with new data, I need to have a set of SQL commands run to check to see if any value in a certain field is null and if so populate it with a given value. Is this possible from inside a crystal report? Can it be done with a stored procedure and if so, where can I get information on how to have Crystal use a stored procedure like this?

Thanks,
Michael

 

[bslokesh]

Hi
U can use Isnull(field,value) in stored procedure to check the value of the field in SP. If u r creating a temporary table and using the same in Report u should do this in SP. If u r not using Temporary table in SP then U can check it in report aslo using isnull function it returns true or false. if isnull(field) then statement1 else statement2
or if isnull(field) = true/false then statement1 else statement2

Regards
Lokesh

 

[phirst]

Hi Michael,

If you are using MS SQL Server you can use the COALESCE function
SELECT COALESCE(MyField, 'My value') FROM MyTable
If MyField is NULL this displays 'My value' instead.

As for Crystal you can also create a formula which does the same thing...

If IsNull(MyField) Then
'My value'
Else
MyField

Hope this helps.

Cheers,
phirst.