Can we stop the database null values?How?
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / anamika
Yes, we can by selecting suppress if null option.
Is This Answer Correct ? | 4 Yes | 3 No |
Can we stop the database null values?How?
How can we convert crystal dictionary dc5 file to another datasource format like mdb or xml schema ?
How many different types of reports we can create in Crystal reports?
6 Answers eDynamic LLC, Jump Games,
7.Are there any limitations in crystal reports? 8.Can we use our own SQL for creating a report?
2 Answers Bhawan Cybertek, ICICI,
3.Can we use stored procedure for creating the report? 4.Does Crystal Report support all the functions that we have in Oracle?
6.What are the sections that we have in Crystal reports?
Is it possible to design report layout in crystal reports without Database info?
How many types of subreport are there?
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?
What is OLAP grid? Where it is used?
How can we know the time taken for particular report execution?
How can we change the Hierarchi of group? and for parameter also?
1 Answers eDynamic LLC, ZoneTech,