Hi,
I am using ODBC to connect PostgreSQL in SSRS.
and face issue
Cannot add multi value query parameter '@CountryId' for dataset 'ds_GetPractice' because it is not supported by the data extension. (rsErrorAddingMultiValueQueryParameter)
I have two dataset
the first dataset (DS1) will return two value CountryId and CountryName,
the second dataset (DS2) will use the first dataset's CountryId as parameter, this allow multiple values.
this is my DS2 query:
select PracticeId , PracticeName
from PracticeDim
where CountryId in (select cast(regexp_split_to_table(?,',') as int))
I post this query to pg_admin and this is workable as below,
select PracticeId , PracticeName
from PracticeDim
where CountryId in (select cast(regexp_split_to_table('1,2,3,4,5,6',',') as int))
Please help