Report with Live Connection does not populate details correctly

Hello, 

I have created a report using a direct query (live connection) to the Netezza database. The report has a summary table and multiple tables for showing the details. 

When I click on a record from the summary table, the data in other tables (details table) gets updated only for certain records. For example if the summary table has 10 records, the details for only 4 correpoding records get updated in detail tables. For other 6 records when I click on them (Individually) in the summary table, blanks appear in all of the detail tables. 

The report pulls the data only from one table in Netezza and when checked, the details exist for those 6 records in the Netezza table. I need to populate the details for those 6 records too. 

Any advice, suggestions? 

Thanks, 
Jash