5 replies to this topic

[Erebel55]

I am very confused and frustrated with this..I'm trying to have a report that has 2 prompts and the values of these should change the SQL for my dataset. However, for some reason when I add the second parameter to my script it messes everything up. Can someone please take a look at this? I have attached 2 different attempts at this report..the script in question is the Result Query beforeOpen script. Can someone please help, I have no idea what is going wrong.

Attached Files

•  ET_Information_Detail4.rptdesign   61.3KB   23 downloads
•  ET_Information_Detail6.rptdesign   60.68KB   9 downloads

[Erebel55]

After looking at this longer, I found one problem I think..
When I do this..for some reason it isn't entering the if here..I have no idea why it wouldn't because when I run I only select one value for this parameter..I even have it so multiple values aren't even supported yet. So why would this be happening?

// Parameter 2
var paramName = "ImpactSeverity"; //report parameter

	paramLength = reportContext.getParameterValue(paramName).length;
	
	// One impact assessment type was chosen
	if (paramLength == 1)
	{
		// Replace the default phase type with the single user selection.
		param = reportContext.getParameterValue(paramName);
			
		this.queryText = this.queryText.replace( "High", param);
		//this.queryText = this.queryText.replace( "AND info.CONFIDENTIALITY_IMPACT = ('High')", replaceString);

	}

[Erebel55]

Is there some way I can test to see what paramLength is within Birt Report Designer? I'm very frustrated that this isn't working..it seems elementary that reportLength should be 1...

[Erebel55]

I have found the problem...but can someone please help me fix it?

When I do this..

paramLength = reportContext.getParameterValue(paramName).length;

paramLength is returning as..

function length() {/*
int length()
*/}

What is this and how do I fix it? Someone please help.

[Erebel55]

Ok I solved the above...you cannot check the .length of the parameter like that unless you check the box for allow multiple values. But my script still isn't doing what I want it to.

[Erebel55]

Fixed everything.