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

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

2 Answers   eDynamic LLC,


What is OLAP grid? Where it is used?

1 Answers   eDynamic LLC,


How many different types of reports we can create in Crystal reports?

6 Answers   eDynamic LLC, Jump Games,


3.Can we use stored procedure for creating the report? 4.Does Crystal Report support all the functions that we have in Oracle?

1 Answers   Bhawan Cybertek,


How to set up valid email address and printer in Cognos, so can delivery the report by email or print it out?

0 Answers  






How can we create diff. types of templates?

1 Answers   eDynamic LLC,


How many types of subreport are there?

3 Answers   eDynamic LLC,


In one subreport how many subreport we can insert?

3 Answers   eDynamic LLC,


what the mean of version error in crystal?

0 Answers   Symphony,


5.Can we add any database field once we have chosen ?Close? button?

1 Answers  


What is subreport? In one report maximum how many subreport we can insert?

2 Answers   EDS, Cognizant, eDynamic LLC,


14.How to "Print" in Crystal Reports while using ASP DOT NET Platform?

2 Answers   Bhawan Cybertek,






Categories