cancel
Showing results for 
Search instead for 
Did you mean: 

SAP B1 Query User defined parameter (checkbox)

kjetil_sandvik2
Participant
0 Kudos

Hi,

Is it possible in a query to add user defined parameters?

Example, I want to run a query from OITM table with Item Properties as parameter. But I want the users to be able to choose one or more properties as parameters in the query. I would like to use AND as a clause if more than one Item Property is choosed.

Query example:

Select ItemCode, ItemName, ItmsGrpCod

FROM OITM

WHERE ItmsGrpCod = 100 AND (Here I would like to add a parameter where user can choose one or more of the 64 different Item Properties. I.e. a checkbox would be perfect!)

Regards

Kjetil Sandvik

Accepted Solutions (1)

Accepted Solutions (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Not possible to add check box in query. Please try with crystal report.

Thanks & Regards,

Nagarajan

Answers (2)

Answers (2)

agustin_marcoscividanes
Active Contributor
0 Kudos

Hi

you have to add all property fields in where clausule with a parameter.

SBO shows the property name and drop list with valid values.

Kind regards.

Agustín Marcos Cividanes

former_member186095
Active Contributor
0 Kudos

Hi,

it is impossible in the query generator.

here is the sample:

The option is yes or no instead of checkbox.

You can use SSRS that possibly support checkbox

Regards,