Tracing the sound horizon scale with photometric redshift surveys