Printing Labels using DataReports
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?
Re: Printing Labels using DataReports
Hi,
can you post sql statement
Regards,
Champgary
Re: Printing Labels using DataReports
Heres my SQL code:
VB Code:
If ShowAllResults = True Then
query = "select distinct Access_NO,ICCID " & _
"from Test_Dec_Puk_Details tdPD, Test_Dec_GSM_PP_Access_Numbers tdGPAN " & _
"where ICCID_Full = '" & FileIDToPrint & "' " & _
"and tdPD.ICCID = Ltrim(tdGPAN.Assoc_Access_No)"
Else
query = "select distinct Access_NO,ICCID " & _
"from Test_Dec_Puk_Details tdPD, Test_Dec_GSM_PP_Access_Numbers tdGPAN " & _
"where tdPD.ICCID = Ltrim(tdGPAN.Assoc_Access_No) " & _
"and ICCID_Full = '" & FileIDToPrint & "' " & _
"and Access_NO >= '" & PhoneNumberFrom & "' " & _
"and Access_NO <= '" & PhoneNumberTo & "'"
End If
????
Re: Printing Labels using DataReports
Moved to reporting section