Multi-Select Value dropdown "Select All" Problem

Hi,
I hava report (RDL) which is having a parameter called Plan Owner, i
want the facality of "Select All" in the dropdown, this i can achive
through setting the parameter as Multi-Value. But the problem is if the
user select "select all" from dropdown, i uses the IN claues, i want to
avoid the use of IN clause if the "select all" is selected in
Multi-value dropdown. How can i programatically write the dataset to
avoid "select all"?
What is the internal value of "select all" which it added automatically
in the multi-value parameter dropdown.
I can provide more info if needed.
Regards,
SumitThis is my interpretation of the multivalue parameter.
The internal representation of a multivalue parameters is an array of
all the possible values for the parameter. So if your parameter has 3
values (A,B,C) if you do 'Select All', RS sees an array with values
(A,B,C)
The only way I know of to determine if someone has picked 'Select All'
is to test the array against the # of rows in the dataset populating
the parameters. It would look something like this:
=iif(Parameters!MultiValParam.Count = Count("datasetformvparam"), "",
"FIELD IN (" & join(Parameters!MultiValParam.Value, ", ") & ")")
Andy Potter|||Hi,
I tried the above solution but the count of my dataset always returns 0
even though there are records in there. Any suggestions?
=iif(Parameters!bus_group.Count = Count("business_group"),
"ALL",Join(Parameters!bus_group.Label, ", ") )
Thanks,
Melissa|||I ran into a similar problem in wanting to know if they had selected all
possible options. See the following for a further discussion, a feature
suggestion, and a workaround:
http://lab.msdn.microsoft.com/ProductFeedback/viewfeedback.aspx?feedbackid=dfec87e1-a34d-4ff8-a480-fb1f8d4160ea
"Melissa" wrote:
> Hi,
> I tried the above solution but the count of my dataset always returns 0
> even though there are records in there. Any suggestions?
> =iif(Parameters!bus_group.Count = Count("business_group"),
> "ALL",Join(Parameters!bus_group.Label, ", ") )
> Thanks,
> Melissa
>

Multiple SQL Clusters on one EMC LUN?

Hello,
We have a Production SQL 2000 Cluster and are now developing on SQL 2K5 as
we plan to migrate shortly. We'll be introducing new hardware into
production with 2K5 installed. We would like to use a 'straddle migration'
method by utilizing both 2K and 2K5 in production at the same time and
moving services/websites/databases to 2K5 one at a time in case there are
any issues and we need to roll back over to 2K.
The question is how can we utilize the current LUNs/Cluster that's on the
EMC for the new 2K5 servers/cluster? Can we have a 2K and 2K5 cluster using
the same LUN? How would the Q: Quarum drive work? What possible
complications do see in this scenario?
Thank you in advance for your time,
Andew
If you do side by side, then you cannot use the same virtual server name,
instance name, IP address, or network port. Moreover, you will have to have
an independent dedicated disk(s) for the installation to even succeed.
Afterwards, however, you can use either detach/attach or database backups
and restores to migrate from one instance the next. If a rollback is called
for, you only have to point the connections back to the SS2K instance and
you're off and running again.
If your upgrade is successful, then you just uninstall the SS2K instance and
give storage back their original LUN for reuse.
What we typically do is restore pending the prior day's full database
backup, and then kick off a differential right before the migration. This
keeps the backup, transfer, restore window small during the migration
outage.
Sincerely,
Anthony Thomas

"Andrew Williams" <andrew.williams@.freedompay.com> wrote in message
news:99A9028F-DB5C-4E5F-9320-8BCA23F0C2B7@.microsoft.com...
> Hello,
> We have a Production SQL 2000 Cluster and are now developing on SQL 2K5 as
> we plan to migrate shortly. We'll be introducing new hardware into
> production with 2K5 installed. We would like to use a 'straddle
migration'
> method by utilizing both 2K and 2K5 in production at the same time and
> moving services/websites/databases to 2K5 one at a time in case there are
> any issues and we need to roll back over to 2K.
> The question is how can we utilize the current LUNs/Cluster that's on the
> EMC for the new 2K5 servers/cluster? Can we have a 2K and 2K5 cluster
using
> the same LUN? How would the Q: Quarum drive work? What possible
> complications do see in this scenario?
> Thank you in advance for your time,
>
> Andew
>
|||> Can we have a 2K and 2K5 cluster using
> the same LUN?
(assuming with LUN you mean physical disk resource in the cluster)
No, they need to be in there own dedicated cluster group with dedicated
physical disk resources

> How would the Q: Quarum drive work?
Quorum disk should be, together with cluster IP and cluster name and
possibly MSDTC, in it own cluster group, this is the *default* setup. No
changes for the Quorum disk
So you end up with:
cluster group - cluster resources (including Quorum disk)
group1 - SQL2K (with its own dedicated disks, IP, network name)
group2 - SQL2K5 (with its own dedicated disks, IP, network name)
does this answer your question ?
rgds,
edwin.

Multiple rows into one row

Hello I am wondering if this is possible.

I have a two tables one contains Plan information and another that
contains product information about the plan

ex:
Plan table
PlanID Plan_name
1 a
2 b

Product Table
ProductID PlanID Comments
1 1 com1
2 1 com2
3 1 com3

What I am looking to do if possible would be the following

Plan Product1 Comments1 Product2 Comments2
1 1 com1 2 com2

I am wondering down what path I should explore cause I am new to this.
I am using sql 2005Chicagoboy27 wrote:

Quote:

Originally Posted by

Hello I am wondering if this is possible.
>
I have a two tables one contains Plan information and another that
contains product information about the plan
>
ex:
Plan table
PlanID Plan_name
1 a
2 b
>
Product Table
ProductID PlanID Comments
1 1 com1
2 1 com2
3 1 com3
>
What I am looking to do if possible would be the following
>
Plan Product1 Comments1 Product2 Comments2
1 1 com1 2 com2
>
>
I am wondering down what path I should explore cause I am new to this.
I am using sql 2005

Take a look at PIVOT in Books Online. Also Itzik Ben-Gan has articles
on PIVOT in the last two issues of SQL Server Magazine. www.sqlmag.com
--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/...US,SQL.90).aspx
--|||Thanks I will explore that option...

David Portas wrote:

Quote:

Originally Posted by

Chicagoboy27 wrote:

Quote:

Originally Posted by

Hello I am wondering if this is possible.

I have a two tables one contains Plan information and another that
contains product information about the plan

ex:
Plan table
PlanID Plan_name
1 a
2 b

Product Table
ProductID PlanID Comments
1 1 com1
2 1 com2
3 1 com3

What I am looking to do if possible would be the following

Plan Product1 Comments1 Product2 Comments2
1 1 com1 2 com2

I am wondering down what path I should explore cause I am new to this.
I am using sql 2005

>
Take a look at PIVOT in Books Online. Also Itzik Ben-Gan has articles
on PIVOT in the last two issues of SQL Server Magazine. www.sqlmag.com
>
--
David Portas, SQL Server MVP
>
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
>
SQL Server Books Online:
http://msdn2.microsoft.com/library/...US,SQL.90).aspx
--