• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 323
  • Last Modified:

Javascript used in the report .

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
n_srikanth4
Asked:
n_srikanth4
1 Solution
 
RobOwner (Aidellio)Commented:
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

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now