This Halacha will depend on whether we are discussing the Friday night Kiddush or the one on Shabbos morning.
Friday night, the only acceptable alternative to wine or grape juice is to make Kiddush on the Challos themselves. Even this is only permitted according to the Rema if there is no wine available in the entire city, an unlikely prospect.
On Shabbos morning, it is better to use beer or whiskey than it is to use Challa; however, if neither those nor wine or grape juice are available, Kiddush may be recited on Challa. Soda and juice primarily from concentrate are not acceptable alternatives.
The implication of your question was that you are not referring to a family who has no alternative for Kiddush, rather the situation was a social Kiddush in Shul in the morning. Presuming there is no great need to make a Kiddush in Shul after Davening, if wine, grape juice or other similar liquids are unavailable, it would be better to forgo the Kiddush altogether than to rely on less than ideal arrangements.