Report Parameters

[Ricardo]

Hello Guys, 

How I can to make my query to receive a parameter using '%like%'?

I tried this 3 options below but its dont working ( last(5ª) line )

SELECT PSR.NOME, CO.NOME, FU.NOME, CO.ATIVO,CO.ID_PSR
FROM COLABORADOR CO
LEFT OUTER JOIN PSR ON PSR.ID_PSR = CO.ID_PSR
LEFT OUTER JOIN FUNCAO FU ON FU.ID_FUNCAO = CO.ID_FUNCAO
WHERE PSR.NOME LIKE %@Nome_PSR%

SELECT PSR.NOME, CO.NOME, FU.NOME, CO.ATIVO,CO.ID_PSR
FROM COLABORADOR CO
LEFT OUTER JOIN PSR ON PSR.ID_PSR = CO.ID_PSR
LEFT OUTER JOIN FUNCAO FU ON FU.ID_FUNCAO = CO.ID_FUNCAO
WHERE PSR.NOME LIKE '%@Nome_PSR%'

SELECT PSR.NOME, CO.NOME, FU.NOME, CO.ATIVO,CO.ID_PSR
FROM COLABORADOR CO
LEFT OUTER JOIN PSR ON PSR.ID_PSR = CO.ID_PSR
LEFT OUTER JOIN FUNCAO FU ON FU.ID_FUNCAO = CO.ID_FUNCAO
WHERE PSR.NOME LIKE @Nome_PSR


Follow in attachment

[IvanY]

Hello Ricardo,

Up to your question - you can easily achieve your task by writing LIKE '%' + @Nome_PSR + '%'.

I hope that helps.

All the best,
IvanY
the Telerik team

[Ricardo]

Hi Iva,n!

Thanks for your Help!
I've a parameter in my report filled with all stores registered in a table. I need configure this field to the query bring the results if the user select only one store, and a option "ALL", the report search for all stores, do you know how can I do this?

I cant find where configure the dropdown to receive the value ALL

Rgrds, 

[IvanY]

Hello Ricardo,

Since all locations can be combined you need multivalue parameter, which has the select all option and also will give your users the possibility to select more than one value for the parameter.

Greetings,
IvanY
the Telerik team