If you are using rhe "Keyword Report" vs. the "Button Report":
Add the extra elements )Address, State) to the Group Header. Make them all invisible.
Go to the programming for the Hobbies (JeyWord) element and add additional elements as needed:
vHobby = @AccessStringArray(vKeys, vKeyLoop)
Edited: If vHobby <> "" Then
{
// *** USER DEFINED *** Next line includes fields to be printed on the report.
vVal = vHobby + "|" + First + "|" + Last + "|" + Address + "|" + State
vKeysFinal = @AppendStringArray(vKeysFinal , vVal)
}
vKeyLoop = vKeyLoop + 1
Also go to programming for Out and add additional lines for additional cells. Here is a section as an example adding Address and State to support change made above:
Edited: vOut = "<TABLE>"
vOut = vOut + "<TR>"
vOut = vOut + "<TD>"
vOut = vOut + "<B>Keyword</B>"
vOut = vOut + "</TD>"
vOut = vOut + "<TD>"
vOut = vOut + "<B>Name</B>"
vOut = vOut + "</TD>"
vOut = vOut + "<TD>"
vOut = vOut + "<B>Address</B>"
vOut = vOut + "</TD>"
vOut = vOut + "<TD>"
vOut = vOut + "<B>State</B>"
vOut = vOut + "</TD>"
Out = vOut + "</TR>"
Also add additional lines in the next section of the "Out" program .....
====================
a. Have you tried using the "button" report? Key element only prints one time.
b. Remember to make report changes in DSR but then reconcile them to the DB and run the reports in the DB. Reports are using XL statements and will not work in Preview mode.
Edit: The KeyWord Report has no XL functions, so it can be tested in Preview Mode.