[b]Find UNSOLD[/b]

[i]#[/i]

[i]# Attempt to get ALL sold & unsold records count[/i]

[i]#[/i]

[i]#[/i]

[i]#[/i]

[b]Set Variable [/b][ $$COUNT_sold; Value:"" ]

[b]Set Variable [/b][ $NAME; Value:Get(ScriptParameter) ]

[i]#[/i]

[b]Go to Record/Request/Page[/b]

[ First ]

[b]Loop If [/b][ $NAME = Products 2::name and not IsEmpty(Products 2::sold) ] 

[b]Set Variable [/b][ $COUNT_sold; Value:Products 2::sold ]

[b]Exit Loop If [/b][ $NAME ≠ Products 2::name ]

[b]If [/b][ $COUNT_sold ≠ Products 2::c_sold ]

[b]Else[/b]

[b]Set Field [/b][ Products 2::c_sold; $COUNT_sold ]

[b]End If [/b]

[b]End If[/b]

[b]Go to Record/Request/Page[/b]

[ Next; Exit after last ]

[b]End Loop [/b]



[b]Show Custom Dialog [/b][ Message: $$COUNT_sold; Buttons: “OK”, “Cancel” ] [i]# # # # #[/i]

Set Variable [ $COUNT_sold; Value:Products 2::sold ]

Exit Loop If [ $NAME ≠ Products 2::name ]

If [ $COUNT_sold ≠ Products 2::c_sold ]

Else

lets say that $COUNT_sold = 8 and Products 2::sold is empty , i put $COUNT_sold value into that field, how do i save that for

iteration later on for example next pass $COUNT_sold = 4 . or do i just use a summary field?

-i

I'd like to help, but your post is hard to read. It barely makes sense.

Maybe you need to just use another variable, or set repetitions of the same variable, and then set your field(s) at the end?