Conditionally displaying grouped data 1

[Michael091170]

I have a report where I need to display certain fields depending on criteria applicable to the project.

If the project has benchmarking applied to it I need to display only the benchmarking fields.

If a project has market testing applied to it I need to display only the market testing fields

If a project has market testing & benchmarking I need to display both benchmarking and market testing fields.

I'm a bit stuck I think I can put these fields into groups but need to only display those groups appropriate to the project.

I hope someone can help.

 

[Madawc]

Using summary totals with MIN and MAX, you should be able to determine whether a particular project has market testing, benchmarking or both. I assume there is some field that says.

As a summary total, this would be valid for the whole group. You can then do alternate detail lines and even group header or footer lines, suppressed selectively.

To suppressight-click on the field and choose Format Field. Choose the [Common] tab, and then the formula icon (x+2 and a pencil) for suppression. Enter a formula.

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 Windows XP & Crystal 10

 

[ssakkerm]

Put these criterias to the Report Filter.
In this case Report will show only benchmark or testing data.

S. Akkerman
Programmer, USA

 

[Michael091170]

I know I'm being a bit dim but I am bit of a newbie to crystal.

Could you give me an example of the syntax or the formula you'd use to suppress a field conditionally or suppress a group conditionally.

Thanks

 

[Bloke152]

go to the section expert and click the formula button next to the surpress tick box. The formula window will then appear.
you would want something like

if {tablename.field} = 'What_ever_your_condition_is'

and that should do ya, if the filed meets that condition then the filed or section will be surpressed!

 

[Bloke152]

sorry my mistake, you prob wont not need the 'if' in the formula

 

[Michael091170]

Thanks that worked a treat