Parameter not refreshing default data selection

Here is the senerio:

Parameter 1: Company - multi-value

Parameter 2: Employee - multi-value

Available values: Query - Dataset: EmpList

Default values: Query - Dataset: EmpList

Parameter 2 is dependant on Parameter 1.

When a Company is selected, it does update the list of employees in parameter 2. But what it isn't doing is updating my default values.

I select Company A. It populates the Employee list with all of Company A's employees and marks them all as selected (check in the checkbox) and the "Select All" checkbox is also checked.

I then decide I want to include Company B. It populates the Employee list with all of Company B's employees but it does NOT select the employee's from Company B. It is like it ignored the default values query.

I would also think that if "Select All" is checked all new values coming in would be checked.

Is there a way around this problem?

I need to know if this is a bug or if there is something I can do to fix this.

Parameter Layout on SRS report

Hi, I have a list of parameters that I am showing for an srs report
and want them to visually look like this:
Company: <combo box>
Date Range Type: <combo box> From: <combo box> To: <combo
box>
but it's showing them like this:
Company: <combo box> Date Range Type: <combo box>
From: <combo box> To: <combo box>
I don't seem to have a lot of control over this. Is there a way to
set this up so I can format the look of the parameters the way I want
them?You don't have any control over this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Doogie" <dnlwhite@.dtgnet.com> wrote in message
news:77bf060f-5f64-4bc2-861a-765da97425c5@.60g2000hsy.googlegroups.com...
> Hi, I have a list of parameters that I am showing for an srs report
> and want them to visually look like this:
> Company: <combo box>
> Date Range Type: <combo box> From: <combo box> To: <combo
> box>
>
> but it's showing them like this:
> Company: <combo box> Date Range Type: <combo box>
> From: <combo box> To: <combo box>
> I don't seem to have a lot of control over this. Is there a way to
> set this up so I can format the look of the parameters the way I want
> them?|||On Mar 6, 11:47=A0am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> You don't have any control over this.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Doogie" <dnlwh...@.dtgnet.com> wrote in message
> news:77bf060f-5f64-4bc2-861a-765da97425c5@.60g2000hsy.googlegroups.com...
>
> > Hi, I have a list of parameters that I am showing for an srs report
> > and want them to visually look like this:
> > Company: =A0<combo box>
> > Date Range Type: =A0<combo box> =A0 =A0 =A0 From: <combo box> =A0 To: <c=ombo
> > box>
> > but it's showing them like this:
> > Company: =A0<combo box> =A0 =A0 =A0 =A0 =A0Date Range Type: =A0<combo bo=x>
> > From: <combo box> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0To: <combo box>
> > I don't seem to have a lot of control over this. =A0Is there a way to
> > set this up so I can format the look of the parameters the way I want
> > them... Hide quoted text -
> - Show quoted text -
Is there some option for maybe creating hidden combo boxes or
something that may allow me to space things up? I tried to add a
hidden text box and because it was hidden, it didn't actually space
anything out.|||The only way to have control is to have your own website and your own web
page and integrate with RS. A lot of effort though. Truly, there is no
workaround that I am aware of. If there was a workaround I would use it
myself because I do have some reports where this would come in handy. I not
aware of any changes in this area for 2008 either.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Doogie" <dnlwhite@.dtgnet.com> wrote in message
news:16b3a5c4-1031-478c-bd47-af607ac3b91b@.q78g2000hsh.googlegroups.com...
On Mar 6, 11:47 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> You don't have any control over this.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Doogie" <dnlwh...@.dtgnet.com> wrote in message
> news:77bf060f-5f64-4bc2-861a-765da97425c5@.60g2000hsy.googlegroups.com...
>
> > Hi, I have a list of parameters that I am showing for an srs report
> > and want them to visually look like this:
> > Company: <combo box>
> > Date Range Type: <combo box> From: <combo box> To: <combo
> > box>
> > but it's showing them like this:
> > Company: <combo box> Date Range Type: <combo box>
> > From: <combo box> To: <combo box>
> > I don't seem to have a lot of control over this. Is there a way to
> > set this up so I can format the look of the parameters the way I want
> > them... Hide quoted text -
> - Show quoted text -
Is there some option for maybe creating hidden combo boxes or
something that may allow me to space things up? I tried to add a
hidden text box and because it was hidden, it didn't actually space
anything out.

