Skip to Content
0
Former Member
Oct 09, 2009 at 01:34 PM

Crystal Reports 2008 Formula in Cross-Tab Error Not Supported

35 Views

I have a crosstab that was created in Crystal XI and when I opened the report in Crystal 2008 I receive an Error "Not Supported" when I removed the fromula that was in the Crosstab the report displayed. The following is the formula that is within the crosstab:

If {VWR_PPS_VISIT_SCHEDULE.COHORT_NAME} = '(No Cohort)' THEN

If DistinctCount({VWR_PPS_VISIT_SCHEDULE.COHORT_NAME},{VWR_PPS_VISIT_SCHEDULE.PROPOSAL_VERSION_ID}) >1 then

{VWR_PPS_VISIT_SCHEDULE.COHORT_NAME}&" "&{VWR_PPS_VISIT_SCHEDULE.VISIT_NAME}

else

""&" "&{VWR_PPS_VISIT_SCHEDULE.VISIT_NAME}

else

{VWR_PPS_VISIT_SCHEDULE.COHORT_NAME}&" "&{VWR_PPS_VISIT_SCHEDULE.VISIT_NAME}

As I mentioned the formula works perfectly in Crystal XI but not Crystal 2008 which no sese at all. We are preparing to migrate from Crystal XI to Crystal 2008 and if this is an issue we may need to but upgrading off.

Any help with this would be gratly appreciated.

Thanks

Edited by: jackie2009 on Oct 9, 2009 3:41 PM