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

[YSear]

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?

[ReportingEngineers-CC]

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.