Can we stop the database null values?How?

Answers were Sorted based on User's Feedback



Can we stop the database null values?How?..

Answer / ravi shanker

1. Go to Record!Selection formula.
2. Record!In the formula workshop.
isnull({Customer.Address2}) = false // Customer.Address is
the field

Is This Answer Correct ?    3 Yes 1 No

Can we stop the database null values?How?..

Answer / sourabh gosain

From my point of view one should never check the option
supress null values from file>report option. Coz it can
supress a complete group if you have grouping on a column
having some null values.
instead of it if you should go to section expert>detail
part> supress and writ a formula there
is null(column)
that make that row supressed if a particular column value
is null.

Is This Answer Correct ?    2 Yes 0 No

Can we stop the database null values?How?..

Answer / anamika

Yes, we can by selecting suppress if null option.

Is This Answer Correct ?    4 Yes 3 No

Post New Answer

More Crystal Enterprise Suite Interview Questions

13.Can we use Crystal report as a stand-alone application?

2 Answers   Bhawan Cybertek,


1.What is caching? What are the different types of caching? 2.Is there any feature like summing total in crystal report?

2 Answers   Bhawan Cybertek,


what the mean of version error in crystal?

0 Answers   Symphony,


"how much experience you have in crystal report ?"

1 Answers   CTS, Infosys,


7.Are there any limitations in crystal reports? 8.Can we use our own SQL for creating a report?

2 Answers   Bhawan Cybertek, ICICI,






What is the difference between running total and sub-total?

5 Answers  


How can we performance tune reports?

1 Answers  


How can we know the time taken for particular report execution?

2 Answers   eDynamic LLC,


How can we create diff. types of templates?

1 Answers   eDynamic LLC,


11.How do we format field? 12.How do we connect to the database?

1 Answers   Bhawan Cybertek,


How can we convert crystal dictionary dc5 file to another datasource format like mdb or xml schema ?

1 Answers  


Can we stop the database null values?How?

3 Answers   eDynamic LLC,


Categories