Suppress Rows in a Cross tab

[wanzek1]

I am using a cross tab and this is my result

Hour Total
John 85
Mary 65
Tim 55
Jim 75
Luke 10

I would like to be able to surpress all rows that have an hour total less than 60. Is this possble? If so how do I do it?

Thanks

 

[Madawc]

I'm pretty certain you can't do it in a crosstab.

What you could do is group by name, suppress detai lines and group header, show the name and total in the group footer. Then selectively suppress group footers with a total less than 60.

If your report has to show other details, you could move the function down into a subreport.

PS. It helps to give your Crystal version - 8, 8.5, 9, 10, 11, 2008 or whatever. Methods sometimes change between versions, and higher versions have extra options. In this case, it probably makes no difference.

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

 

[lbass]

If you have a group on {table.name} in the main report, you can create a formula like this:

if sum({table.hours},{table.name}) >= 60 then
{table.hours}

Add this formula as your summary field instead of your current one.

Then go into report->selection formula->GROUP and enter:

sum({table.hours},{table.name}) >= 60

-LB