Sayyidah Asma' bint Yazid (may Allah be pleased with her) said: When Ibrahim (may Allah be pleased with him), the son of the Prophet (peace and blessings be upon him), died, the eyes of the Prophet (peace and blessings be upon him) filled with tears. It was said to him (peace and blessings be upon him): "You are the most deserving of anyone to recognise the right of Allah." He (peace and blessings be upon him) said: "The eye sheds tears and the heart grieves, but we do not say what angers the Lord. Were it not that this is a true promise and a meeting place where all are gathered, and that the one who comes later follows the one who went before, we would have grieved even more than this. And O Ibrahim, we are indeed grieved for you."
Hadith Referenceالمعجم الكبير للطبراني / مسند النساء / 20803