I assume the way you phrase it that your data is passing through some other format such as CSV or excel before coming into SQL for your report.

If that is the case, have you considered writing a script to strip out those column headers in something like python/perl/vb.net before you import it into sql?