The later versions of Cognos introduced the parameters pane which allows for the setting of default values based on other query columns, report expression and additional logic. This can be used to achieve your requirement.