hide big field if empty (not possible to create formula on big field)

[hsandwick]

I have a large text field that is imported user content from an .asp file. I want to show it as a separate attachment page in crystal if text has been entered, and I want to hide the page if it is empty. How do I do this, as it is not possible to create an if isnull formula on a large text field.

Thanks.

 

[idle]

You can put this field in its own section, and format the section to suppress if blank.

 

[hsandwick]

Thanks, I'd tried that and it's fine except I also need it to appear on a new, separate page. When I format the section above to new page after, or the attachment page to new page before, or a similar scenario, it seems to affect the suppress if blank. Help!

 

[Ngolem]

put into the "new page before" and "new page after" a conditional of

not isnull{{large field});

this way the page before and after will only happen for situations where the large field is not null

Jim

 

[hsandwick]

Unfortunately, the "large field" ("Attachment&quot does not show in the formula editor. This is my problem, otherwise this wouldn't be an issue. It's because it doesn't show that I can't build a formula. Any workarounds? The field shows only in the db drop down list. I cannot manipulate it anywhere else in the report, in formulae, parameters, or otherwise.

Thanks

 

[idle]

It doesn't show up in the formula editor.
Put the field itself directly in the section.
However, you can test for null for the "large field" in the formula editor. You just have to type the name of the field in the formula editor, using the standard syntax
Not IsNull({table.fieldname})

 

[hsandwick]

I tried both scenarios, and several options of all/either/or, but I'm afraid it still doesn't work. Thanks for your suggestions. I'm really not sure why the blank pages still exist. This is a tough one!

 

[idle]

What happens when you try the following?
1) create a section, put the {LargeField} in it by itself, select Can Grow as a field format option.
Test this - you should get see the formula, but not have the page breaks where you want, and the section will print even if nothing is in it.
2) Format the section to suppress if blank
Test this - this will get rid of the blank sections, but the page breaks are not where you want them yet.
3) For the section New Page Before and New Page After formulas, use the following formula
Not IsNull({LargeField})
Test this - This should give the page breaks you want.

If you have page breaks triggering on other sections, you may get extra blank pages.