Crystal Report 9 and heat database
Scenario is here;
I am capturing all the calls open by Service Desk and group it by item (in group footer). Same time i am capturing all the call closed by Service Desk. Call opened by service desk is coming from Calllog table but to know who closed the call i had to link calllog table to tracker table. Most of the call opened and closed by different agent.
The problem is i am unable to combine closed by and opened by data by item. I am able to create two seperate report and i tried to create sub report for call closed by but unable to properly link it to main report. Can someone tells me the right approach to combine the data in one report.
Scenario is here;
I am capturing all the calls open by Service Desk and group it by item (in group footer). Same time i am capturing all the call closed by Service Desk. Call opened by service desk is coming from Calllog table but to know who closed the call i had to link calllog table to tracker table. Most of the call opened and closed by different agent.
The problem is i am unable to combine closed by and opened by data by item. I am able to create two seperate report and i tried to create sub report for call closed by but unable to properly link it to main report. Can someone tells me the right approach to combine the data in one report.