[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 882
  • Last Modified:

Default text value for parameters in SSRS 2008

Hi,

This looks like a dump question, but I have spent time trying to figure that out.

I want the parameter to show (ALL), as a default value in the unit parameter!

I tryed ="ALL". but for some reason it didn't work!
pic1.JPG
pic2.JPG
0
alcsoft
Asked:
alcsoft
1 Solution
 
sammySeltzerCommented:
Click on Fx and enter this as experssion to see what happens.

[Regions].[RegionsDesc].[All]

change to your own needs
0
 
alcsoftAuthor Commented:
This one will pull the value of the fiels [ALL], I want a static string "ALL"
0
 
sureshbabukrishCommented:
if you give default value as 'ALL', this will show only when you do not pass any values to the report.
while specifying the values , if you key in [ALL], then also it won't work

what you have to do is, use a query to provide list of values for the parameter filter as shown below

select 'ALL'
union all
select StateName from State

use this to populate the filter and then set ALL as default value
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
alcsoftAuthor Commented:
I tried 'ALL' as a default value in the box that you see in the pic2 and it did't work!
This box is free text field, I might go with your code if it is drop down menue!

So basically I want a text box have ALL as a default value and if the user want to change it, he will delete (ALL), and write down something like (mile)!

I know in MS2005 I can set such default value using ="ALL"

But here for some reason it won't work!

0
 
ValentinoVBI ConsultantCommented:
I support the suggestion made by suresh, but I would add an ID to the query.  I assume that the units are coming from a database table, right?  And in a normalized structure, this table would contain a numeric identifier.  This ID will then be your parameter Value, while the Name field is the parameter Label.

See code for a possible source query for your parameter (adapt to your table/field names).

Your default should then be set to -1.
select UnitID, UnitName
from UnitTable
union all
select -1, '<ALL>'

Open in new window

0
 
alcsoftAuthor Commented:
Please I am using a normal text Box, it is not a drop down menue!

I want to have one value!! which is "ALL"
0
 
ValentinoVBI ConsultantCommented:
I see, that shouldn't be too much trouble to get working.  Instead of typing ="All", just type the value that you want, for instance All (without any quotes or equals sign).  That should work!
0
 
alcsoftAuthor Commented:
Yes this is what I want.. I knew it is not hard job.... it is just related to the data syntax!
Microsoft keep changing the syntax!!!
Thanks ValemtionV
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now