Solved

Javascript used in the report .

Posted on 2010-11-09
1
315 Views
Last Modified: 2012-05-10
Hi Experts,

            I have used the parameter Management_Awareness_Rating, which is a Multi value parameter and I am using the Java script , as the requirement is to display in a new window.

 Management_Awareness_Rating(retrieved from database) is one of the parameter used and there is no value for it in the database for some Issue Id's and Project Id's.

Question :

when there  is no value for the above  parameter Management_Awareness_Rating, then I want to  write an expression like this.  

IIf(Parameters!Management_Awareness_Rating.Value  <> '' , '',
+"&Management_Awareness_Rating="+join(Parameters!Management_Awareness_Rating.Value,"&Management_Awareness_Rating=")

I don't know how to pass an empty string to the Java Script when there is no value. Could you please check my requirement above and correct my Java script mentioned below. I appreciate your immediate reply with solution.


Java Script Used for Drill through  (in the Series Properties----->Action----->Go to URL) in my Main Report :

="javascript:void(window.open('http://iisau182dev68.appdev.corptst.anz.com/ReportServer/Pages/ReportViewer.aspx?/ARMD_Dev/Trend_Analysis_Issues_Raised_by_Issue_Rating_Detail&rs:Command=Render&rc:Parameters=false&rc:HeaderArea=None&Start_Date="+Format(ParametersStart_Date.Value,"dd/MM/yyyy")
+"&Division="+join(Parameters!Division.Value,"&Division=")
+"&Management_Awareness_Rating="+join(Parameters!Management_Awareness_Rating.Value,"&Management_Awareness_Rating=")
+"&Report_Rating="+join(Parameters!Report_Rating.Value,"&Report_Rating=")
+"&BU="+join(Parameters!BU.Value,"&BU=")
+"&End_Date="+Format(Parameters!End_Date.Value,"dd/MM/yyy")
+"&Division_Owned_And_Allocated="+Parameters!Division_Owned_And_Allocated.Value
+"&Audit_Manager="+Parameters!Audit_Manager.Value
+"&Issue_Owner="+Parameters!Issue_Owner.Value
+"&Issue_Rating="+Fields!Issue_Rating.Value
+"&Month_And_Year="+ FORMAT(Fields!ACTISSUEDATE.Value,"MMM-yy")+"','ChildW','toolbar=yes,location=yes,directories=yes,status=yes,menubar=yes,resizable=yes,scrollbars=yes'))"


Regards,

Sreekanth.
0
Comment
Question by:n_srikanth4
1 Comment
 
LVL 42

Accepted Solution

by:
Rob Jurd, EE MVE earned 500 total points
ID: 34107604
easy, just change:


+"&Management_Awareness_Rating="+join(Parameters!Management_Awareness_Rating.Value,"&Management_Awareness_Rating=")


to

+if(Parameters!Management_Awareness_Rating.Value != '' ,"&Management_Awareness_Rating="+join(Parameters!Management_Awareness_Rating.Value,"&Management_Awareness_Rating="),'')
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question