02-18-2020 06:47 PM
Hi All,
Have customized a report for client but found an issue which CUIC does not show all the data returned from database server.
Details are as below:
Database: UCCE Historical
Filtered By: DateTime, Precision Queue
The query is running fine in database server and able to return all records but when it is in CUIC, some of the Precision Queues and their data are not shown.
Any help is much appreciated.
Thank You,
Ying
02-18-2020 09:13 PM - edited 02-18-2020 09:14 PM
Tried few methods and one of it resolved the issue. Sharing it here in case someone's having the same issue too.
Have changed the Report Definition from SQL Query to Anonymous Block and it solves the issue. Did not make changes on the sql query. Anyway, changing the query type in Report Definition solves this issue.
Now all data is shown in CUIC. Yayy
02-19-2020 06:30 AM
I just looked at the CUIC report templates for v12 and it looks like some were updated since they were first released, did you see if perhaps this issue is listed in with the updated version updates?
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide