SSRS Reports – What is Report ID Used For?

Okay, I got it. Found this link which helped: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/581c7068-0abe-49f9-a1a5-93e94f472641/

I distilled that information to this query:

select
  Catalog.name,
  cat1.Name datasource
from
  Catalog
  join DataSource
    on Catalog.ItemID = DataSource.ItemID
  join Catalog cat1
    on DataSource.Link = cat1.ItemID
where
  Catalog.Type = 2

Hope this helps someone else in the future!

1. Find and Replace one of the desired characters, such as an Underscore, in the dataset query SQL with a non-sense string, such as "3145234jhasdf" ..... (minus the quotes).
2. In Report Builder, create a DataSet with the resulting data.
3. Create a Tablix with that DataSet. The headers in the Tablix will now look odd. As an example the header, "Column_One", will now look something like this: "Column3145234jhasdfOne".
4. Save the file on your desktop or other local directory. It will be an RDL file. Close Report Builder.
5. Open the resulting RDL file you saved in a text editor, such as Notepad++. You will see XML code.
6. Find and Replace your non-sense string: "3145234jhasdf", with the character you want it to display your headers: "_".
7. Save the file. Close the text editor.
8. Open the file in Report Builder. Your headers should look like you want it.

You can replace more than one type of character by choosing a different non-sense string for each. For ease, keep the string alphanumeric with no spaces.