Crystal reports help-newbie

[Pechay09]

Hi,

I am trying to run a report and I am looking for a name in one of the fields. I've been racking my brain trying to figure it out in the formula fields to no avail.


I am trying to formulate a statement where all information 'crystal newbie' has written will be displayed. How do I do that in the crystal in formula fields? I've been trying to think of an 'if then' state

IF 'crystal newbie' has written anything THEN display the text ELSE do not display the text.

If anyone could help that would be great.

[jacksoar]

I used Crystal for a few months and run into the same problems it sounds like you're having. After those months of frustration, I found Windward Reports (http://www.***************.com/?source=jmada&id=P&utm_source={source}&utm_campaign=jmada) and have been in heaven since. They have an explicit IF tag that sounds exactly like what you're looking for. Check them out for a few minutes if you're still having problems with Crystal.

[mr99]

Go to the Report menu then select Section Expert. Select the section you want, I'm assuming it's Details. Once highlighted, take a look at the options of the Section Expert. The second item, Suppress is what you want. However, instead of checking the box click on the x + 2 icon to the very right. This will bring up a formula editor.

The formulas you use for formatting a section are a little different than your standard formula. Think of them as an implied if statement. Enter the following formula:

{table.name} <> 'crystal newbie'

That should suppress anything whose name does note equal crystal newbie.