Cant seem to get Repeat to work

I am testing out the repeat children with a db query and dataview. But i cant get it to work.

Created a custom query and tested it, i get 2 record.
added server connect and chose it
added dataview and configured that.

I then used dynamic attribute to display a dataview column that works fine too

Problem is i cant get it to repeat. I did change dynamic attribute to use the Repeater data ,and that produces no result.

Bascially repeater data is empty. But Dataview has records.

Ok i got it to work, by selecting a Row and clicking Make Child Repeat in Properties.

So question is why didnt the Element Repeat or Child Repeat work? when to use either of the three methods?