Help with web based parameters. 1

[Legion13]

I have a report that I am running from an asp page. I am using input boxes to get text from the user that is passed to the report like so:

set session("ParamCollection&quot = Session("oRpt&quot.Parameterfields
set Param01 = session("ParamCollection&quot.Item(1)
ParamValue01 = Request.Form("Param01&quot
Call Param01.SetCurrentValue (CStr(ParamValue01), 12)

Basically I am just taking the parameters example from from the seagate software sample asp pages and modifying it. It works fine for single value parameters, but I need to be able to pass multiple values to a single parameter field that has been set to accept multiple values. Is this possible? Also, are there better examples on web based use of the activex viewer? If so, where can I find them? Thank you in advance!

 

[FowlerConsulting]

You can access multi form values like this

Param01_1 = CStr(Request.Form("Param01")(1))
Param01_2 = CStr(Request.Form("Param01")(2))
Param01_3 = CStr(Request.Form("Param01")(3))

Just like

.SetCurrentValue

there is another method to add additional values to the same parameter... not sure what the name is off the top of my head.

Steven Fowler
info@fowlerconsulting.com

http://www.fowlerconsulting.com

 

[Legion13]

Thank you very much for your help! If you happen to recall what it is please let me know. In the mean time, thanks again for your help.

 

[FowlerConsulting]

Version 7.0 or 8.0
Steven Fowler
steven_m_fowler@yahoo.com

http://www.fowlerconsulting.com

 

[Legion13]

That would be version 8.

 

[FowlerConsulting]

This took me two hours to code!
I hope you appreciate it...

'Pars the form values
aryValues = Split(Request.Form("Parameter"),",")
for intLoop = 0 to Request.Form("Parameter").Count -1
  session("oRPT").Parameterfields.AddCurrentValue cStr(trim(aryValues(intLoop)))
next

Steven Fowler, Principal
steve.fowler@fowlerconsulting.com

http://www.fowlerconsulting.com

- Development, Training, and Consulting

 

[FowlerConsulting]

You will need to reference you param in the report like this

session("oRPT&quot.Parameterfields(1).AddCurrentValue
session("oRPT&quot.Parameterfields(2).AddCurrentValue

etc...

Steven Fowler, Principal
steve.fowler@fowlerconsulting.com

http://www.fowlerconsulting.com

- Development, Training, and Consulting

 

[Legion13]

Wow. Thank you very much. I certainly do appreciate it! I would have been happy just to know about .addcurrentvalue, but that bit of code was definitely above and beyond. Thank you again, you have been very helpful, and I have voted you tipmaster for sure.

 

[FowlerConsulting]

Thanks...

aryValues = Split(Request.Form("Parameter"),",")

is a better way then this:

Param01_1 = CStr(Request.Form("Param01")(1))
Param01_2 = CStr(Request.Form("Param01")(2))
Param01_3 = CStr(Request.Form("Param01")(3))

Steven Fowler, Principal
steve.fowler@fowlerconsulting.com

http://www.fowlerconsulting.com

- Development, Training, and Consulting

 

[Legion13]

Yes the loop definitely fits better into what I am doing here, since I don't know exactly how many items they might choose to select. I appreciate your help.