This is a multi-part message in MIME format.
--=_NextPart_000_001F_01C6A504.61E9EAD0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I have a parameter for displaying information from a particular = department, or from all departments. I can do the filter for a specific = department, but how do I set it up so that if the user selects all, I = basically ignore the deaprtment filter?
Thanks.
Jerry
--=_NextPart_000_001F_01C6A504.61E9EAD0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
I have a parameter for displaying = information from a particular department, or from all departments. I can do the = filter for a specific department, but how do I set it up so that if the user = selects all, I basically ignore the deaprtment filter?
Thanks.
Jerry
--=_NextPart_000_001F_01C6A504.61E9EAD0--Hi
You should use UnionAll to get all the department when u click ALL.
"rlrcstr@.newsgroups.nospam" wrote:
> I have a parameter for displaying information from a particular department, or from all departments. I can do the filter for a specific department, but how do I set it up so that if the user selects all, I basically ignore the deaprtment filter?
> Thanks|||Hi Jerry.
Thank you for your posting and thanks Calvin's suggestion.
If you are using SQL Reporting Services 2005, I think you could use
Multi-Value Parameter to implement this requirement.
For more detailed information, please try to follow this article:
Using Parameters in a Report
http://msdn2.microsoft.com/en-us/library/ms155917.aspx
Single and Multivalued Parameters
You can define a multivalued parameter by selecting the Multivalued option
in the Report Parameters dialog box. If this checkbox is not selected, the
parameter is single-valued. Specifying the Multivalued option adds
checkboxes to the available values in a parameter drop-down list in the
published report. Users can check the values they want; for example, in the
Sales Reason Comparisons sample report, users can select multiple products
to view the combined sales data for those products.
Hope this will be helpful for you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||The issue isn't in having the user select the requirements, it's in how to
implement the selection in the matrix control's filters.
Thanks.
Jerry
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:EgZJkRYpGHA.4612@.TK2MSFTNGXA01.phx.gbl...
> Hi Jerry.
> Thank you for your posting and thanks Calvin's suggestion.
> If you are using SQL Reporting Services 2005, I think you could use
> Multi-Value Parameter to implement this requirement.
> For more detailed information, please try to follow this article:
> Using Parameters in a Report
> http://msdn2.microsoft.com/en-us/library/ms155917.aspx
> Single and Multivalued Parameters
> You can define a multivalued parameter by selecting the Multivalued option
> in the Report Parameters dialog box. If this checkbox is not selected, the
> parameter is single-valued. Specifying the Multivalued option adds
> checkboxes to the available values in a parameter drop-down list in the
> published report. Users can check the values they want; for example, in
> the
> Sales Reason Comparisons sample report, users can select multiple products
> to view the combined sales data for those products.
> Hope this will be helpful for you!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Can you give me an example of how to implement this in the filters of a
matrix control on the report? Thanks.
Jerry
"calvin" <calvin@.discussions.microsoft.com> wrote in message
news:03B634AB-BA3A-4A7A-AFB4-A08ABE89439B@.microsoft.com...
> Hi
> You should use UnionAll to get all the department when u click ALL.
> "rlrcstr@.newsgroups.nospam" wrote:
>> I have a parameter for displaying information from a particular
>> department, or from all departments. I can do the filter for a specific
>> department, but how do I set it up so that if the user selects all, I
>> basically ignore the deaprtment filter?
>> Thanks|||Hi Jerry,
Thank you for the update.
I would like to know the filter you use in the matrix. Would you please
post it here? Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Jerry,
Have you got any progress on this issue? As Wei has mentioned in the last
reply, if you need further help on this, you can post the detailed info
about the filter you used in the matrix so that we can take some further
look into it. As always, if there is anything else we can help, please feel
free to post here.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||I haven't really made much progress here...
I have a data source that is a stored procedure. Let say, for instance,
that I get all records for all employees. In the report, I want to give the
viewer the option to see all employees, active employees, suspended
employees or decommissioned employees.
(The status of an employee is stored in the EmployeeStatus field. 1 =active, 2 = suspended, 4 = decommissioned)
I have no problem creating a filter that will show any of the selected
employee types. The issue is when the user wants to see all employees. How
do I set that up in the filter dialog? Thanks.
Jerry
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:GOfFXVkqGHA.5392@.TK2MSFTNGXA01.phx.gbl...
> Hello Jerry,
> Have you got any progress on this issue? As Wei has mentioned in the last
> reply, if you need further help on this, you can post the detailed info
> about the filter you used in the matrix so that we can take some further
> look into it. As always, if there is anything else we can help, please
> feel
> free to post here.
> Sincerely,
> Steven Cheng
> Microsoft MSDN Online Support Lead
> ==================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Never mind... Figured it out. Thanks.
<rlrcstr@.newsgroups.nospam> wrote in message
news:u63vXVBsGHA.596@.TK2MSFTNGP04.phx.gbl...
>I haven't really made much progress here...
> I have a data source that is a stored procedure. Let say, for instance,
> that I get all records for all employees. In the report, I want to give
> the viewer the option to see all employees, active employees, suspended
> employees or decommissioned employees.
> (The status of an employee is stored in the EmployeeStatus field. 1 => active, 2 = suspended, 4 = decommissioned)
> I have no problem creating a filter that will show any of the selected
> employee types. The issue is when the user wants to see all employees.
> How do I set that up in the filter dialog? Thanks.
> Jerry
>
>
> "Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
> news:GOfFXVkqGHA.5392@.TK2MSFTNGXA01.phx.gbl...
>> Hello Jerry,
>> Have you got any progress on this issue? As Wei has mentioned in the last
>> reply, if you need further help on this, you can post the detailed info
>> about the filter you used in the matrix so that we can take some further
>> look into it. As always, if there is anything else we can help, please
>> feel
>> free to post here.
>> Sincerely,
>> Steven Cheng
>> Microsoft MSDN Online Support Lead
>> ==================================================>>
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>
No comments:
Post a Comment