Crosstab/Formula Data Overlap

[darkryft]

I am using Crystal Reports 2008 and trying to build a crosstab report using a formula field I have constructed to classify the records I've pulled back. I hit upon an issue and mostly I'm trying to see if this is a limitation of Crystal Reports:

The formula checks a numeric field's value and then categorizes based ranges that are specified. However, some of the categories have overlapping ranges, and I'm trying to get the same record to drop into both categories.

So, the formula is like this:

IF {Numeric.Value} = 26 to 30 THEN "A"
ELSE IF {Numeric.Value} = 28 to 34 THEN "B"

I was hoping to do this in a crosstab report because it would be considerably faster than building a "manual crosstab", but I thought I would check here before I went to all that trouble.

I'd appreciate any information the community could offer.

 

[hilfy]

You're not going to be able to do it this way - no matter how the If is evaluated, you're only going to be able to return one record. In order for the data to appear in both categories, you need to have two records - one for each category.

How proficient are you at writing SQL? The only way I can see to do this is to write a command.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[darkryft]

Understand. Again, I just needed to be sure. I'd like to be able to play around with the query and do that, but the powers-that-be have decided I'm not that cool. I'll have to do it the hard way.