The census of cataclysmic variables in the ROSAT Bright Survey