Solved

How can I set a report parameter to default to a wildcard in SSRS05?

Posted on 2009-07-16
5
776 Views
Last Modified: 2012-05-07
I have a report that I need to have a default wildcard setting in report parameters. I need this parameter to also be manually kyed to filter the data further as needed by the user. The default wildcard would produce the data the user needs to pick more specific filter.
0
Comment
Question by:mmentele
[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
  • 2
5 Comments
 
LVL 8

Expert Comment

by:Hadush
ID: 24872102
Does your parameter default wild card just '%' or can you be more specific with examples of parameters you want to pass?
 
0
 
LVL 9

Accepted Solution

by:
Hwkranger earned 250 total points
ID: 24872142
You can use a BIT flag (A check box) and then when the user selects it, concatonate a '%' sign to the string.   You'll have to use  the LIKE clause instead of "="



0
 

Author Comment

by:mmentele
ID: 24872228
I have found setting '%' does not work, no data is returned. I will try to be more specific. This report looks at inventory transactions for specific part numbers. I have 4 report parameters; StartDate, EndDate, partID and my new one TraceID. The users can enter a start, end and part# and retrieve data including the TraceID. My user wants to be able to then filter the report further by being able to type in a specific TraceID. I have the report breaking down into sections by sorting by TraceID so I dont get why they want this, but none the less this is the assigned task :-/

Does this help?
0
 
LVL 8

Assisted Solution

by:Hadush
Hadush earned 250 total points
ID: 24872558
Like Hwkranger said change your query to  LIKE ('%TraceID%') and will give the results what ever they want. For example,  when ever they type lats say "A" it will bring all TraceID which contain "A"
 

Where TraceID LIKE ('%TraceID%')

Open in new window

0
 

Author Closing Comment

by:mmentele
ID: 31604354
I ended up changing direction as the needs changed
0

Featured Post

Learn by Doing. Anytime. Anywhere.

Do you like to learn by doing?
Our labs and exercises give you the chance to do just that: Learn by performing actions on real environments.

Hands-on, scenario-based labs give you experience on real environments provided by us so you don't have to worry about breaking anything.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

728 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