Parameter - Default Value - ALL?

H
I need to have a report parameter that Allows the user to select o
Company name but that has a default value as ALL (i.e. will retur
data for ALL companys
How can I do this
Thanks
DarraDarran,
There are lots of ways to do this but this is how I do it:
Stored Procedure to fill dropdown:
SELECT
"<ALL>" AS CompanyName
, NULL AS CompanyID
UNION
SELECT
CompanyName
, CompanyID
FROM
CompanyTable
--
In RS make sure your parameter "Allows Nulls"
--
Now set the parameter Default to "=Nothing"
--
In your data-select stored procedure use this logic:
...
@.CompanyID INT
...
SELECT (fields)
FROM (data table)
WHERE CompanyID = @.CompanyID OR @.CompanyID IS NULL
--
If the user selects "<ALL>" the stored procedure will ignore the parameter
and select everything.
Hope this helps.
Fred
"Darran" wrote:
> Hi
> I need to have a report parameter that Allows the user to select on
> Company name but that has a default value as ALL (i.e. will return
> data for ALL companys)
> How can I do this?
> Thanks!
> Darran
>sql

Paradox, ObjectPAL, MS SQL 2000

Hi!
My company implemented an in-house computer system that links up the work of
all major departments 10 years ago, using Paradox. Currently, we are still
using Paradox 10, and we are thinking of migrating to MS SQL 2000 server.
Is there any way to export the Paradox tables to the MS SQL 2000 server,
while continue using the ObjectPAL codings that we have already developed?
That is, using ObjectPAL to interact with the MS SQL table, instead of
Paradox table. Is there such a way? Otherwise, if we re-do all the codings in
Visual Basic, or other languages, it would be tedious. Or is there any way to
convert the ObjectPAL codings to other languages that support MS SQL?
Please advise.
Thank you.
I've found out the way to connect to the MS SQL 2000 server using Paradox. I
just define a new alias first, and connect to it and perform a executeSQL
statement, which can allow me to interact with the tables in the SQL 2000
server. But there's an issue, would it then not be storing real-time
information in the server unless the user press a Save button, or something
like that in the interface? Won't this result a lot of other problems like
inconsistency, concurrency and etc?
"wrytat" wrote:

> Hi!
> My company implemented an in-house computer system that links up the work of
> all major departments 10 years ago, using Paradox. Currently, we are still
> using Paradox 10, and we are thinking of migrating to MS SQL 2000 server.
> Is there any way to export the Paradox tables to the MS SQL 2000 server,
> while continue using the ObjectPAL codings that we have already developed?
> That is, using ObjectPAL to interact with the MS SQL table, instead of
> Paradox table. Is there such a way? Otherwise, if we re-do all the codings in
> Visual Basic, or other languages, it would be tedious. Or is there any way to
> convert the ObjectPAL codings to other languages that support MS SQL?
> Please advise.
> Thank you.

Paradox, ObjectPAL, MS SQL 2000

Hi!
My company implemented an in-house computer system that links up the work of
all major departments 10 years ago, using Paradox. Currently, we are still
using Paradox 10, and we are thinking of migrating to MS SQL 2000 server.
Is there any way to export the Paradox tables to the MS SQL 2000 server,
while continue using the ObjectPAL codings that we have already developed?
That is, using ObjectPAL to interact with the MS SQL table, instead of
Paradox table. Is there such a way? Otherwise, if we re-do all the codings in
Visual Basic, or other languages, it would be tedious. Or is there any way to
convert the ObjectPAL codings to other languages that support MS SQL?
Please advise.
Thank you.I've found out the way to connect to the MS SQL 2000 server using Paradox. I
just define a new alias first, and connect to it and perform a executeSQL
statement, which can allow me to interact with the tables in the SQL 2000
server. But there's an issue, would it then not be storing real-time
information in the server unless the user press a Save button, or something
like that in the interface? Won't this result a lot of other problems like
inconsistency, concurrency and etc?
"wrytat" wrote:
> Hi!
> My company implemented an in-house computer system that links up the work of
> all major departments 10 years ago, using Paradox. Currently, we are still
> using Paradox 10, and we are thinking of migrating to MS SQL 2000 server.
> Is there any way to export the Paradox tables to the MS SQL 2000 server,
> while continue using the ObjectPAL codings that we have already developed?
> That is, using ObjectPAL to interact with the MS SQL table, instead of
> Paradox table. Is there such a way? Otherwise, if we re-do all the codings in
> Visual Basic, or other languages, it would be tedious. Or is there any way to
> convert the ObjectPAL codings to other languages that support MS SQL?
> Please advise.
> Thank you.

Paradox, ObjectPAL, MS SQL 2000

Hi!
My company implemented an in-house computer system that links up the work of
all major departments 10 years ago, using Paradox. Currently, we are still
using Paradox 10, and we are thinking of migrating to MS SQL 2000 server.
Is there any way to export the Paradox tables to the MS SQL 2000 server,
while continue using the ObjectPAL codings that we have already developed?
That is, using ObjectPAL to interact with the MS SQL table, instead of
Paradox table. Is there such a way? Otherwise, if we re-do all the codings i
n
Visual Basic, or other languages, it would be tedious. Or is there any way t
o
convert the ObjectPAL codings to other languages that support MS SQL?
Please advise.
Thank you.I've found out the way to connect to the MS SQL 2000 server using Paradox. I
just define a new alias first, and connect to it and perform a executeSQL
statement, which can allow me to interact with the tables in the SQL 2000
server. But there's an issue, would it then not be storing real-time
information in the server unless the user press a Save button, or something
like that in the interface? Won't this result a lot of other problems like
inconsistency, concurrency and etc?
"wrytat" wrote:

> Hi!
> My company implemented an in-house computer system that links up the work
of
> all major departments 10 years ago, using Paradox. Currently, we are still
> using Paradox 10, and we are thinking of migrating to MS SQL 2000 server.
> Is there any way to export the Paradox tables to the MS SQL 2000 server,
> while continue using the ObjectPAL codings that we have already developed?
> That is, using ObjectPAL to interact with the MS SQL table, instead of
> Paradox table. Is there such a way? Otherwise, if we re-do all the codings
in
> Visual Basic, or other languages, it would be tedious. Or is there any way
to
> convert the ObjectPAL codings to other languages that support MS SQL?
> Please advise.
> Thank you.

pageiolatch_sh

Hi,
Our company has an average of 800 processes at any time and goes to 1000 at
peak time (found from sysprocess). Almost 25% of these processes have
waittype as pageiolatch_sh at any given point of time. Does that mean that
we have an IO bottleneck because of the query waiting for the data to be
retreived from the page.
Thanks.
Navin
Hello Navin,
Try http://support.microsoft.com/?id=271509 for an explanation of how to use
DBCC SQLPERF(WAITSTATS) instead to determine which wait type is most common.
Also look at "Opening Microsoft's Performance-Tuning Toolbox"
(http://www.winnetmag.com/Article/Art...925/40925.html) which contains
an exhaustive document
(http://www.winnetmag.com/Files/09/40925/Webtable_01.doc) describing wait
types, perfmon counters and their inter-connection.
HTH,
Arvind.
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-
This posting is provided "AS IS" with no warranties, and confers no rights.
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-
"Navin Vishnu" <navinittiyamparampadh@.comcast.net> wrote in message
news:OktwHfedEHA.228@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Our company has an average of 800 processes at any time and goes to 1000
> at
> peak time (found from sysprocess). Almost 25% of these processes have
> waittype as pageiolatch_sh at any given point of time. Does that mean that
> we have an IO bottleneck because of the query waiting for the data to be
> retreived from the page.
> Thanks.
> Navin
>
|||You may or may not have an IOP bottleneck. That wait is a wait on a disk to
memory buffer transfer. You might be having IO problems or memory pressure
or both. The problems might be from inadequate hardware or bad queries, for
example perhaps you're doing a table scan on a massive table becuase you're
missing an index. The articles referenced in the post by Arvind will be very
helpful...
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Navin Vishnu" <navinittiyamparampadh@.comcast.net> wrote in message
news:OktwHfedEHA.228@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Our company has an average of 800 processes at any time and goes to 1000
at
> peak time (found from sysprocess). Almost 25% of these processes have
> waittype as pageiolatch_sh at any given point of time. Does that mean that
> we have an IO bottleneck because of the query waiting for the data to be
> retreived from the page.
> Thanks.
> Navin
>

pageiolatch_sh

Hi,
Our company has an average of 800 processes at any time and goes to 1000 at
peak time (found from sysprocess). Almost 25% of these processes have
waittype as pageiolatch_sh at any given point of time. Does that mean that
we have an IO bottleneck because of the query waiting for the data to be
retreived from the page.
Thanks.
NavinHello Navin,
Try http://support.microsoft.com/?id=271509 for an explanation of how to use
DBCC SQLPERF(WAITSTATS) instead to determine which wait type is most common.
Also look at "Opening Microsoft's Performance-Tuning Toolbox"
(http://www.winnetmag.com/Article/ArticleID/40925/40925.html) which contains
an exhaustive document
(http://www.winnetmag.com/Files/09/40925/Webtable_01.doc) describing wait
types, perfmon counters and their inter-connection.
HTH,
Arvind.
--
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-
This posting is provided "AS IS" with no warranties, and confers no rights.
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-
"Navin Vishnu" <navinittiyamparampadh@.comcast.net> wrote in message
news:OktwHfedEHA.228@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Our company has an average of 800 processes at any time and goes to 1000
> at
> peak time (found from sysprocess). Almost 25% of these processes have
> waittype as pageiolatch_sh at any given point of time. Does that mean that
> we have an IO bottleneck because of the query waiting for the data to be
> retreived from the page.
> Thanks.
> Navin
>|||You may or may not have an IOP bottleneck. That wait is a wait on a disk to
memory buffer transfer. You might be having IO problems or memory pressure
or both. The problems might be from inadequate hardware or bad queries, for
example perhaps you're doing a table scan on a massive table becuase you're
missing an index. The articles referenced in the post by Arvind will be very
helpful...
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Navin Vishnu" <navinittiyamparampadh@.comcast.net> wrote in message
news:OktwHfedEHA.228@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Our company has an average of 800 processes at any time and goes to 1000
at
> peak time (found from sysprocess). Almost 25% of these processes have
> waittype as pageiolatch_sh at any given point of time. Does that mean that
> we have an IO bottleneck because of the query waiting for the data to be
> retreived from the page.
> Thanks.
> Navin
>

pageiolatch_sh

Hi,
Our company has an average of 800 processes at any time and goes to 1000 at
peak time (found from sysprocess). Almost 25% of these processes have
waittype as pageiolatch_sh at any given point of time. Does that mean that
we have an IO bottleneck because of the query waiting for the data to be
retreived from the page.
Thanks.
NavinHello Navin,
Try http://support.microsoft.com/?id=271509 for an explanation of how to use
DBCC SQLPERF(WAITSTATS) instead to determine which wait type is most common.
Also look at "Opening Microsoft's Performance-Tuning Toolbox"
(http://www.winnetmag.com/Article/Ar...0925/40925.html) which contains
an exhaustive document
(http://www.winnetmag.com/Files/09/40925/Webtable_01.doc) describing wait
types, perfmon counters and their inter-connection.
HTH,
Arvind.
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-
This posting is provided "AS IS" with no warranties, and confers no rights.
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-
"Navin Vishnu" <navinittiyamparampadh@.comcast.net> wrote in message
news:OktwHfedEHA.228@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Our company has an average of 800 processes at any time and goes to 1000
> at
> peak time (found from sysprocess). Almost 25% of these processes have
> waittype as pageiolatch_sh at any given point of time. Does that mean that
> we have an IO bottleneck because of the query waiting for the data to be
> retreived from the page.
> Thanks.
> Navin
>|||You may or may not have an IOP bottleneck. That wait is a wait on a disk to
memory buffer transfer. You might be having IO problems or memory pressure
or both. The problems might be from inadequate hardware or bad queries, for
example perhaps you're doing a table scan on a massive table becuase you're
missing an index. The articles referenced in the post by Arvind will be very
helpful...
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Navin Vishnu" <navinittiyamparampadh@.comcast.net> wrote in message
news:OktwHfedEHA.228@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Our company has an average of 800 processes at any time and goes to 1000
at
> peak time (found from sysprocess). Almost 25% of these processes have
> waittype as pageiolatch_sh at any given point of time. Does that mean that
> we have an IO bottleneck because of the query waiting for the data to be
> retreived from the page.
> Thanks.
> Navin
>