I am using DataReports to print labels and have set up the data report to print out 21 labels making it 3 columns of 7 labels...

The problem I am having is instead of each label being individual (what I want) each row is the same as the previous row? I have tried making each label individual by add 'distinct' to the sql statement which bring back the data, anyone help me?