Is the second object (with the blue header) in your printscreen the table box you're refering to? Is it a chart or a table box. Can't see it, but if it is a chart, then you'll need probally an expression.
Can you upload a sample .qvw if possible? that gives more information.
A table box will never show duplicate records. If you want to show duplicate records as well then when you load the data you will have to create a field that has a unique value for each record. The RowNo() function can be used for this:
...lots of fields... ,
RowNo() as RecordID
When you've created that RecordID field and reloaded the data you can add the new field to the table box so that all records will show even if they are duplicates