Databases
StackOverflow2013
Postsdbo
POViewing report in CRM 2011 hyperlinks don't work
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POViewing report in CRM 2011 hyperlinks don't work
    primarykey
    data
    text
    <p>I have a RDL file containing a fairly simple report, which in turn has to be deployed to CRM 2011.</p> <p>The report itself works perfectly, showing data as expected; it's supposed to work <strong>on-Premise only</strong>, so it leverages direct SQL access to Filtered Views in order to fetch data.</p> <p>When I tried to insert hyperlinks aiming to let users quickly open records, I found out that they apparently work as they are supposed to when I preview the report, but upon deployment on CRM they are being stripped of the "active" part, and all I'm left with is a colored line of text. I receive no errors and the report itself keeps working <em>perfectly</em>.</p> <p>I referenced this link to build the "active" text -> <a href="http://www.powerobjects.com/blog/2011/12/01/microsoft-dynamics-crm-report-drill-thru-action-to-crm-record/" rel="nofollow">CRM report drill-through action</a>, basically leveragin the "Action" property of a textbox, and the <code>CRM_URL</code> parameter, like this:</p> <p><em>This goes inside Text Box properties -> Action -> "Go to URL"</em></p> <pre><code>=Iif(IsNothing(Parameters!CRM_URL.Value), "", Parameters!CRM_URL.Value + "?ID={" + Fields!id.Value.ToString() + "}&amp;LogicalName=myEntitySchemaName") </code></pre> <p>I tried scavenging Google but it feels like either no one did encounter the same problem or the solution is so trivial no one wrote anything about it.</p> <p>Anyone had this problem before and knows how to face it ?</p> <p><strong>UPDATE</strong> <em>After having fiddled more with the code</em></p> <p>The expression I'm trying to use as "go to url" action is actually <strong>evaluated correctly</strong>. If I copy-paste it as content expression for the textbox I can see the full URL (which, in turn, when copy-pasted in a browser <em>opens the record as expected</em>).</p> <p>Another (maybe not) useful information to add is that our environment is running <strong>CRM 2011 UR3</strong></p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAlex
    1. USAlex
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POViewing report in CRM 2011 hyperlinks don't work
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POViewing report in CRM 2011 hyperlinks don't work
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POViewing report in CRM 2011 hyperlinks don't work
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThe last bit of your comment feels like it's very related. What happens if you place just `Fields!id.Value` as the Text of the TextBox? Does it output the ID you expect?
      singulars
      1. POViewing report in CRM 2011 hyperlinks don't work
      1. USJeroen
    2. COYikes, that's one weird problem then. You should consider adding that last comment to the question by editing it, that's quite relevant info. I'm sorry though I don't have an answer for you.
      singulars
      1. POViewing report in CRM 2011 hyperlinks don't work
      1. USJeroen
    3. COI've cleaned up my own comments and updated the question
      singulars
      1. POViewing report in CRM 2011 hyperlinks don't work
      1. USAlex
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload