I have run into this before. I need to add a link to an outside website and feed in a parameter. This time it was FedEx, UPS, USPS and DHL.
Instead of hard coding the URL’s into the report, and using a series of “If Thens” or “Case Selects” I decided to create a lookup table with all of the carriers and their URLs. From this table, I associated it with an order id and pulled the shipping type.
The Expression box will be displayed. Make sure the fields are available from your query.
This will build the URL + Tracking Number and when clicked, present the user with a new browser window with the tracking information.
Here are the carriers and their URLs: