percentage formula in crystal report 8.5
- by sathik
am doing one project using vb6.0+access+crystal report8.5
some error occur during the crystal report.
Query Name
seqquery:
SELECT segment_trans.division_name, sum(segment_trans.Total_value) AS total, division_master.Target
FROM segment_trans, division_master
GROUP BY segment_trans.division_name, division_master.Target;
crystal report percentage formula:
{(seqquery.total * 100) / seqquery.Target }
Error: This field name is not known.
note: Total_value and Target field's datatype "Text"
how to solve this ?
please help me.
Thanks
Sathik
