Drill-down then Link to URL
I have an almost perfect drill-down report. The final thing I want the user to be able to do is go directly to the customer's home page from the report. This is how it works:
1. I created a field in my SQL view :
'All Customers' [All Customers],
customer.id [Customer Id]
Then I set the hierarchy as [All Customers] > [Customer Id]
Now, when I create a drill-down report I can start with one line and I can go from there. The dilemma happens when I expand [All Customers] and get a list of customer Id's. I want to use the customer Id in a URL using https://customer.example.com/customer_id=## but at this point I cannot. In the draft report if I change format to Link to URL it breaks the drill down as the link overrides the drill down function and is replaced with https://customer.example.com/customer_id=All+Customers which is obviously wrong. I've tried to create the URL in SQL but that displays the HTML instead and doesn't work due to the report not wanting HTML injection. Any suggestions?