reporting on service call history

[Laura_Nest]

I would like to create a report of service call history as can be seen on the service call tab. I know the ASCL table  is the change log for service calls: is this my only option for getting a report? Is there a view for the Service call history?

My goal is to track the time it takes between changes in Call Status for some performance reporting. Any suggestions would be much appreciated.

Laura

[kothandaraman_nagarajan]

Hi,

Did you check service call--->History tab?

Thanks & Regards,

Nagarajan

[Laura_Nest]

i know the info shows on the Service history tab but i need to write a Crystal report using this info on the History tab and am asking which table the data is stored in. do you know which table populates the service history tab

[kothandaraman_nagarajan]

Hi,

Check with table ASCL.

Thanks & Regards,

Nagarajan

[Former Member]

If it is history tab, it links to ASCL.

[Former Member]

Hi Laura,

If you need a report for service call history that can be seen on the service call tab, you may not need ASCL. ASCL only saves the header changes. Those data under each tab are saved in the SCLx sub tables.

Thanks,

Gordon

[Laura_Nest]

i have looked at scl# tables but didnt think i saw the data i am looking for. Do you know the service history tab source table? thanks