asked on

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

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.

Hadush

Does your parameter default wild card just '%' or can you be more specific with examples of parameters you want to pass?

ASKER CERTIFIED SOLUTION

Hwkranger

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mmentele

ASKER

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?

SOLUTION