don't want to hard-code the base URL in the RDL

We need to have links in a report that point to a web application that is located on the same box as the SSRS web service. We don't want to hard-code the base URL in the RDL because this will change from development to staging to production. Where can we store this base URL? Can an RDL access a config file?

Hi !

YOu could use a custom component for this, but this is for me a classical thing of storing the information in a database and pulling it out to a textbox which displays the data.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de