Should I be the one to tell my daughter she can never have kids?

This needs a lot of courage. I don't know what to say but yes its better you break this news in the best possible manner to her. You have to console your daughter also.