Buy or Renew
Buy or Renew
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Start a conversation
875
Views
0
Helpful
2
Replies

Not all data is shown in PCCE CUIC v12.0 - Customized Report

YSear
Level 1
Level 1

‎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

Labels:
0 Helpful
2 Replies 2

YSear
Level 1
Level 1

‎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

0 Helpful