Not sure if I completely follow you. A stored procedure might have a parameter of “any” type and can use it in its query. A simple example courtesy w3schools would be
CREATE PROCEDURE SelectAllCustomers @City nvarchar(30)
AS
SELECT * FROM Customers WHERE City = @City
GO;
We’ll offer means to freely parametrize the @City parameter in Report Server 25. I’ve posted a design study of the (not yet localized) UI in this thread a couple of days ago, should be pretty self explaining: