How a parameter dropdown display show english or french description that is coming from a stored procedure which is returning both english and french desc?
Rather than returning both English and French descriptions you should pass a language parameter to the stored procedure and return the description for the language specified by the parameter. The value for the language can be passed to the report as a parameter, or picked up from the built in SSRS user language property which is picked up from the user setting in the browser.