[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

MS SQL Reporting Services Report Parameters Prompt

Posted on 2004-08-10
2
Medium Priority
?
2,013 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
[X]
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
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

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

656 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