Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

MS SQL Reporting Services Report Parameters Prompt

Posted on 2004-08-10
2
2,002 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

860 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