Multiple Value Parameters and ASP

[carla]

Hello,

I am posting this again. Someone pointed me to the ASP samples on the Business Objects website and that unfortunately doesn't help me. The mulitple value parameters are hard coded in the samples. I need to know how to pass the checkbox values to the report via ASP. The values will differ everytime the report is used. I am using CR8.5.

I have an HTML form that contains a list of values with checkboxes next to them. I would like the user to be able to select any number of those checkbox values and have those values passed via ASP to a report. The report contains a Multiple Value parameter.

I can get this to work when I hard code the values in the ASP file:

session("oRpt").ParameterFields.GetItemByName("workgroup").EnableMultipleValues = 1
session("oRpt").ParameterFields.GetItemByName("workgroup").AddCurrentValue(CStr("ERX Advanced TAC"))
session("oRpt").ParameterFields.GetItemByName("workgroup").AddCurrentValue(CStr("ERX Product Support"))

But when I use "Request.Form" to pass the values it's not working. Here's my code:

session("oRpt").ParameterFields.GetItemByName("workgroup").EnableMultipleValues = 1
session("oRpt").ParameterFields.GetItemByName("Workgroup").AddCurrentValue(CStr(Request.Form("prompt0")))
session("oRpt").ParameterFields.GetItemByName("workgroup").AddCurrentValue(CStr(Request.Form("prompt0")))

Has anyone ever done this before?

Thanks,
Carla

 

[Turkbear]

Hi,
Check to see what is actually being passed by using a
Response.Write(Request.Form("prompt0")) - it is probably an array ; if so, you will need to loop through it to get each value selected.