Open Report in a new window from Action in SSRS

Hi,

While developing a SSRS report, initially we set the Action property of the text box with the following value that will open the CRM’s Account record

=Parameters!CRM_URL.Value & “?ID={“&Fields!accountid.Value.ToString()&”}&OTC=1″

It was working fine however when we were using the same report inside the Dashboard, the report was not showing up properly as it was inside the IFrame.

So we had to use window.open for the Action’s Expression to open the report properly in a new window from inside Dashboard’s iframe.

=“javascript:void(window.open(‘”+ Parameters!CRM_URL.Value + “?ID={“ + Fields!accountid.Value.ToString() +“}&OTC=1′ ,’_blank’))”

Hope it helps.


Author: Nishant Rana

I love working in and sharing everything about Microsoft.NET technology !

1 thought on “Open Report in a new window from Action in SSRS”

  1. HI Nishant

    I am having major problems with my Go To Action URL. I am trying to open up a dynamically built url to a page outisde of CRM. MY code is below:-

    =”javascript:void(window.open(CreateVDIURI(window.location.host,window.location.hostname,” + CStr(Fields!CIDHigh.Value) + CStr(Fields!CIDLow.Value) + “)))”

    SO whenever i click the link it opens up a window with the url:-

    javascript:void(window.location.href=(CreateVDIURI(window.location.host,window.location.hostname,1377608149268435593)))

    However this link does when i run the report from SSRS.

    ANy help please.

    REgards

    Lee

    Like

Share your thoughts

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s