null fields in crystal reports

Does anybody know of an "isnull" type function in Crystal Reports...

Does anybody know of an "isnull" type function in Crystal Reports!? . but this doesnt work because it pulls all null fields rows form my report.

⬇ Download Full Version

Null fields will be blank in a Crystal Report but we can use formulas to di...

Null fields will be blank in a Crystal Report but we can use formulas to display 0 for the The following example displays a '0' value for null attendance records.

⬇ Download Full Version

FIELD} = "" then // do something FIELD1}) then "NULL" +...

FIELD} = "" then // do something FIELD1}) then "NULL" +',' + {TABLE. Here I put NULL as string to display the string value NULL in place of.

⬇ Download Full Version

If you don't use field from a table then Crystal Reports ignores the t...

If you don't use field from a table then Crystal Reports ignores the table and doesn't use it in the underlying SQL query. So, in that case this.

⬇ Download Full Version

Look for the " Convert NULL field value to default " checkbox. Fo...

Look for the " Convert NULL field value to default " checkbox. Folks who are using newer versions of Crystal Reports will notice an additional.

⬇ Download Full Version

Hello everyone, I'm trying to write a report in Crystal Reports 13 in ...

Hello everyone, I'm trying to write a report in Crystal Reports 13 in Visual Studios What this report entails is basically showing a.

⬇ Download Full Version

Also, when you use “outer” joins to join the tables in your report, there w...

Also, when you use “outer” joins to join the tables in your report, there will be Nulls when the data in one table doesn't have a match in the other table. Crystal.

⬇ Download Full Version

Hi All, I am Using Crystal Report XI I need to concatenate multiple address...

Hi All, I am Using Crystal Report XI I need to concatenate multiple address fields but quite often, not all the fields are populated, and.

⬇ Download Full Version

Hello All, I have been trying to get my reports going for the last couple I...

Hello All, I have been trying to get my reports going for the last couple I have tried all combinations of 'Convert Database NULL Values to.

⬇ Download Full Version

i m using crystal report 9. passing some null values to crystal report. i w...

i m using crystal report 9. passing some null values to crystal report. i want to suppress those fields in dwn.220.v.ua me know the answer.. thanks in.

⬇ Download Full Version

Hello - I am very new to crystal reports and I am having problems figuring ...

Hello - I am very new to crystal reports and I am having problems figuring out why my entire report appears blank (except for field hea.

⬇ Download Full Version

I am using embedded Crystal Report in VS e.g. I have a field called TIMEIN ...

I am using embedded Crystal Report in VS e.g. I have a field called TIMEIN Type (Char) with (allow nulls) value checked in sql table.

⬇ Download Full Version

I'm using crystal report with dwn.220.v.ua .Net framework ). In a repo...

I'm using crystal report with dwn.220.v.ua .Net framework ). In a report I'm retrieving the values from a database table and showing it. But the.

⬇ Download Full Version

I have a formula that includes two fields and both can contain NULL values....

I have a formula that includes two fields and both can contain NULL values. I need the formula to return 'Y' if '1' is in either of the two fields.

⬇ Download Full Version

I am working on a Crystal report querying an Oracle database. There is a nu...

I am working on a Crystal report querying an Oracle database. There is a number field in the Oracle database that can contain null values.

⬇ Download Full Version