Cross-Tab with Formula Field 1

[TomJinCA]

Hi All,

I set up a cross-tab report with a date field as the row and 5 formula fields as columns. Unfortunately, I get this bizarre combination of "True" and "False" columns that is very hard to read. All I want is a summary for records matching the formula I gave for the column.

Any help or suggestions much appreciated!

Tom J

 

[kenhamady]

A column field isn't a single column, but a layer. You don't want five layers of columns. You could create one formula that categorizes each record into one of 5 groups, but if a record can be in more than one column, than you can't use a cross-tab.

Instead, drop the cross-tab.
Add a group by the date field and modify your five formulas to be like this:

If {condition}
then 1
else 0

Place these 5 on the detail band as five columns, and then hide the details.

Create subtotals and grand totals of each of these fields (summing the 1s and 0s that appear). It will do what you want, and look like a cross-tab.

Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[TomJinCA]

Ken,

Thank you very much!! I didn't do it exactly this way though. What I eventually wound up doing was a cross-tab, but the column was a calculated field. I had to get creative and actually needed several calculated fields, but it gave me exactly what I needed.

You got me on the right track - thanks again!

Tom Jacobson ...
MS Exchange admin, NT admin, Intranet admin, Virus protection, Frontpage, VB5&6, Access, Crystal Reports