Solved

Javascript used in the report .

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

Accepted Solution

by:
Rob 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
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…

860 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