Form Comes up Blank

[Jlok]

Just upgraded our accounting software and the new version is using crystal 10. Old edition used crystal 8. Anyway if some of the fields are empty the invoice just prints blank. What am I missing? I tried to suppress without it helping. I eliminate those fields that dont show on every invoice and it's fine.... Really appreciate any help-

 

[synapsevampire]

I'd guess that it's related to the accounting software.

Crystal doesn't care if fields are null or blank, however there may be some differences in how a record selection is interpreted and therefore some rows are eliminated.

Try posting an example of a field, and it's REAL contents (null, blank, spaces, or???).

Also check for suppression formulas within the report.

-k

 

[Jlok]

I guess what I am asking is how to write the suppression formula? I have tried everything I could figure out with no luck. I am assuming it's not working because the form comes up blank. If I remove the fields from the form then it prints fine. Maybe I have to suppress while reading records??

 

[dgillz]

If the report comes up blank, it could be because your formula is suppressing everything.

Please post the formula, and share exactly where this formula is being entered.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[Jlok]

I have looked at this more and the fields causing the problem are created on the fly. Not all invoices have these fields only some. SO, how would I tell it to skipover these if they are not present?

This inoice worked fine with crystal 8 so I dont know what has changed?

 

[lbass]

You might want to consider going to file->report options and checking "convert nulls to default values". Otherwise you could replace the offending fields with formulas that check for nulls, e.g.,

if isnull({table.field}) then
"" else {table.field} //or 0 if the field is a number datatype

-LB

 

[Jlok]

Tried all that.... Pulling my hair out on this one. Lets start from the top (If you dont mind )

Btrieve database, Invoice form. Form prints fine when these fields are removed from the form. When fields are present with no value forms comes up blank.

I have tried every suppression formula... What could it be?

 

[Jlok]

It's not that the table is blank. The table does not exist if it is empty. Well it exists, but there is no entry for that order number.

So, how do I write a formula to tell it to skip if it does not exist?

 

[lbass]

If the offending fields are from a separate table, then you need to have a left join FROM your original table to the table with the potentially null fields. Then adding the field to the report will not cause the elimination of fields from the first table.

-LB

 

[Jlok]

LB,

That was it! Man, I can't thank you enough.... I tried everything.... Except the stupid join type!

Thanks Again!!