load a repeater data only when requested

Did you take a look at Dynamic jQuery AJAX viewer

No I dont think this is what I need since I already built the data repeater in a way that contains each data type in a nested repeater (each has its own transf.), isnt there another way than changing the repeater structure?

I'm slightly confused. Are you saying your "large" repeater shows all years, but you really only want it to show 1 year (depending on a drop down)?

If so, then i would have the year drop down set a URL parameter (?year=2018) when selected, and leverage that parameter in your repeater's where condition

WHERE: DataYear = {% Convert.ToInt(QueryString.Year, 0) |(identity)GlobalAdministrator%}

Then lastly you can set a macro on the Visible field of the repeater web part (hit the black arrow) and set it to only be visible if a year is present: Convert.ToInt(QueryString.Year, 0) > 0

If that's not the case, can you explain a little more?

No I dont think you got this right, I have two repeaters , one shows a selected year, and the other shows the data of that year, my only problem is that the second repeater (that contains the data), is loading all the data on page load. I want to load the data whenever the corresponding year is selected.

Can you provide us with a screenshot of that page? Don't understand why you have a repeater to just show one year.

I think you can go with the answer Trevor provided.

In the first repeater (years), add a url parameter (like: lade.org/home?year=2017) to the link with the value of the year on each item.

In the second repeater, just filter the data on the given url parameter on the where field like: WHERE: DataYear = {% Convert.ToInt(QueryString.Year, 0) |(identity)GlobalAdministrator%}