issues in grouping

[jessy111]

Hi,

I am working on one crystal report in that i am grouping the one date field by monthly and with in that month daily.

I need to print the count of sccessful call for that month and also for particular day in that month

I am keeping the formula fields in the group header itself.

comming to the issue

i need to check for the successful calls in that particular month as wells days in the month

so i am checking the condition like this

if {endreason} like "Call Completed" then

count({endreason},{Startime},"Monthly&quot

here Startime is grouped by month(Group1) and day(Group2)


This is giving me the count of calls with in that particular month(sum of succssfull and abandoned calls for that particular month).but i need the output as count of successful calls for that particular month only.

How can i filter records to get the count of successful calls

Pls reply

Thanks
Jessy

 

[rosemaryl]

Dear Jessy,

Create the formula to test your records in the detail section.

If
{endreason} like "Call Completed" then
1 else 0

Put the above formula in you detail section.

Insert sum of this field for all groups and then you will have sum of calls completed by day and by Month.

Hope it helps,

ro



Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[jessy111]

Thanks Rosemary it works..