Cross-Tab format field problem.

[timhatz]

I have a cross-tab report built. But now I want to suppress rows....

So I right click on the cell I want to edit, choose format field, and then click on the x+1 button on the suppress field, and then tell it...

if (@level) = "PTO" then true else false

but it does not work... the suppress will not work... So after a little digging, I added the @level to the detail section and told it to show... The first record in the detail showed up as... Vacation...

So for giggles and grins I changed
if (@level) = "PTO" then true else false
to
if (@level) = "Vacation" then true else false

and you know what, it suppressed all the cells, that had that formula, it didn't care what value was in @level..

So my question is this... It looks like cross-tabs don't handle formating formulas at when it draws the cross-tab...

So what should I do, if I want to format cells withen a crosstab depending on the data?

Thanks, tim

 

[kenhamady]

If your formula refers to a field in the report, it will use the current value based on where the cross-tab is in the report.

If you want to format based on the current cell you should use the "CurrentFieldValue" or "Row and Column Name" at the top of the function list.

I am not sure you can suppress a row or column this way, but you can eliminate the records from the report. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/