A report on the state of Calgary's water infrastructure says the city has known about the problems for at least two decades.