Hi guys, I passing the variable 3 value to CUIC reporting. But actually in the CUIC reports it’s hitting multiple times for each call ,it should be each call single hitting only if am wrong please.
Now my reports are coming multiple time .
i merged RCD table to existing reports for make one column to visible as variable 3 value .
i think your question is not clear enough. Could you please describe a little bit more, like, is it a custom CUIC report, how are you passing variable 3 (is it PV 3), what rows are merged in RCD to get one line.
If possible, provide some screenshots as well.
Thanks Roy. can you please provide more details on "i want to add the Variable 3 in custom report with one column ." What is this custom report, do you have a SQL query which is not providing correct details or are your trying to modify existing report definition to derive some results. What are the results that you want to capture in report.
Call Type ID is the common field between 4 tables you mentioned, that is correct. After reading your description, can you please confirm if your script logic is: variable 3 is used multiple times in your script and each time goes to same call type ? and you want to know for a specific value in variable 3, how many calls came against that call type ?