I have set up a report in Report Manager which has several subscriptions going to different email addresses, based on a value parameter 'service'. The list of available values for this parameter is dynamically generated by a SQL stored procedure which selects all distinct services which exist in the database; this way if a service gets added, it will be picked up. The query is structured in such a way that the list order should be maintained.
However, I've been told recently that data in reports was incorrect and when I checked the subscription, the value for 'service' was not what I had previously set it to when the report was initially created.
How is the system altering this value?