Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

MS SQL Reporting Services Report Parameters Prompt

Posted on 2004-08-10
2
Medium Priority
?
2,022 Views
Last Modified: 2008-02-07
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
0
Comment
Question by:Gezna
2 Comments
 
LVL 1

Accepted Solution

by:
jasonwisdom earned 1500 total points
ID: 11763705

The difficulty is that parameters are string variables.  They are client-side.  Kind of like a querystring parameter on an ASP page.  You can't embed <%=if time=12noon then call mymethod%> command into a URL.  (neither can you put ASP.NET functionality into a querystring).

So my thinking is that SQL Reporting parameters work the same way.  Might it be possible to have code which will read the string Parameter and react accordingly?

How are you looking to use this report?  In an ASP.NET page, as a standalone URL on a ReportServer, or other?
0
 

Author Comment

by:Gezna
ID: 11792623
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
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question