SSRS Report in ASPX page

All replies

• 

  

  0

  Sign in to vote

  Hi, 

  I don't think I follow your question - could you be a bit more specific as to what you are having problems implementing?

  Scott

  Thursday, November 11, 2010 9:50 AM

  Answerer
• 

  

  1

  Sign in to vote

  You can call the CRM(SSRS report) by linking its URL to your web page link similar to the method you are opening ms crm record.

  Call report in CRM report viewer:

  https://crmserver/crmreports/viewer/viewer.aspx?action=run&id=%7b315C371A-4693-DF11-A498-000C29F9FFEC%7d&context=records&recordstype=10007&records=%7bDE38FBCE-79D0-DE11-A9E1-000C29F9FFEC%7d&helpID=CPUH.rdl

  Call report from SQL Report Server:

  http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fOrganization_MSCRM%2f4.0%2f%7ba048d34c-b740-df11-80da-0003ff2b5a47%7d&rs:Command=Render

  You can obtain this URL by simply nagigating to report server (http://<server>/ReportServer) and select the report.

  • Proposed as answer by Amarsen Vangoor Thursday, November 11, 2010 1:59 PM
  • Marked as answer by Jim Glass Jr Thursday, November 11, 2010 8:25 PM

  Thursday, November 11, 2010 11:36 AM
• 

  

  0

  Sign in to vote

  Hi Vinoth,

  I am trying to run a report in 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 record in quote 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. mant in CRM reprot 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 your side.

  ---

  Thanks, Ankit Shah

  ---

  Inkey Solutions, India.

  ---

  Microsoft Certified Business Management Solutions Professionals

  ---

  http://www.inkeysolutions.com/MicrosoftDynamicsCRM.html

  Friday, June 3, 2011 1:35 PM
• 

  

  0

  Sign in to vote

  Hi Ankit,

  two years later, did you ever find a solution to this ?

  cheers

  ---

  Van Tay Le

  Monday, April 29, 2013 1:50 PM
• 

  

  0

  Sign in to vote

  No, I did not find a way to resolve it.

  ---

  Thanks, Ankit Shah

  ---

  Inkey Solutions, India.

  ---

  Microsoft Certified Business Management Solutions Professionals

  ---

  http://www.inkeysolutions.com/MicrosoftDynamicsCRM.html

  Wednesday, May 1, 2013 7:49 AM