cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
835
Views
5
Helpful
1
Replies

CUIC v12.0 - Customized report is not showing all records from database

YSear
Level 1
Level 1

Hi,

I've customized a report for client in CUIC v12.0.

Report details as below:

- Report definition: Query (SQL Query)

- Data source: custom database

 

I have encountered an issue that the records are not all shown in CUIC.

Example: running the same query directly in database, 5 records return. Running in CUIC report, it shows only 2 records. The missing records are random an

 

Done a test by recreating the report definition as Anonymous Block. By this way all the 5 records are shown in CUIC.

However we would like to stick with Query (SQL Query) instead of Anonymous Block.


May I know where can I look into this issue?

1 Reply 1

View query after execution and check the parameters passed e.g. datetime.

 

Make SP of you query, it will always work perfect. Cuic prefers SP as it gives full control over every required output.