roberthagan
Technical User
I'm planning a deployment of RS that uses stored procedures to parse out multiselect paramters, but I'd like to do this in our old system without a stored procedure.
Im currently using Visual Studio 2005 with SP2, running against Oracle 8i.
I found a proposed solution at SQL Server Central
(the entry by dph-446223 on page one)
Translated to oracle syntax the where clause is this:
WHERE CommaDelimtedList || ',' LIKE '%' || TableColumnToCompareTo || ',%' OR @CommaDelimtedList = '')
This query works in Oracle/TOAD, and in the query section of Reporting Services, but then doesn’t work in the actual report unless only one item is selected. There an oracle error:Invalid relational operator appears. Sounds like the list in not getting parsed into separate elements here.
Does anyone have an idea why?
Thanks
Bob
Im currently using Visual Studio 2005 with SP2, running against Oracle 8i.
I found a proposed solution at SQL Server Central
(the entry by dph-446223 on page one)
Translated to oracle syntax the where clause is this:
WHERE CommaDelimtedList || ',' LIKE '%' || TableColumnToCompareTo || ',%' OR @CommaDelimtedList = '')
This query works in Oracle/TOAD, and in the query section of Reporting Services, but then doesn’t work in the actual report unless only one item is selected. There an oracle error:Invalid relational operator appears. Sounds like the list in not getting parsed into separate elements here.
Does anyone have an idea why?
Thanks
Bob