title: SSRS URL Action Lowercases Parts of the URL
body: <p>Overall Goal: Deliver an SSRS report via email (MHTML in the body of the email) that will be viewed on a mobile device. We have to use Good for Enterprise for work so that is only email client in scope here (although I am not sure if the email client is ultimately the issue here). The email will have links embedded inside that should open up the Salesforce1 app (via the URL scheme in iOS) and take the user to a specific record in the app.</p>
  
  <p>I am trying to create an action on a placeholder to go to a URL. The URL in question is</p>
  
  <pre><code>salesforce1://sObject/&lt;id&gt;/view
  </code></pre>
  
  <p>This works fine in regards to generating a valid URL. However the <code>sObject</code> piece gets automatically converted to lowercase <code>sobject</code> in the resulting MHTML/PDF/etc. outputs. </p>
  
  <p>For what I need the <code>sObject</code> section needs to have the capital <code>O</code> as that is what the Salesforce1 iOS app is expecting (no idea why lowercase will not work but it doesn't and that has been confirmed in my testing). </p>
  
  <p>The funny thing is I can capitalize <code>VIEW</code> and that remains capitalized in the output. It is just the <code>sObject</code> part getting converted to lowercase.</p>
  
  <p>It doesn't matter if I LCase and UCase the strings or build the URL directly in the dataset or anything else. SSRS is always lowercasing the <code>sobject</code> part.</p>
  
  <p>Any thoughts? I am out of ideas.</p>
  
  <p>UPDATE:</p>
  
  <p>It appears that SSRS is lowercasing everything to the left of the ID in my example below. That includes the <code>salesrforce1://</code> and anything in <code>sobject</code>. Must be some SSRS "feature". </p>
  
  <p>Screenshots below.</p>
  
  <p>Report Design
  <a href="https://i.stack.imgur.com/tYZYT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tYZYT.png" alt="Report Design"></a></p>
  
  <p>Placeholder Properties
  <a href="https://i.stack.imgur.com/AoPbM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AoPbM.png" alt="enter image description here"></a></p>
  
  <p>Dataset Query (for the field in question)
  <a href="https://i.stack.imgur.com/vZ9nR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vZ9nR.png" alt="enter image description here"></a></p>
  
  <p>Resulting report output when run</p>
  
  <p><a href="https://i.stack.imgur.com/Bk2uv.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Bk2uv.png" alt="enter image description here"></a></p>
  
  <p>The HTML code created when exporte to MHTML (notice part of the ID is capitalized)
  <a href="https://i.stack.imgur.com/683gZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/683gZ.png" alt="enter image description here"></a></p>