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

what the mean of version error in crystal?

0 Answers   Symphony,


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

2 Answers   Bhawan Cybertek, ICICI,


Can we stop the database null values?How?

3 Answers   eDynamic LLC,


15.What are the advantages or disadvantages of using Crystal Reports in a Windows Forms application as opposed to say rolling our own reports as HTML and displaying them in the Internet Explorer control?

2 Answers   Bhawan Cybertek, CTS,


What all is needed to achieve an crystal report? A crystal report server ,User Id .Is BI/BO needed.Our source is Microsoft SQL Server 2008 Datacenter.Please guide.

0 Answers   Atos Origin,






9.Can we export data of reports into other format like in world doc etc? 10.Can we create report using more than one database?

1 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,


Hi friends please reply what will be the answer to following question in crystal report 1)Difference between the CR8.5 & CR10.5(withing VS2008) in terms of features. 2)Is Hierarchy of grouping features in either CR8.5 or CR10.5. what are its limitation i.e maximum no's can be created. 3)Scenario - If I have a string semicolon separated(1000 in nos) then how to pass it into Record Selection formula or parameter. 4)Scenario - If user want to do dynamic grouping at runtime that to while designing report only 1 group was created and as per user at runtime based on user selection different fields are used to create group. How is it possible. (Is it possible through formula?) 5)what is cascade or dynamic prompting.whether this is a feature of CR8.5 or CR10.5. 6)what to answer for question "How would you start crystal report development" 7)How "set location" is useful & how to implement it. 8)Scenario - At design time report was developed using MS SQL as datasource but at client side they are using Oracle which is having same table name and structure will the report work? If yes what changes are required to do so. 9)when does "Table Not Found" error is generated.

0 Answers  


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

2 Answers   Cognizant, EDS, eDynamic LLC,


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

2 Answers   Bhawan Cybertek,


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

1 Answers  


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

0 Answers  


Categories