MS RMS active reports have a report summary section where we can define the table name for report query. But if we want a stored procedure to be executed to get the required values , then we can do so by executing the stored procedure in the PreQuery1 section
ReportType = reporttypeSales
— ALL OTHER VALUES PreQuery1 = “EXEC [YOUR SP NAME]” –…..
— ALL OTHER VALUES
In this way we can execute stored procedures through RMS Active reports