Reports !!!!!!

  • Thread starter Thread starter Viswanathan S
  • Start date Start date
V

Viswanathan S

Hi all!
I am a Customer Service Rep and trying to design a report
for the Customer Satisfaction reports.

There are 2 fields
1> CSAT with values 1-5
2> TPR with values 1-5

If CSAT is 4 or 5, the CSAT is 100% else 0%
If TPR is 1 then the TPR is 100% else 0%

For this I added fields in the table Block1 and Block2
Block1 (values 0 or 1) for CSAT. If CSAT is 4 or 5 Block1
is 1 else 0 and similarly for Block2.

Now for the Report.
I am trying to group the report week wise with summary of
CSAT % =(Number of CSAT with values 4 or 5 (Block1 = 1))/
(Total Number of CSAT entries)
and similar for TPR also.

I do not want the Block1 or Block2 to be displayed very
blatantly on report.
Can yoy please help me....
Thank you.
Viswanathan S
 
I do not see a real need for adding fields to the table
(like block1 and block2)
This can easily be done in the report (query).
Base the report on a query which includes the fileds CSAT
and TPR. Add a field in the query I'll name CSAT-Score:IIF
(CSAT> 3,1,0), add asecond field TPR-Score:IIF(TPR=1,1,0).
Now in the report design view add a text field for the
CSAT summary in the report footer which is which equals
Count()/Sum(CSAT-Score and set the format to percent and
also for the TPR summary Count()/Sum(TPR-Score) with a
same format.
Hope this helps.
Happy New Year
Fons
 
Back
Top