Formula based on Crosstab report row data - possible? 
Author Message
 Formula based on Crosstab report row data - possible?

I have an Access cross-tab report generated as from the data table below:

item_code --- year --- sales
pens                97         45
pens                98         55
pens                99         70
{*filter*}s           97         10
{*filter*}s           98         15
{*filter*}s           99         20
pencils            97         70
pencils            98         60
pencils            99         70

with the cross-tab report appearing like:

item_code --- target_sales --- sales_97 --- sales_98 --- sales_99 ---
total_sales --- comment
pens                100                      45                   55
70                  170                  Hit Target > 150%
{*filter*}s           50                         10                  15
20                   45                    MISSED TARGET
pencils            200                       70                  60
70                  200                  Hit Target

The "Comment" field is a formula that reflects on the values in each
cross-tab row - comparing "total_sales" with "target_sales" and returning an
English response if the target has been hit, missed and it exceptional
thresholds have been passed.

In Access it is easy to add this formula field to the cross tab report - yet
in Crystal (version with VB5) the entire Cross-tab section is greyed-out and
allows no additions.  Is there a way around this please?

Regards,

Drew Thompson



Mon, 04 Mar 2002 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. printing without crystal report or data report for non data base reports

2. report based on a crosstab query

3. report based on a crosstab query

4. Crosstab Reports with multiple row headers

5. Data Report Object - Suppressing repeated rows in a report column

6. Newbie formula / crosstab question

7. Formula not available in format crosstab?

8. Crosstabs and formulas

9. Adding a field to a table based on CrossTab Query

10. Crystal Report : CrossTab Report

11. Sort or limit row displayed in a crosstab query

12. Forcing Rows to show up in Crystal Crosstabs

 

 
Powered by phpBB® Forum Software