Hello,
I have created an MS SQL T-SQL stored procedure with a single NVARCHAR(10) input parameter, @BranchID.
I need to use it within a Chart and Advanced List DataParts, so I entered it in any of the following ways in the Change SQL query menu but nothing works. Please see below for what I have tried:
exec stp_KPORTAL_STORES_KPIS_StoreClientsPerHour '@input' (it is accepted, BUT, I don't get to connect @input to another Provider Filter web part, i.e. the Configure Parameters option/link does NOT show up in the ToolPane).
exec stp_KPORTAL_STORES_KPIS_StoreClientsPerHour @input