Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
CRM 4.0 SQL server 2008 R2 custom report CRM_URL parameter is not working

Unanswered CRM 4.0 SQL server 2008 R2 custom report CRM_URL parameter is not working

  • Thursday, June 02, 2011 1:06 PM
     
     
    Sign In to Vote
    0

    Hello everyone,

    CRM_URL parameter is not working. Error is like CRM_URL is missing value. Anybody can help me out.

     

    Thanks, Ankit Shah
    Inkey Solutions, India.
    Microsoft Certified Business Management Solutions Professionals
    http://www.inkeysolutions.com/MicrosoftDynamicsCRM.html
     

All Replies

  • Thursday, June 02, 2011 1:40 PM
    Moderator
     
     
    Sign In to Vote
    0

    make sure the parameter is set to hidden instead of internal if using BIDS.

    If report wizard use  internal (read-only)

    Jamie Miley
    http://mileyja.blogspot.com
    Linked-In Profile
    Follow Me on Twitter!
     
  • Thursday, June 02, 2011 1:56 PM
     
     
    Sign In to Vote
    0

    Hi Jamie,

    It is set as hidden, any other clue.

    Thanks, Ankit Shah
    Inkey Solutions, India.
    Microsoft Certified Business Management Solutions Professionals
    http://www.inkeysolutions.com/MicrosoftDynamicsCRM.html
     
  • Thursday, June 02, 2011 2:16 PM
    Moderator
     
     
    Sign In to Vote
    0

    Please review the concepts in this post and see if it helps.

    http://blog.customereffective.com/blog/2008/04/run-microsoft-c.html

    Jamie Miley
    http://mileyja.blogspot.com
    Linked-In Profile
    Follow Me on Twitter!
     
  • Thursday, June 02, 2011 2:18 PM
    Moderator
     
     
    Sign In to Vote
    0

    and this one too.

    http://msdn.microsoft.com/en-us/library/bb955093.aspx

     

    Jamie Miley
    http://mileyja.blogspot.com
    Linked-In Profile
    Follow Me on Twitter!
     
  • Thursday, June 02, 2011 2:21 PM
     
     
    Sign In to Vote
    0

    Hi Jamie,

    Thanks for the URLs. Unfortunately, I have referred the both. I am almost doing the same thing. In my case, I am not getting a hyperlink in a dashboard a left nav link, aspx page in IFrame via sitemap customziation.

     

    Thanks, Ankit Shah
    Inkey Solutions, India.
    Microsoft Certified Business Management Solutions Professionals
    http://www.inkeysolutions.com/MicrosoftDynamicsCRM.html
     
  • Thursday, June 02, 2011 2:33 PM
     
     
    Sign In to Vote
    0

    Hi Ankit,
    this is a common problem. Review these links:

    http://dmcrm.blogspot.com/2009/05/crmcalendartype-parameter-is-missing.html

    http://rc.crm.dynamics.com/rc/regcont/en_us/op/articles/reportingissues.aspx#o38860

    Julio
     
  • Thursday, June 02, 2011 2:59 PM
     
     
    Sign In to Vote
    0

    Hi Julio,

    Thanks for the links. Honestly I did not understand how it is related with my problem. I have checked the domain user name and CRM profile user name both are same. Plus the priveleges on busienss managment is at org level as the user is system admin. As you said it is very common problem, could you please tell me what steps I need to perform to have hyperlink on quote with CRM_URL. I could run report successfully but did not get the hyperlink.

    The below has been set as go to URL

    = IIF(IsNothing(Parameters!CRM_URL.Value),Nothing,Parameters!CRM_URL.Value &"?ID={" & Fields!CRMAF_QuoteID.Value.ToString() &"}&OTC=1084")

    Thanks, Ankit Shah
    Inkey Solutions, India.
    Microsoft Certified Business Management Solutions Professionals
    http://www.inkeysolutions.com/MicrosoftDynamicsCRM.html
     
  • Thursday, June 02, 2011 4:22 PM
     
     
    Sign In to Vote
    0

    The Easiest way is to just create the URL in your data using the GUID and a string for the remainder of the URL:

    Select 'http://server/Org/sfa/opps/edit.aspx?id=' + CONVERT(varchar(40), Opportunity.OpportunityId) AS OPP_URL, From ...... ---This is for Opportunity

    I'm assuming you want to do this to create links to records, right?

    Or Combine the GUID with the String in the Action settings of the TextBox using a formula like so:

    ="http://server/ORG/userdefined/edit.aspx?id={"+ First(Fields!GUID.Value, "FVLookup") +"}&etc=10047#" --THIS is a CUSTOM Entity

    David Withers
     
  • Friday, June 03, 2011 5:39 AM
     
     
    Sign In to Vote
    0

    Hi David,

    Yes, you are right I want to create a link for a record in SSRS report. Howevere the way you have suggested will not work in my case as I don't want to hard code the server URL and org name in RDL because whenever I would like to move a report to another ORG or environment I need have to change it in all cases. I don't want to do that. Any other clue.

     

    Thanks, Ankit Shah
    Inkey Solutions, India.
    Microsoft Certified Business Management Solutions Professionals
    http://www.inkeysolutions.com/MicrosoftDynamicsCRM.html
     
  • Friday, June 03, 2011 7:28 AM
     
     
    Sign In to Vote
    0

     

    Anybody can help me out with above issue?

    Thanks, Ankit Shah
    Inkey Solutions, India.
    Microsoft Certified Business Management Solutions Professionals
    http://www.inkeysolutions.com/MicrosoftDynamicsCRM.html
     
  • Friday, June 03, 2011 1:38 PM
     
     
    Sign In to Vote
    0

    I am trying to run a report using below URL having dahsboard on aspx page iframe in left nav via sitemap . Everthing works fine and loads a report without error. But for drilldown report it is not working. On click of quote name it is not openig the quote record in pop up window.

    http://localhost/ReportServer_CRM/Pages/ReportViewer.aspx?/ORGNAME_MSCRM/Dashboard&rs:Command=Render

    The same drilldown report is working fine when I run a report from reports area. meant in CRM report viewer. So below is the URL for CRM Report viewer.

    http://Servername:portnumber/orgname/crmreports/viewer/viewer.aspx?id={9a04384d-df8d-e011-9bed-080027d05ed5}&helpID=Dashboard.rdl&action=run

    What should i need to use to set Iframe source without hardcoding ID as well as orgname. And the drill down should work as expected. Any clue from anybody.

    Thanks, Ankit Shah
    Inkey Solutions, India.
    Microsoft Certified Business Management Solutions Professionals
    http://www.inkeysolutions.com/MicrosoftDynamicsCRM.html
     
  • Friday, June 08, 2012 2:53 PM
    Moderator
     
     
    Sign In to Vote
    0
    Did you ever get this figured out?

    Jamie Miley
    Check out my about.me profile!
    http://mileyja.blogspot.com
    Linked-In Profile
    Follow Me on Twitter!

     
  • Saturday, June 09, 2012 5:05 AM
     
     
    Sign In to Vote
    0
    NO. Never.

    Thanks, Ankit Shah

    Inkey Solutions, India.
    Microsoft Certified Business Management Solutions Professionals
    http://www.inkeysolutions.com/MicrosoftDynamicsCRM.html

     
  • Wednesday, April 24, 2013 1:17 PM
    Moderator
     
     
    Sign In to Vote
    0
    I will re-ping this one to see if anyone else has seen this or has ideas.

    Jamie Miley

    Check out RBA Today!

    Check out my about.me profile!
    http://mileyja.blogspot.com
    Linked-In Profile
    Follow Me on Twitter!

     
  • Tuesday, April 30, 2013 2:11 AM
     
     
    Sign In to Vote
    0

    Hi Ankit

    Did you ever fix this issue ?

    cheers

    Van Tay Le