Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using ParameterFields(0) with a range

Status
Not open for further replies.

APS

Vendor
Sep 25, 2000
53
US
Hi

I am using the ParameterFields(0) command successfully in code to pass a value to the parameter field in a report but I am having a problem. My parameter field is set for a range of values. When I pass the value it is changing both the Start of range and End of range values. Can I pass different values to the Start and End values or will I need to change the report and have two different parameter fields?

Thanks for any help!
Anthony
 
APS: From your posting it seems that you are only passing 1 value for the parameter. As this is a range parameter it would expect 2 values so is probably taking your single entry as both Start and End of range. Either end 2 values or modify report to have 2 parameters and set each to only have Discrete values David C. Monks
david.monks@chase-international.com
Accredited Seagate Enterprise Partner
 
David

I am only passing one value the way it is setup currently.
Here is my statement.

V_CRYSTAL.ParameterFields(7) = myvalue

What do I change to pass a Start and End range to the same parameter field V_CRYSTAL.ParameterFields(7) ?

Thanks
Anthony
 
Anthony: You don;t state what type your parameter is but I've assumed a String. You should be able to pass a comma separated list as in myvalue1 & ","& myvalue2 etc. and this should populate the array.

I would say in passing that Seagate themselves state that you can't currently use multiple response parameters even in v8 but it may work. Alternatively, you'll need to have a ParameterFields(7) for myvalue1 and ParameterFields(8) for myvalue2. Hope this helps David C. Monks
david.monks@chase-international.com
Accredited Seagate Enterprise Partner
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top