Getting only active records

I have a report that lists companies from a table. I want to be able to
print either active, inactive or all records. The table has a field named
InactiveDate and if it is null the company is active. How can I setup
report parameter(s) to get just active, just inactive, or all? Thanks.
DavidOn Mar 8, 11:41 am, "David" <dlch...@.lifetimeinc.com> wrote:
> I have a report that lists companies from a table. I want to be able to
> print either active, inactive or all records. The table has a field named
> InactiveDate and if it is null the company is active. How can I setup
> report parameter(s) to get just active, just inactive, or all? Thanks.
> David
What version of SSRS are you using?|||On Mar 9, 6:41 am, "David" <dlch...@.lifetimeinc.com> wrote:
> I have a report that lists companies from a table. I want to be able to
> print either active, inactive or all records. The table has a field named
> InactiveDate and if it is null the company is active. How can I setup
> report parameter(s) to get just active, just inactive, or all? Thanks.
> David
You can set up a stored procedure to accept a parameter @.Status and
return the list of data based on this.
E.g 0 for All, 1 for Active, 2 for Inactive
When you point your dataset to this stored proc, the parameter will
automatically be added to your report. Then set up this parameter to
come from a non-queried list and type in appropriate values to pass to
the stored procedure as above: Name: All, Value: 0; Name: Active,
Value: 1; Name:Inactive, Value: 3;
Rowen|||Thank you, that worked great. We are using SQL 2005.
David
"Rowen" <rowenmcd@.gmail.com> wrote in message
news:1173407563.877928.216060@.p10g2000cwp.googlegroups.com...
> On Mar 9, 6:41 am, "David" <dlch...@.lifetimeinc.com> wrote:
>> I have a report that lists companies from a table. I want to be able to
>> print either active, inactive or all records. The table has a field
>> named
>> InactiveDate and if it is null the company is active. How can I setup
>> report parameter(s) to get just active, just inactive, or all? Thanks.
>> David
> You can set up a stored procedure to accept a parameter @.Status and
> return the list of data based on this.
> E.g 0 for All, 1 for Active, 2 for Inactive
> When you point your dataset to this stored proc, the parameter will
> automatically be added to your report. Then set up this parameter to
> come from a non-queried list and type in appropriate values to pass to
> the stored procedure as above: Name: All, Value: 0; Name: Active,
> Value: 1; Name:Inactive, Value: 3;
> Rowen
>