Hello,

I've started using Seal Report a couple days ago and I'm trying to figure out how can I define input parameters to be used as a filter in the SQL statement for my main table.

Here you have an example:

Select * from myTable where myTable.Col1 = @myParam;

Can anyone help me to understand how can I set the variable @myParam to be passed by the user before executing the query?

Thanks in advance.

Best regards.

Thank you for helping. It worked perfectly!

By the way, I am facing almost the same case but with a DrillDown list based on a Enum.

Should I use it the same way that I did for the other types of input parameters?

I am asking because once I create the restriction based on a Enum List, the output of my view has 2 keys with the same name: one with the Enum List and another one(with the same key) as a input text.

Here is the properties that I've set for the mentioned restriction:

Name : MyRestriction
Operator : Value only
Prompt restriction : Prompt only one value
Is required : True

Data type : Default
Custom Enumerated List : MyEnumList
Use as parameter : true

Am I missing something?

Thank you!

Best regards,

William.