Link to home
Start Free TrialLog in
Avatar of Gezna
Gezna

asked on

MS SQL Reporting Services Report Parameters Prompt

Hi there,

Is there a way to have an expression for the text of the report parameters prompt?

I know that if I write a function in the embedded code section then I can put " = code.setParamText(1,User!Language)" anywhere there is an expression button, but is there a way to call this function from the parameters prompt field?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of jasonwisdom
jasonwisdom

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Gezna
Gezna

ASKER

Yes, I was doubtful too. If you could change the prompting text for the report parameters with an expression, then you'd think they would have added an expression button there.

I am planning on embedding the report in a ASP.Net page. I think what I'll have to do instead is have the user fill out the parameters in a form in a ASP.Net page and then pass the parameters directly int the URL and just set header=false, or parameters = false so that the parameter prompt doesn't show and i'll probably just go directly to .pdf format.

The thing is the prompt for the parameters has to be bilingual depending on the user's language. Having both side-by-side is not good enough. It's too bad though because it means I have to duplicate functionality that is already there in the report. So you're sure that's the case? If so, then I'll award the points..

Thanks