getting a range of sting values as parameters

I am trying to create parameters for a range of inventory bin numbers in a BIRT report. I am familiar with using the parameter code for one single parameter, for example a Site:

if (params["prmSite"].value) {
where += " and " + MXReportSqlFormat.createParamWhereClause("inventory.siteid", params["prmSite"]);
}

And I have also used parameters to get a range of dates:

if (params["prmStartDate"].value) {
where += " and matrectrans.actualdate >= "
+ MXReportSqlFormat.getStartDayTimestampFunction(params["prmStartDate"]);
}

if (params["prmEndDate"].value) {
where += " and matrectrans.actualdate <= "
+ MXReportSqlFormat.getEndDayTimestampFunction(params["prmEndDate"]);
}

But I can't seem to find a function that will work like the .GetStartDayTimestampFunction and .GetEndDayTimestampFunction with string values, such as Starting Bin Number and Ending Bin Number.

Can anyone help me?

Thanks in advance ...

Find more posts tagged with

Comments

kjawahar

Do you want to conver the starting and end bin number to String?
If that is the case, toString() may help

var c = (16 * 24)/49 + 12;
d = c.toString();

Here c is a number and d is a string.

John H

<blockquote class='ipsBlockquote' data-author="'kjawahar'" data-cid="70422" data-time="1290041086" data-date="17 November 2010 - 05:44 PM">
Do you want to conver the starting and end bin number to String? 
If that is the case, toString() may help 
 
var c = (16 * 24)/49 + 12; 
d = c.toString(); 
 
Here c is a number and d is a string. </blockquote>

John H

kjawahar,

Thanks for the reply, but that is not the issue i need help with. The bin numbers are string values, not numeric (example: X109110 or M128745). I have four parameters: Site, Storeroom, Beginning Bin Number and Ending Bin Number.

The Site and Storeroom parameter values are handled in the Open code with no problems. However, I am having a problem converting what the user enters as the Starting Bin Number and Ending Bin Number so that there is a range of bin number values from which to choose the records.

I need something like the MXReportSqlFormat.getStartDayTimestampFunction and MXReportSqlFormat.getEndDayTimestampFunction that handle starting and ending dates, except I need it for string values.

Does that make sense?