Solved

Javascript used in the report .

Posted on 2010-11-09
1
312 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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
SQL 2012 Syntax Error 5 24
SQL Select Query help 3 31
SSIS import multiple CSVs into associated tables 3 28
Row-Level Security 2 17
This article discusses the difference between strict equality operator and equality operator in JavaScript. The Need: Because JavaScript performs an implicit type conversion when performing comparisons, we have to take this into account when wri…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
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…

707 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now