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