Thank you for your clarifications. I misunderstood your first response. I thought you said the report will store the entire connection string regardless of what type of connection you chose during design time.

Understood about the better solution via integration. However, there needs to be some information in the help files, or available as a standard. Perhaps in a separate class. For someone new to DFR, this was hard to find. Thanks to Michael Mullan, I found a solution here in the forums.