I am new to Corvid but I managed to do couple of things with the help of people like you all. Now that I have a repeater and that is connected to a dataset and I can see the data in my collection when I Preview the site. However, the problem is that some items in my database are repeated and repeater shows them one by one. I do not want same items repeated in the Repeater.
Say I have stock of motor (of various types) and the price of each motor are different. I do not want repeater to show Motor $10, Motor $15. Instead, I want to repeater to show Motor $35.
Please note that here the item 'motor' repeats in my database, only the item description (like, motor 10 kw or 15 kw) and price are different. Likewise there are many other item, Compressor, Compressor also repeats but it's description and price are different. I want repeater to show Motor (and the total amount of motors) then Compressor (and the total amount of compressors)
I hope my question is clear.
Edit: I have connected each elements in the repeater through a dataset to populate database items, I have not used any code for this purpose.