Solved

MS SQL Reporting Services Report Parameters Prompt

Posted on 2004-08-10
2
1,999 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 500 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Best Approach for querying across several columns. 15 54
SQL Select - Help with CASE 4 42
SQL FUll Text Not returning any results 2 15
Update data using formula 22 19
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

919 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now