{"id":617,"date":"2016-10-14T13:21:25","date_gmt":"2016-10-14T13:21:25","guid":{"rendered":"http:\/\/blog.softreeconsulting.com\/?p=617"},"modified":"2016-10-14T13:21:25","modified_gmt":"2016-10-14T13:21:25","slug":"open-performance-point-report-new-window-javascript-solution","status":"publish","type":"post","link":"https:\/\/softreetechnology.com\/blog\/all\/open-performance-point-report-new-window-javascript-solution\/","title":{"rendered":"Open a Performance Point Report in a New Window – JavaScript Solution"},"content":{"rendered":"

\"open-a-performance-point-report-in-a-new-window3\"<\/a><\/p>\n

Same as the previous blog, we are presenting this blog as a solution to client\u2019s request on \u201cHow to easily open a performance Point Report in a New Window?\u201d The circumstance is actually our client has a performance Point dashboard that includes a multitude of Reporting Services reports and Performance Point Analytic Chart reports. Being just the measures of some kind of chart, the Reporting Services reports can\u2019t be displayed. Our client wanted the solution to click on them and exhibit the underlying data.<\/p>\n

Well\u2026 being that typical bug fixer, one of our Offshore SharePoint developers<\/a> tried to dig out the problem first. The problem was actually the comprehensive data our client wanted to display was actually a bit large than the dash space allotted for actual chart or SSRS gauge. Therefore, all we needed is the tweak to display the detail data to open in a new window.<\/p>\n

Call it an adversity or an unawareness of Microsoft engineers, there is no option in SharePoint settings for \u201cOpen report in new window\u201d (I really hope Microsoft engineer read thisJ). So our developers needed to write a little JavaScript. \"reportingservices\"<\/a><\/p>\n

Walkthrough Postulation:<\/strong><\/p>\n

\u2022 SSRS is in SharePoint integrated mode (this can be done in Native Mode as well).<\/p>\n

\u2022 SSRS must be of 2008 or higher.
\nTutorial:<\/p>\n

The summary of this post is that you mainly require adding the JavaScript displayed below to the \u201cAction\u201d property of underlying data your user is going to hit in the report.<\/p>\n

=”javascript:void(window.open(‘http:\/\/perfobased\/sites\/tannermanual\/_layouts\/ReportServer\/RSViewerPage.aspx?rv:RelativeReportUrl=\/sites\/ tannermanual \/SSRS\/BlogExampleReport.rdl’, ”, ‘width=1000, height=800, top=0, left=0, resizable=yes’))”<\/p>\n

Where \u201chttp:\/\/ perfobased…\u201d is the URL to your report, and \u201cwidth=1000…\u201d is the dimensions of the new window.<\/p>\n

The primary thing we require to be acquainted with is the URL to the report, data that we would like to display in our new window. To get the URL, we\u2019re just going to open the data in SharePoint and then copy it from the address bar of the browser. Nevertheless, you\u2019ve possibly got some stuff at the end that you don\u2019t require. For example, my report is called InstanceReportLeviate, and the URL is:<\/p>\n

http:\/\/perfobased\/sites\/tannermanual\/_layouts\/ReportServer\/RSViewerPage.aspx?rv:RelativeReportUrl=\/sites\/tannermanual\/SSRS\/InstanceReportLeviate.rdl&Source=http%3A%2F%2Fmastvmbase%2Fsites%2FTavisBIDemo%2FSSRS%2FForms%2Fcurrent%2Easpx&DefaultItemOpen=1<\/p>\n

 <\/p>\n

If you want to remove everything after \u201creportname.rdl\u201d it will look like this:<\/p>\n

http:\/\/perfobased\/sites\/tannermanual\/_layouts\/ReportServer\/RSViewerPage.aspx?rv:RelativeReportUrl=\/sites\/ tannermanual \/SSRS\/ InstanceReportLeviate.rdl<\/p>\n

Once you have got the report URL, you can add it to the URL in the featured JavaScript as displayed above. Currently, you have to add JavaScript to the report that the user will click on in the dashboard. In our case this report is a gauge. So we\u2019ll have to:<\/p>\n

 <\/p>\n

\"\"<\/a><\/p>\n

    \n
  1. Right-click on the Gauge<\/strong> in design mode and select Properties<\/strong>.2. Choose Action <\/strong>from the Properties window.3. Choose Go to URL<\/strong> as the action.\n

    4. Hit on the Fx<\/strong> button right next to the Select URL field, and copy in our JavaScript.<\/li>\n<\/ol>\n

    And there you go\u2026Hit on OK on all the opened windows and position the report to test it.<\/p>\n

    NOTE: The report must be deployed in order for the JavaScript to work. It will not work in the preview window of your report designer.<\/p>\n

    N.B. The data must be arranged as this will make JavaScript to work. It won\u2019t work in the preview window of your report designer.<\/p>\n

    Now let\u2019s say we would like to pass a parameter from our original report to the report that opens in the new window. We can also do this through the URL by adjusting our JavaScript like so:<\/p>\n

    =”javascript:void(window.open(‘http:\/\/perfobased\/sites\/tannermanual\/_layouts\/ReportServer\/RSViewerPage.aspx?rv:RelativeReportUrl=\/sites\/tannermanual\/SSRS\/InstanceReportLeviate.rdl&rp:p_ReportParameter1=ParameterValue’, ”, ‘width=1000, height=800, top=0, left=0, resizable=yes’))”<\/p>\n

    In the above illustration, we\u2019re passing a value of \u201cParameterValue\u201d into our parameter named \u201cp_ReportParameter1\u201d.<\/p>\n

    It\u2019s worth noting that you can also control several aspects of your report viewer toolbar by passing parameters in via the URL. There is an excellent post about doing so here<\/a>.<\/p>\n

    No doubt it is messy and tricky to administer through environments, the functionality is possible. If you have several reports that need to be moved between dev\/uat\/prod, I highly suggest leveraging shared data sets to store your base report URL:<\/p>\n

    http:\/\/perfobased\/sites\/tannermanual\/_layouts\/ReportServer\/RSViewerPage.aspx?rv:RelativeReportUrl=\/sites\/ tannermanual \/SSRS\/<\/p>\n

    Arranging so will permit you to modify it in one place, instead of having to do so in each particular report when you deploy to a new environment.<\/p>\n

    This post is brought to you by Softree Consulting <\/strong><\/p>\n

    Softree Consulting <\/em><\/a>employs SharePoint consultants, who are experienced in writing for a multiplicity of SharePoint verticals including technical, promotional, creative, branding content, cataloguing and ethical media comprising journalism.<\/em><\/p>\n

    With more than 10 years of industry experience these professionals have the best resources to deliver optimum results. They have been satisfying customers with some of the best SharePoint Strategies. In case you need experts for <\/em>Offshore development for SharePoint 2016<\/em><\/a>, we have got you covered.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

    Same as the previous blog, we are presenting this blog as a solution to client\u2019s request on \u201cHow to easily open a performance Point Report in a New Window?\u201d The circumstance is actually our client has a performance Point dashboard that includes a multitude of Reporting Services reports and Performance Point Analytic Chart reports. Being just the measures of some […]<\/p>\n","protected":false},"author":1,"featured_media":621,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[129],"tags":[],"class_list":["post-617","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-all"],"yoast_head":"\nOpen a Performance Point Report in a New Window - JavaScript Solution - Softree Technology<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/softreetechnology.com\/blog\/all\/open-performance-point-report-new-window-javascript-solution\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Open a Performance Point Report in a New Window - JavaScript Solution - Softree Technology\" \/>\n<meta property=\"og:description\" content=\"Same as the previous blog, we are presenting this blog as a solution to client\u2019s request on \u201cHow to easily open a performance Point Report in a New Window?\u201d The circumstance is actually our client has a performance Point dashboard that includes a multitude of Reporting Services reports and Performance Point Analytic Chart reports. Being just the measures of some […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/softreetechnology.com\/blog\/all\/open-performance-point-report-new-window-javascript-solution\/\" \/>\n<meta property=\"og:site_name\" content=\"Softree Technology\" \/>\n<meta property=\"article:published_time\" content=\"2016-10-14T13:21:25+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Open a Performance Point Report in a New Window - JavaScript Solution - Softree Technology","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/softreetechnology.com\/blog\/all\/open-performance-point-report-new-window-javascript-solution\/","og_locale":"en_US","og_type":"article","og_title":"Open a Performance Point Report in a New Window - JavaScript Solution - Softree Technology","og_description":"Same as the previous blog, we are presenting this blog as a solution to client\u2019s request on \u201cHow to easily open a performance Point Report in a New Window?\u201d The circumstance is actually our client has a performance Point dashboard that includes a multitude of Reporting Services reports and Performance Point Analytic Chart reports. Being just the measures of some […]","og_url":"https:\/\/softreetechnology.com\/blog\/all\/open-performance-point-report-new-window-javascript-solution\/","og_site_name":"Softree Technology","article_published_time":"2016-10-14T13:21:25+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/softreetechnology.com\/blog\/all\/open-performance-point-report-new-window-javascript-solution\/#article","isPartOf":{"@id":"https:\/\/softreetechnology.com\/blog\/all\/open-performance-point-report-new-window-javascript-solution\/"},"author":{"name":"admin","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/98740297642f06debccdcee2de84086b"},"headline":"Open a Performance Point Report in a New Window – JavaScript Solution","datePublished":"2016-10-14T13:21:25+00:00","mainEntityOfPage":{"@id":"https:\/\/softreetechnology.com\/blog\/all\/open-performance-point-report-new-window-javascript-solution\/"},"wordCount":882,"commentCount":0,"publisher":{"@id":"https:\/\/softreetechnology.com\/blog\/#organization"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/all\/open-performance-point-report-new-window-javascript-solution\/#primaryimage"},"thumbnailUrl":"","articleSection":["All"],"inLanguage":"en","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/softreetechnology.com\/blog\/all\/open-performance-point-report-new-window-javascript-solution\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/softreetechnology.com\/blog\/all\/open-performance-point-report-new-window-javascript-solution\/","url":"https:\/\/softreetechnology.com\/blog\/all\/open-performance-point-report-new-window-javascript-solution\/","name":"Open a Performance Point Report in a New Window - JavaScript Solution - Softree Technology","isPartOf":{"@id":"https:\/\/softreetechnology.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/softreetechnology.com\/blog\/all\/open-performance-point-report-new-window-javascript-solution\/#primaryimage"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/all\/open-performance-point-report-new-window-javascript-solution\/#primaryimage"},"thumbnailUrl":"","datePublished":"2016-10-14T13:21:25+00:00","breadcrumb":{"@id":"https:\/\/softreetechnology.com\/blog\/all\/open-performance-point-report-new-window-javascript-solution\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/softreetechnology.com\/blog\/all\/open-performance-point-report-new-window-javascript-solution\/"]}]},{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/all\/open-performance-point-report-new-window-javascript-solution\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/softreetechnology.com\/blog\/all\/open-performance-point-report-new-window-javascript-solution\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/softreetechnology.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Open a Performance Point Report in a New Window – JavaScript Solution"}]},{"@type":"WebSite","@id":"https:\/\/softreetechnology.com\/blog\/#website","url":"https:\/\/softreetechnology.com\/blog\/","name":"Softree Technology","description":"Celebrating 10+ Years in SharePoint Consulting !","publisher":{"@id":"https:\/\/softreetechnology.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/softreetechnology.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/softreetechnology.com\/blog\/#organization","name":"Softree Technology","url":"https:\/\/softreetechnology.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2023\/03\/cropped-white-logo-soft.png","contentUrl":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2023\/03\/cropped-white-logo-soft.png","width":844,"height":230,"caption":"Softree Technology"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/98740297642f06debccdcee2de84086b","name":"admin","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6fc78c8a7aa3fb0bf43c3b9a2e3962d7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6fc78c8a7aa3fb0bf43c3b9a2e3962d7?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/softreeconsulting.com"],"url":"https:\/\/softreetechnology.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts\/617","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/comments?post=617"}],"version-history":[{"count":0,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts\/617\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/media?parent=617"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/categories?post=617"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/tags?post=617"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}