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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SDK question: How to send a "range" parameter to a report?

Status
Not open for further replies.

Peptron

Technical User
Oct 15, 2003
2
CA
I have a report to which I have to send a range of values. It is a single parameter that receives a range of integer, let's say "1 to 100".

No matter what I've tried, I've always ended up with those errors:
QFS-ERR-0139 The request has multiple errors.
RQP-DEF-0354 The query contains one or more unresolved prompts.
QE-DEF-0387 Invalid format for numeric prompt 'param'.

I've put a "ParamDisplayValue('param')" in my report to try to find out what is the value passed when the report is run manually, and it shows "Between 1 and 100". I've tried sending that and it doesn't work, so I think it is just a "display" value and the actual parameter value passed is something else.
 
Internally the ParamValue is something like 1:100 but you shouldn't have to worry about that...
Can you describe how you are using the parameter or otherwise elaborate on the circumstances under which you receive the error(s)? Normally it's sufficient to enable the Range property on the prompt and then use the in_range comparison operator in your filter. When you say "send" do you mean passing the parameter via drillthrough?


 
Please disregard my previous post/inquiry - I overlooked "SDK" in your subject! Sorry but I can't help you there...
 
Hi,

Instead of using "ParamDisplayValue('param')" in your report, use "ParamValue('param')" to see the real parameter value (and not its nicely formatted display). Once you have a handle on what the real expected value is, you should be able to pass the relevant value yourself.

Regards,

MF.
 
I've tried "ParamValue('param')", and unfortunately still displays "Between 1 and 100"...

Like almeids said, I suspect that the right way to send it is simply a special character separating both values, like 1:100. (Tryed that, it's not ":".)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top