SSRS 2008 - Bar chart when click filter detailed report
i have bar chart report, and i need to set the series as a link so that if i can click on series it opens another report based on that series information which i pass as a parameter. now i have set the action to go to report and its working, but WHAT I WANT IS TO OPEN THE REPORT IN A SEPARATE LOCATION WHEN I CLICK?i need to show both, summary report and drill down report. if i click on that link, the report next to the summary report should filter based on the click. anyone have any idea how to achieve this?| Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |
May 28th, 2011 10:35am

Hi Khurram, From your description, do you mean that you need to display the detail report in a new page? If so, you can add a “Go to URL” action on the summary report, and then use the javascript to open a new page and renders the detail report. For example, set the URL like this: ="javascript:void(window.open(' http://servername/reportserver?/Sales/YearlySalesSummary&rs:Command=Render&parameter=" & Fields!<your Fields>.Value & "'))" For more information about URL Access, please refer to the article below: http://msdn.microsoft.com/en-us/library/ms153586(v=SQL.100).aspx Regards, Bin Long
Free Windows Admin Tool Kit Click here and download it now
May 31st, 2011 6:22am

HI Bin, many thanks for your reply. I have finally overcome the issue of opening a report in a different window, that is OK. what i am stuck with now is the syntax of to pass the parameter in URL. my expression as per your above example is:(i have copy/paste from the visual studio) = "javascript:void(window.open(http://ss-jhq-sspmo-2/ReportServer/Pages/ReportViewer.aspx?%2fPMO+Dashboard%2fBA_SSRS_Prjt_Level_MilestonePerProject&rs:Command=Render&Project_UID="&Fields!ProjectUID.Value&"'))" but its not working, and this is the error its giving me: An error occured during local report processing. the definition of the report '/<reportname>' is invalid. The actioninfo.action.hyperlink expression for the text box '<txtboxname>' contains an error: [BC30277] type character '&' does not match declared data type 'object'. and if i change the syntax, i have seen this in other blogs, with this: = "javascript:void(window.open(http://ss-jhq-sspmo-2/ReportServer/Pages/ReportViewer.aspx?%2fPMO+Dashboard%2fBA_SSRS_Prjt_Level_MilestonePerProject&rs:Command=Render&Project_UID="+Fields!ProjectUID.Value+"'))" it do not give any error, instead the text box doesnt show any hyperlink to click to go to the report. Please help me with this.| Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |
May 31st, 2011 8:00am

Hi Khurram, In the URL, we use the “javascript” to open a new page. JavaScript is the scripting language used on the Web page. In this case, please deploy the report to Report Server. After that, you can click the hyperlink to open a new page and renders the detail report. In addition, please note that there is a space between the "&" sign and "Fields!ProjectUID.Value" field. Please try to use the URL below: ="javascript:void(window.open(http://ss-jhq-sspmo-2/ReportServer/Pages/ReportViewer.aspx?%2fPMO+Dashboard%2fBA_SSRS_Prjt_Level_MilestonePerProject&rs:Command=Render&Project_UID="& Fields!ProjectUID.Value &"'))" If you have any question, please feel free to ask. Thanks, Bin Long
Free Windows Admin Tool Kit Click here and download it now
May 31st, 2011 10:29pm

Hi Bin, thanks for your reply, the syntax with the space is also not working. this is what i am using now, its not giving me any error instead there is no hyper link appearing on the text box to open the report. = "javascript:void(window.open(http://ss-jhq-sspmo-2/ReportServer/Pages/ReportViewer.aspx?%2fPMO+Dashboard%2fBA_SSRS_Prjt_Level_MilestonePerProject&rs:Command=Render&Project_UID="& Fields!ProjectUID.Value &"'))" are you able to refer to any of your old projectss where you might have done similar to this and verify the exact syntax you have used? any other idea? | Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |
June 1st, 2011 2:48am

hi bin, just to update you that its sorted :) my initial expression syntax was correct, only that i have to convert my field parameter to string (what a shame that i didnt notice this earlier ) this is the expression syntax working for me now. "javascript:void(window.open(http://ss-jhq-sspmo-2/ReportServer/Pages/ReportViewer.aspx?%2fPMO+Dashboard%2fBA_SSRS_Prjt_Level_MilestonePerProject&rs:Command=Render&Project_UID="))"+Fields!ProjectUID.Value.tostring()+"' thanks for your effort. One more thing, is there any way i can open the report on the same page but different locaion instead of opening it in seperate window? i have a webpart page, where i have my main report and if i click on the link on main report the detail report opens in new window. ideally i want my detail report to be open next to the main report or below to the main report ? any idea?| Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |
Free Windows Admin Tool Kit Click here and download it now
June 1st, 2011 8:08am

Hi Khurram, I’m glad to hear about that your issue has been solved. For the new question, I think that you can add a subreport to the main report, the subreport is use to display the detail report. Add a Boolean parameter to control the subreport is shown or hidden. After that, add an action on the main report and configure the URL is always drillthough itself. In order to achieve this, please take the following steps of my sample as a reference: 1. In the main report, add a parameter which is named “Boolean” and select “Boolean” as the data type. In the “Default values” page, specify the “TRUE” value as the default value. 2. In the Report Data window, drag a subreport to the main report. Right-click the subreport and select “Subreport Properties”. In the “Use this report as a subreport” section, select the “Detail report” as the subreprot. 3. Click “Visibility”. Select the “Show or hide based on an expression” option, and set the expression like this: [@Boolean] 4. Click “Parameters”. Click “Add”, and then fill in “Your_Parameter_Name” and “Your_Parameter_Value”. (Note: It is use to pass the parameter value which is click on the main report.) 5. Add an action and select “Go to URL” option on the main report, and then set the URL like this: ="http://servername/reportserver?/Sales/YearlySalesSummary&rs:Command=Render &parameter=" & Fields!<your Fields>.Value & "&Boolean=" & FALSE (Note: The URL passes a “FALSE” value to show the subreport, and configure URL address is always drillthough itself(the main report). By the way, you can also add a “Go to report” action on the main report) If you have any question, please feel free to ask. Thanks, Bin Long
June 2nd, 2011 12:01am

thanks alot Bin for your help and effort, much appriciated.| Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |
Free Windows Admin Tool Kit Click here and download it now
June 5th, 2011 4:07pm

Hello Bin, Is there a way to click at the link and it will shows up in a new tab rather than a new window? If so, do you have instructions/hints for that? My developer said that it's impossible so I just want to double check. Thanks, LongLong Nguyen
June 22nd, 2011 6:55pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics