Section Expert and the suppress function

[ldalessio]

In section expert, I am defining the following criteria under the common tab for the supress function...
fld1numeric = 0 and fld2numeric = 0 and fld3alpha = ' ' The report runs without error but.. when trying to export this file to EXCEL, the fld3alpha = ' ' comes back highlighted and will not export. If I take out the fld3alph = ' ', the report will export.
OK, I give up - where did I go wrong?
Thank you for your help.

 

[Madawc]

I've never come across such a problem. But as a wild guess, you might test for nulls before testing anything else. Though I'd still expect a null to just ensure the section was not suppressed.

Another option would be to put your test in a formula field and then reference the formula field for field suppression. Logically the two operations should be the same. But Crystal does a lot of things behind the scenes, and since you seem to have hit a bug, that might be a work-round.

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.


Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP