Formula to show blank lines/fields 1

[cm1234]

Hello

Im a newbi to CR and im using CR 8,5.
My questing is that i need to show som blank lines
in a report made from a paradox db.
but i can only get the report to supress/hide blank lines
from a given db. field where there is blank, and it is the
blank lines that are of importens for our company,
does any body have a solution to this

regards cm1234

 

[synapsevampire]

Please define what you consider to be a blank line.

If a row is returned which has a blank field, and you want to demonstrate that this field is blank, perhaps a formula would suit your purpose, as in:

If isnull({Table.SomeField}) or {Table.SomeField} = "" then
&quot;<blank>&quot;
else
{Table.SomeField}

And if you want to limit the rows in the report to those that are empty in a given field, then use Report->Edit Selection Formula->Record and place something like the following in there:

isnull({Table.SomeField}) or {Table.SomeField} = &quot;&quot;

If you're checking a numeric data type, then adjust accordingly.

If this doesn't help, you'll be better served here by posting example data and intended results.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[cm1234]

Hello
and thank you synapsevampire
the line
isnull({Table.SomeField}) or {Table.SomeField} = &quot;&quot;
just solved my problem and it works smoth.

best regards
cm1234