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

parameter with multiple values

Status
Not open for further replies.

jcao0000

MIS
Jun 4, 2007
12
CA
I have a parameter allows multiple values. When I use the following SQL in command object, I always get error. Looks like the syntax problem.

Select ...
FROM ...
WHERE ... AND COLUMNNAME in PARAMETERVARIABLE AND...

Can anyone tell how to use parameter with multiples values in the sql query.




 
First, you should be creating the parameter within the command object. Secondly, commands do not accept multiple values for a parameter. There is a way to use a string of values to make this work, although it's not intuitive for the user. You can also set it up so that the parameter is based on "all" or "one" option.

Why not explain a little more about what you want to do? You should also include your exact query in the post, with the specific error message you are getting.

-LB
 
I have a similar question.
CRXI
BOXI
Oracle Database

The way I have the report set up right now is that I have date parameters in my command object (beginning and ending dates for a range). I then have a dynamic parameter in the report itself. The parameters are working properly and I am getting the correct data.

Here's part one of the question. When running the report in the developer, I am prompted to enter the two date parameters. Then I am prompted to enter the date parameters, as well as the parameter specified within the report. I really don't want the user to have to enter the date twice.

Here's part two of the question. After saving the report on our Enterprise server for end use on Infoview, the report is asking for the date parameter. Then the report is asking for database logon parameters. I've already changed the default database logon information through the Central Managment Server. The report is then asking for the dates again and parameter specified directly in the report (similar to the way it worked in the developer).

Any solves to either or both questions? The first solve would be to have the date prompted only once, or at least still be filled in when prompting on the report driven parameter. The second solve would be to not have a database logon prompt.
 
This doesn't seem related at all, they asked about multiple values passing in a parameter, and you're asking about getting propmted twice.

Please start a new thread for new topics.

it should never prompt for parameters twice if you only have one set of parameters, although if you have a subreport with parameters it might.

You state that you have a date parameter in the command object, then a parameter of unknown type or how it's used in the report, please post specifics on that as well.

-k
 
Sorry, I forgot to mention that I had to put the parameter in the report instead of the command because I wanted the user to be able to enter multiple values. I'd rather have the parameter in the command, but I couldn't figure out how to get it to work, and thought that question/answer might come up.

I have no subreports. The parameter in the report itself is a string, and I am using the select expert to filter on the parameter so the select expert's formula states: {Command.PLU_CODE} = {?PLU} The parameter {?PLU} is a dynamic parameter with a value of PLU_CODE, description of ITEM_DESCRIPTION.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top