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.
>
Showing posts with label mime. Show all posts
Showing posts with label mime. Show all posts
Monday, March 12, 2012
Saturday, February 25, 2012
master4IDR ??
This is a multi-part message in MIME format.
--=_NextPart_000_0015_01C51FEB.C5E3BF60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Does anyone know what the "4IDR" databases are? (Master/Model/MSDB)
MSSQL Log entry: Starting up database 'master4IDR'.
I do see the .mdf & .ldf, but I have no such db on this server.
What are these databases?
Thanx!
--=_NextPart_000_0015_01C51FEB.C5E3BF60
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Does anyone know what = the "4IDR" databases are? (Master/Model/MSDB)
MSSQL Log entry: = Starting up database 'master4IDR'.
I do see the .mdf = & .ldf, but I have no such db on this server.
What are these databases?
Thanx!
--=_NextPart_000_0015_01C51FEB.C5E3BF60--I've never see any such animals. My guess is that some 3rd party tool (like backup sw or similar)
has created these.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"JLS" <jlshoop@.hotmail.com> wrote in message news:eYXq6WBIFHA.2620@.tk2msftngp13.phx.gbl...
Does anyone know what the "4IDR" databases are? (Master/Model/MSDB)
MSSQL Log entry: Starting up database 'master4IDR'.
I do see the .mdf & .ldf, but I have no such db on this server.
What are these databases?
Thanx!|||I did a google search on 'masteri4dr' and got several, but inconclusive,
hits. Many referred to third party backup software.
Try running the query below to identify the databases associated with these
files.
SELECT *
FROM master..sysaltfiles
WHERE filename LIKE '%4IDR.mdf%'
--
Hope this helps.
Dan Guzman
SQL Server MVP
"JLS" <jlshoop@.hotmail.com> wrote in message
news:eYXq6WBIFHA.2620@.tk2msftngp13.phx.gbl...
Does anyone know what the "4IDR" databases are? (Master/Model/MSDB)
MSSQL Log entry: Starting up database 'master4IDR'.
I do see the .mdf & .ldf, but I have no such db on this server.
What are these databases?
Thanx!|||They are copies of databases made by Veritas, when it does an online backup of SQL. Most of the time it cleans up after itself, but when it does not, you will find these files laying around
From http://www.developmentnow.com/g/118_2005_3_0_0_482621/master4IDR-.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com
--=_NextPart_000_0015_01C51FEB.C5E3BF60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Does anyone know what the "4IDR" databases are? (Master/Model/MSDB)
MSSQL Log entry: Starting up database 'master4IDR'.
I do see the .mdf & .ldf, but I have no such db on this server.
What are these databases?
Thanx!
--=_NextPart_000_0015_01C51FEB.C5E3BF60
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Does anyone know what = the "4IDR" databases are? (Master/Model/MSDB)
MSSQL Log entry: = Starting up database 'master4IDR'.
I do see the .mdf = & .ldf, but I have no such db on this server.
What are these databases?
Thanx!
--=_NextPart_000_0015_01C51FEB.C5E3BF60--I've never see any such animals. My guess is that some 3rd party tool (like backup sw or similar)
has created these.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"JLS" <jlshoop@.hotmail.com> wrote in message news:eYXq6WBIFHA.2620@.tk2msftngp13.phx.gbl...
Does anyone know what the "4IDR" databases are? (Master/Model/MSDB)
MSSQL Log entry: Starting up database 'master4IDR'.
I do see the .mdf & .ldf, but I have no such db on this server.
What are these databases?
Thanx!|||I did a google search on 'masteri4dr' and got several, but inconclusive,
hits. Many referred to third party backup software.
Try running the query below to identify the databases associated with these
files.
SELECT *
FROM master..sysaltfiles
WHERE filename LIKE '%4IDR.mdf%'
--
Hope this helps.
Dan Guzman
SQL Server MVP
"JLS" <jlshoop@.hotmail.com> wrote in message
news:eYXq6WBIFHA.2620@.tk2msftngp13.phx.gbl...
Does anyone know what the "4IDR" databases are? (Master/Model/MSDB)
MSSQL Log entry: Starting up database 'master4IDR'.
I do see the .mdf & .ldf, but I have no such db on this server.
What are these databases?
Thanx!|||They are copies of databases made by Veritas, when it does an online backup of SQL. Most of the time it cleans up after itself, but when it does not, you will find these files laying around
From http://www.developmentnow.com/g/118_2005_3_0_0_482621/master4IDR-.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com
Subscribe to:
Comments (Atom)