Changing fields on Datareport

[nico_van_wijk]

I have designed a datareport with VB6. With a query I deside which info I will display on the report.
There is a field named Primary_address, this field is an integer field.
His value can be 0,1,2,3.... etc. When the value is 0, I will display
a text in the report. How can I do that? I used the code below.

Dim rsDutten As ADODB.Recordset
 
    Set rsDutten = New ADODB.Recordset
    rsDutten.CursorType = adOpenKeyset      
    rsDutten.LockType = adLockOptimistic    
    rsDutten.ActiveConnection = cnParm
 
    rsDutten.Source = "SELECT Type, Benaming, Fabrikant, Datum,
 Revisie_proc, Aktief, Driver, Primary_address, Secondary_address FROM
 dutten WHERE Station = '" & Station & "' ORDER BY Type;"
    rsDutten.Open
 
    Set DataReport2.DataSource = rsDutten
    DataReport2.Orientation = rptOrientLandscape
    DataReport2.Show

[binilmb]

place a label control in the data report. in my code it is label 3 and the section in section5
if rsDutten("Primary_address").value="0" then
DataReport2.Sections("Section5").Controls("Label3").Caption = "test"
end if


This will work only for displaying a single record. If ur displaying multiple record the value will be the same. i have tried this a lot.
I think u need to try it in sql to do so.
if u got the solution pls let me know

[Hack]

Moved to reporting section

[nico_van_wijk]

I will display multiple records in a section. I don't know how I handle my wish in a query. Does somebody know how?