formula not available in crosstab

[espltd]

Hi I have a couple of formulas and would like to place thier results in a crosstab but they do not appear to be available from the crosstab expert, using crystal 10.
Thanks.

 

[lbass]

You would have to show us the content of the formulas.

-LB

 

[espltd]

Thanks for the response, below is the formula, I have a another one to count Slow categories as well. I currently have everything working except I am not able to use a crosstab. It would be nice if I could include these formulas in the crosstab but not mandatory. Also this formula only works correctly if data is sorted by start time, end time, category.

//count Fast categories.
whileprintingrecords;
IF onfirstrecord and {Table.Action_Type_CH}="FAST" or previous({Table.Start_Time})<>{Table.Start_Time}
and {Table.Action_Type_CH}="FAST" or previous({Table.End_Time})<>{Table.End_Time}
and {Table.Action_Type_CH}="FAST"

or previous ({Table.Action_Type_CH})="SLOW" AND {Table.Action_Type_CH}="FAST"
AND previous({Table.Start_Time})={Table.Start_Time} AND previous({Table.End_Time})={Table.End_Time}

then Numbervar X :=X+1
else 0

 

[espltd]

Another interesting thing on this same report is that when I try to add second pie chart and select data from the chart expert it does not show any available fields, and only shows a single entry available for the on change of field as well as a single entry available on the Show box. Could this be because of where the chart is placed?
Thanks.

 

[lbass]

As far as I know, you cannot use formulas that use "whileprintingrecords" or previous/next in crosstabs. For charts, there is a complicated way of using print-time formulas involving shared variables in subreports.

This looks like it references your previous thread about a crosstab. You should be able to simply add {Table.Action_Type_CH} as your column field as I suggested in that thread.

-LB

 

[espltd]

ok thanks for the additional information.