cannot add multi value query parameter
1 Topic
Cannot add multi value query parameter '?' for dataset 'DataSet_Justificatif' because it is not supp
I use AS400 like datasource I want to create a report with 3 filter : year (unique choice ), Mois (multiple choise with all 12 month as default value), City (multiple choice with all city store in my coloun city). I create the 3 parameters and on my dataset, and i specify the parmeters by a char "?" my data set is : --------------------------------- with cedant as ( select client_number,service_agreement_number, SELLING_GROUP from dwe_service_agreement where selling_group in (?) --parameter selling group and sag_on_live = 'Y') , nb as( select periode as "Période", SELLING_GROUP as "Groupe cédant" from DWE_WRK_REFI_PREC a inner join cedant on client_number = num_adh and service_agreement_number = num_cpt where year(periode) = ? and month(periode) in(?) -- parameters year, month ) select * from nb ------------------------ when i execute my report, i have the below issue: An error has occurred during report processing. (rsProcessingAborted) Cannot add multi value query parameter '?' for dataset 'DataSet_Justificatif' because it is not supported by the data extension. (rsErrorAddingMultiValueQueryParameter)Solved907Views0likes3Comments