Good day

I am having trouble with getting an Oracle query right for SQL
reporting service.

I wrote a front end to execute the query and it works fine. Now the
next step is to allow users to get a report on any number of clients.

The way I do this for normal SQL Server, is to build SQL with "AND"s
and "OR"s in code, and then send it to reporting services as a
parameter and append it.

This is the text

="SELECT * FROM TABLE WHERE "+ Parameters!Id.Value

And the value of my parameter is:

ID = 'ALE' OR ID = 'ALO'

I keep getting errors like "SQL command not properly ended".

Have anybody done something similar? Am I missing something?

Any help will be appreciated.

Kind regards,
Karl