Formula problem

[bharathi228]

hello

iam having status,parameter name,hours as fileds in my table

my report is grouping with parameter name

iam displaying parameter name wise status,hours in every group.
iam calculating percentage for hours.

its working fine.

my problem is

in report footer i want to display the percentage of status ('SVC')


in sqlquery

select hours from table where status in ('SVC')

 

[Madawc]

You could do a running total for records with status 'SVC'. Also a count of all records. Then in the report footer, use a formula field to calculate the percentage.

If you're not already familiar with Crystal's automated totals, see FAQ767-6524.


Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10