conditionally hide crystal reports cross-tab column

[bunnycat]

I have a cross_tab report that has the following:
column1 - Cetiifications

row1 row2 row3
Department Job Title Personnel Name number of certifications _ summary field


I have created a parameter to give the user the option to summarize the report by: Department, Job Title and Personnel Name or summarize the report by: Department and Job Title. I would like to hide row three when summarizing by Department and Job Title. Is there a way to do this?

 

[Madawc]

Do a formula field, something like

If @JobParam = "Y"
then {Job.Title} & "/" & {Personnel.Name}
else  {Job.Title}

If you've one of the more recent versions of Crystal, this should be fine as a crosstab field. Otherwise you'll need to do a 'Mock Crosstab', do a SEARCH here to find out details.

It always 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