Manage parameter dropdown list

I have an input parameter which has multi-value property checked. It has
dependence on the other input parameter and its value set is getting from
database. So, the number of row change when the other parameter changes. The
problem is the dropdown list sometime works fine, but the other time it
doesn't work as expected. For instance, there is case that there are only
two values in the list and the dropdown list gives me "Select All", first
item and a scroll bar. I need to drag the scroll bar to see the second item.
This is very annoying. The only good thing is that it did work consistently
in the sense of same value set always has same look in the dropdown list.
Is there a way to manage the displayable size of the dropdown list? How
about the input parameter text box length, is there anyway we can have any
control over this?Hi,
As you have mentioned that the "select ALL" comes as the first option and
you need to scroll down for the other two options. I think your query (in the
dataset) for this parameter is having spaces. Just have a look at the query
again and try to eliminate the null / space in your dataset.
Amarnath
"lu" wrote:
> I have an input parameter which has multi-value property checked. It has
> dependence on the other input parameter and its value set is getting from
> database. So, the number of row change when the other parameter changes. The
> problem is the dropdown list sometime works fine, but the other time it
> doesn't work as expected. For instance, there is case that there are only
> two values in the list and the dropdown list gives me "Select All", first
> item and a scroll bar. I need to drag the scroll bar to see the second item.
> This is very annoying. The only good thing is that it did work consistently
> in the sense of same value set always has same look in the dropdown list.
> Is there a way to manage the displayable size of the dropdown list? How
> about the input parameter text box length, is there anyway we can have any
> control over this?
>|||Sorry, if I didn't make it clear. No, what I said was the dropdown list
display first two items which are "Select All" and the first item in the
value set when I have only two items in the value set. Why I need to use
scroll bar to be able to see the second item. The dropdown list should just
have a window big enough to accomodate all three choice which are "Select
All", first item and second item.
"Amarnath" wrote:
> Hi,
> As you have mentioned that the "select ALL" comes as the first option and
> you need to scroll down for the other two options. I think your query (in the
> dataset) for this parameter is having spaces. Just have a look at the query
> again and try to eliminate the null / space in your dataset.
> Amarnath
> "lu" wrote:
> > I have an input parameter which has multi-value property checked. It has
> > dependence on the other input parameter and its value set is getting from
> > database. So, the number of row change when the other parameter changes. The
> > problem is the dropdown list sometime works fine, but the other time it
> > doesn't work as expected. For instance, there is case that there are only
> > two values in the list and the dropdown list gives me "Select All", first
> > item and a scroll bar. I need to drag the scroll bar to see the second item.
> > This is very annoying. The only good thing is that it did work consistently
> > in the sense of same value set always has same look in the dropdown list.
> > Is there a way to manage the displayable size of the dropdown list? How
> > about the input parameter text box length, is there anyway we can have any
> > control over this?
> >
> >sql

Making the year field 2007 to a 07 instead?

Hi

In my matrix cell I have a cell with the following Expression:

=Fields!monthname.Value & " " & Fields!Year.Value

In one of my datasets I have a SELECT CAST(FCYB.cyb_yearname AS int) AS 'Year' ... amongst other things.

Now, how do I make 'Year' to say 07 instead of 2007? What is the proper way to do it? In the expression or in the SQL code?

Thanks in advanced as always

KR

Use Right(fields!Year.Value,2)|||

Thanks a lot!! Worked perfectly!!

making JOINS

Hi alll
I have these tables below with 3 fields each. I want to get the record
in table 1 whose field number value is same in table 2 but field number
2 on both tables are different. I mean i want the record
1500 800 2. Insight: Table 1 is modules ordered and table 2 is modules
delivered. I want to get 1500 800 2.beacuse module 800 was ordered but
in table 2 module 503 was delivered. can some one help me with a join

nice weekeend

Table 1

10 5012 10
1600502
100 502 3
1500800 2

Table 2

1500503 1
14004000
100502 10
100600
100502 3MORALBAROMETER wrote:

Quote:

Originally Posted by

Hi alll
I have these tables below with 3 fields each. I want to get the record
in table 1 whose field number value is same in table 2 but field number
2 on both tables are different. I mean i want the record
1500 800 2. Insight: Table 1 is modules ordered and table 2 is modules
delivered. I want to get 1500 800 2.beacuse module 800 was ordered but
in table 2 module 503 was delivered. can some one help me with a join
>
nice weekeend
>
Table 1
>
10 5012 10
1600502
100 502 3
1500800 2
>
>
>
>
Table 2
>
1500503 1
14004000
100502 10
100600
100502 3
>

Write a statement where:
field1 = field1
and
field2 <field2
--
Daniel A. Morgan
University of Washington
damorgan@.x.washington.edu
(replace x with u to respond)|||Hi Daniel,
thanks alot for the prompt reply. this is what i had:

100 502
100 502
1500 800

as seen in the table 100 502was ordered and shipped but more articles
were shipped not ordered by customerID(100). I do not need this
information. I need a list where a customer ordered and received
shippment where no product ordered was shipped. in this case
customer(1500) should be the right answer. He ordered and recived
shippement but within the list no article oredered was shiped. but
customer (100) received the ordered product plus some extra
Hope to read from u and any one else

DA Morgan wrote:

Quote:

Originally Posted by

MORALBAROMETER wrote:

Quote:

Originally Posted by

Hi alll
I have these tables below with 3 fields each. I want to get the record
in table 1 whose field number value is same in table 2 but field number
2 on both tables are different. I mean i want the record
1500 800 2. Insight: Table 1 is modules ordered and table 2 is modules
delivered. I want to get 1500 800 2.beacuse module 800 was ordered but
in table 2 module 503 was delivered. can some one help me with a join

nice weekeend

Table 1

10 5012 10
1600502
100 502 3
1500800 2

Table 2

1500503 1
14004000
100502 10
100600
100502 3

>
Write a statement where:
field1 = field1
and
field2 <field2
--
Daniel A. Morgan
University of Washington
damorgan@.x.washington.edu
(replace x with u to respond)

|||On 23 Oct 2006 00:52:26 -0700, MORALBAROMETER wrote:

Quote:

Originally Posted by

>Hi Daniel,
>thanks alot for the prompt reply. this is what i had:
>
>100 502
>100 502
>1500 800
>
>as seen in the table 100 502was ordered and shipped but more articles
>were shipped not ordered by customerID(100). I do not need this
>information. I need a list where a customer ordered and received
>shippment where no product ordered was shipped. in this case
>customer(1500) should be the right answer. He ordered and recived
>shippement but within the list no article oredered was shiped. but
>customer (100) received the ordered product plus some extra
>Hope to read from u and any one else

Hi MORALBAROMETER,

Maybe something like this?

SELECT o.CustomerID, o.ArticleID
FROM Orders AS o
LEFT JOIN Shipments AS s
ON s.CustomerID = o.CustomerID
AND s.ArticleID = o.ArticleID
WHERE s.CustomerID IS NULL

or the following (logically equivalent, but easier to understand for
beginning SQL coders):

SELECT o.CustomerID, o.ArticleID
FROM Orders AS o
WHERE NOT EXISTS
(SELECT *
FROM Shipments AS s
WHERE s.CustomerID = o.CustomerID
AND s.ArticleID = o.ArticleID)

If these are not what you're after, then I recommend that you post your
table structure (as CREATE TABLE statements, including constraints,
properties and indexes), some rows of sample data (as INSERT statements)
and expected results. See www.aspfaq.com/5006 for more info.

--
Hugo Kornelis, SQL Server MVP

Making a view

My brain is locking up again. I would like to make a view with the
Tech_ID and the most recent, non-null value of
TechWOProduct_WorksheetNumber. Thanks for any help -John
CREATE TABLE [tblTech] (
[Tech_ID] [int] IDENTITY (1, 1) NOT NULL ,
[Tech_EID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL
)
CREATE TABLE [tblWO] (
[WO_ID] [int] IDENTITY (1, 1) NOT NULL ,
[WO_Date] [datetime] NULL
)
CREATE TABLE [tblTechWO] (
[TechWO_ID] [int] IDENTITY (1, 1) NOT NULL ,
[WO_ID] [int] NOT NULL ,
[Tech_ID] [int] NOT NULL
)
CREATE TABLE [tblTechWOProduct] (
[TechWOProduct_ID] [int] IDENTITY (1, 1) NOT NULL ,
[TechWO_ID] [int] NOT NULL ,
[TechWOProduct_Date] [datetime] NOT NULL ,
[TechWOProduct_WorksheetNumber] [int] NULL
)Hi, John
Besides DDL, it would have been useful if you would have provided
sample data and expected results. See:
http://www.aspfaq.com/etiquette.asp?id=5006
Your DDL is incomplete: it has no primary keys, no foreign keys and no
unique keys. If the DDL would have been complete we would know if it's
possible to have two rows in the tblTechWOProduct table with the same
TechWO_ID and TechWOProduct_Date. Because the DDL is incomplete, i must
ask you: is the above situation possible?
Anyway, assuming that the answer to the previous question is "no" (you
should create a unique constraint to ensure this), try the following
(not tested):
CREATE VIEW FirstView
AS
SELECT t.Tech_ID, p.TechWOProduct_Date, p.TechWOProduct_WorksheetNumber
FROM tblTechWO t INNER JOIN tblTechWOProduct p ON
t.TechWO_ID=p.TechWO_ID
WHERE TechWOProduct_WorksheetNumber IS NOT NULL
GO
CREATE VIEW YourView
AS
SELECT v.* FROM FirstView v
INNER JOIN (
SELECT Tech_ID, MAX(TechWOProduct_Date) AS MaxDate
FROM FirstView GROUP BY Tech_ID
) x ON v.Tech_ID=x.Tech_ID AND v.TechWOProduct_Date=x.MaxDate
Razvan

Making a row not show

I have one column that is an expression that either returns a value or
returns zero. I would like if it is zero to not show at all. How is this
done?
Thanks,
RyanGo to properties for that column, click on Visibility tab. Click on
Expression radio button and enter this formula:
=iif (Fields!<expression>.Value = 0, True, False)
you may have to map the expression to a data set row before this will work.
I have made it work with parameter and field values.
"Ryan Mcbee" wrote:
> I have one column that is an expression that either returns a value or
> returns zero. I would like if it is zero to not show at all. How is this
> done?
> Thanks,
> Ryan|||Carl,
I tried this and it didn't work. I think because I am using a matrix
report. Would have to put this formula in every column since it is a matrix
report?
Thanks,
Ryan
"Carl Henthorn" wrote:
> Go to properties for that column, click on Visibility tab. Click on
> Expression radio button and enter this formula:
> =iif (Fields!<expression>.Value = 0, True, False)
> you may have to map the expression to a data set row before this will work.
> I have made it work with parameter and field values.
> "Ryan Mcbee" wrote:
> > I have one column that is an expression that either returns a value or
> > returns zero. I would like if it is zero to not show at all. How is this
> > done?
> >
> > Thanks,
> > Ryan

Make textbox value dependent on result of a dataset

I need to make a textbox1 say "Pass" or "Fail" depending on the value in
another textbox2. Textbox2 has an expression assigned to it:
=Sum(Fields!TotAgents.Value, "NumAgts") which returns a 0 or greater number.
I am struggling with the syntax of linking the textbox1 text to the result of
textbox2's evaluation. In otherwords, if textbox2 evaluates to 0, then
textbox1 should say "Pass".
Thank you.Try this:
Right click on textbox1 and choose expressions.
Type: IIF(Fields!TotAgents.Value = 0, "Pass", "Fail")
This should give you the word "Pass" if the value in textbox2 is = 0
and the word "Fail" if the condition is not met. Hopes this helps!

make Count(*) return zero

hey guys

is there a way to make the count(*) return zero . because the default behavoir is that it will skip this value if there is no records
so a simple query like this

select userid,count(*) as count from users where userid in (select val from sometable)
group by userid

if userid 1 has no records . it wont be returned in the query
instead i want it to show zero
so
userid count
1 0
2 3
3 1
4 0

thanks in advance
hi

you can try this

select userid,count(*) as [count] from testDB where
userid in (select userid from testdb1)
group by userid
union
select userid,0 as [count] from testDB where
userid not in (select userid from testdb1)
group by userid

|||

How about this query..

Select

Val

,Count(UserId)

from

someTable A

Left Outer Join users B On A.val=B.userid

Group By

Val

|||you can also try this one..

Code Snippet

select *
into #users
from (
select 1 as userid union all
select 2 as userid union all
select 3 as userid
) users

select *
into #sometable
from (
select 1 as val
) sometable

select a.userid
, case when count(a.userid) = 1 and sum(b.sumcheck) = 0 then 0 else count(a.userid) end as count
from #users a left outer join
(
select userid
, isnull(val,0) as sumcheck
from #users left outer join
#sometable on #users.userid = #sometable.val
) b on a.userid = b.userid
group by
a.userid

drop table #users
drop table #sometable

|||

RamezR,

Those rows like [userid] = 1, are being excluded from the result set because of the filter in the "where" clause. The is a keyword in the "group by" clause (ALL), that let you see those rows excluded by the filter in the "where" clause.

select userid,count(*) as count

from users

where userid in (select val from sometable)

group by userid ALL

go

AMB

|||when i try to run the query i get Incorrect syntax near the keyword 'ALL'.

i was not aware of this "ALL" keyword but when i looked up the msdn i found that its kinda irrelvant in that case.

so far i found that the best result is achieved using the left outer join

Regards

|||deleted my previous post.. i think what hunchback meant was..

select userid,count(*) as count

from users

where userid in (select val from sometable)

group by all userid|||

rh4m1113,

Thanks for jumping in. That is exactly what I meant, but did not test it.

AMB

|||hunchback,

actually i was also confused and thought only SQL 2005 had the GROUP BY ALL clause .. good thing i tested it.. i have actually learned from this one.. cool post hunchback..

rhamille|||

rh4m1ll3,

Glad you learned something from the post. The "left join" idea is a good one, but you have to be sure that the rows in the right side table has no duplicated rows by the columns used in the join, or you select distinct values from that table previous the join, if not you will get wrong result.

AMB

|||hunchback,

true, so far on some production codes that i have used a similar approach none of them had a requirement of having duplicate records, i'd prole' be taking note of your approach just in case a similar requirement comes. it's much more cleaner and straight forward as well as maximizes the the group by clauses's potential

rhamille|||

Hi hunchback & rh4m1ll3,

Let me understand your solution, (i accept the feature GROUP BY ALL in sql server ).

But I am really confused to accept GROUP BY ALL for this requirement.

See the bellow example, are you sure GROUP BY ALL will work for this requirement?

Code Snippet

Create Table #sometable (

[val] int

);

Insert Into #sometable Values('2');

Insert Into #sometable Values('2');

Insert Into #sometable Values('2');

Insert Into #sometable Values('3');

Insert Into #sometable Values('3');

Insert Into #sometable Values('5');

Insert Into #sometable Values('5');

Create Table #users (

[UserId] int

);

Insert Into #users Values('1');

Insert Into #users Values('2');

Insert Into #users Values('3');

Insert Into #users Values('4');

Insert Into #users Values('5');

Insert Into #users Values('6');

Select

UserId

,Count(Val) Counts

from

#users B

Left Outer Join #sometable A On A.val=B.userid

Group By

UserId

/*

UserId Counts

-- --

1 0

2 3

3 2

4 0

5 2

6 0

*/

Select

UserId

,Count(*) Counts

from

#users B

Where

UserId in (Select val From #sometable)

Group By ALL

UserId

/*

UserId Counts

-- --

1 0

2 1

3 1

4 0

5 1

6 0

*/

|||mani,

good and interesting point .. i have just recently realized that you might have misplaced the Val and UserId on your previous(first) post.. good approach for such requirement

rhamille|||

Manivannan.D.Sekaran,

Look at the original post and execute the stament using the sample data in your post

Select

UserId

,Count(*) Counts

from

#users

where

UserId in (select [val] from #sometable)

Group By

UserId

Result:

UserId Counts
2 1
3 1
5 1

If we want to include also the rows not matching the criteria in the "where" clause, but this time using "left join", then you need to be sure that we join to unique values from #sometable:

Select

u.UserId

,Count(s.[val]) Counts

from

#users as u

left join

(select distinct [val] from #sometable) as s

on u.UserId = s.[val]

Group By

u.UserId

Result

UserId Counts
1 0
2 1
3 1
4 0
5 1
6 0

As you can see, the result from the statement using "left join" and the statement using "GROUP BY ALL", yield same result for the rows returned by the original statement.

AMB

|||Please do NOT use GROUP BY ALL. It is a non-standard extension and will be deprecated in the future. It is marked for deprecation in SQL Serve 2005. So if you use it in your code now you may have to change it in the next version of SQL Server or the version after that.

Make a textbox invisible based on another value

I cannot figure out how to make a textbox or a row in a table visible based
on another boolean variable. I don't want it to be based on the user
toggling or collapsing something - I simply want it to display or hide based
on a field in the dataset. Thanks!Use the ReportItems collection (e.g. =ReportItems!textbox1.Value) to refer
to the value of another textbox.
Note: expressions that refer to report items can only refer to values of
peer report items (those in the same grouping scope) or report items in any
containing (ancestor) grouping scope.
See also:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_expressions_v1_7ilv.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Richard Wrench" <rwrench@.icsecurity.com> wrote in message
news:%23eQA%23DXXEHA.556@.tk2msftngp13.phx.gbl...
> I cannot figure out how to make a textbox or a row in a table visible
based
> on another boolean variable. I don't want it to be based on the user
> toggling or collapsing something - I simply want it to display or hide
based
> on a field in the dataset. Thanks!
>|||Thanks for pointing out the ReportItems collection (that answered another
question) however, I'm still confused about Textbox visibility.
I have a boolean field in the database named OtherCharges. I want a textbox
to display only if this value is true - How can I do this? - To me, there
should be a Visible property, instead, there is a Hidden and ToggleItem
property which are used so that the user can collapse / expand data - a la
Crystal - I don't want to do that.
Regards, Richard
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:eKefMYXXEHA.3012@.tk2msftngp13.phx.gbl...
> Use the ReportItems collection (e.g. =ReportItems!textbox1.Value) to refer
> to the value of another textbox.
> Note: expressions that refer to report items can only refer to values of
> peer report items (those in the same grouping scope) or report items in
any
> containing (ancestor) grouping scope.
> See also:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_expressions_v1_7ilv.asp
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Richard Wrench" <rwrench@.icsecurity.com> wrote in message
> news:%23eQA%23DXXEHA.556@.tk2msftngp13.phx.gbl...
> > I cannot figure out how to make a textbox or a row in a table visible
> based
> > on another boolean variable. I don't want it to be based on the user
> > toggling or collapsing something - I simply want it to display or hide
> based
> > on a field in the dataset. Thanks!
> >
> >
>|||The textbox has a Visibility.Hidden property in the VS properties window
(hit F4 if it is not visible). For the Hidden property you would write this
expression: =(Fields!OtherCharges.Value = False)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Richard Wrench" <rwrench@.icsecurity.com> wrote in message
news:uzMqAJsXEHA.3716@.TK2MSFTNGP11.phx.gbl...
> Thanks for pointing out the ReportItems collection (that answered another
> question) however, I'm still confused about Textbox visibility.
> I have a boolean field in the database named OtherCharges. I want a
textbox
> to display only if this value is true - How can I do this? - To me, there
> should be a Visible property, instead, there is a Hidden and ToggleItem
> property which are used so that the user can collapse / expand data - a la
> Crystal - I don't want to do that.
> Regards, Richard
>
>
>
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:eKefMYXXEHA.3012@.tk2msftngp13.phx.gbl...
> > Use the ReportItems collection (e.g. =ReportItems!textbox1.Value) to
refer
> > to the value of another textbox.
> > Note: expressions that refer to report items can only refer to values of
> > peer report items (those in the same grouping scope) or report items in
> any
> > containing (ancestor) grouping scope.
> > See also:
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_expressions_v1_7ilv.asp
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "Richard Wrench" <rwrench@.icsecurity.com> wrote in message
> > news:%23eQA%23DXXEHA.556@.tk2msftngp13.phx.gbl...
> > > I cannot figure out how to make a textbox or a row in a table visible
> > based
> > > on another boolean variable. I don't want it to be based on the user
> > > toggling or collapsing something - I simply want it to display or hide
> > based
> > > on a field in the dataset. Thanks!
> > >
> > >
> >
> >
>|||Perfect ! Thanks ...
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:OBvdeGtXEHA.2500@.TK2MSFTNGP09.phx.gbl...
> The textbox has a Visibility.Hidden property in the VS properties window
> (hit F4 if it is not visible). For the Hidden property you would write
this
> expression: =(Fields!OtherCharges.Value = False)
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Richard Wrench" <rwrench@.icsecurity.com> wrote in message
> news:uzMqAJsXEHA.3716@.TK2MSFTNGP11.phx.gbl...
> > Thanks for pointing out the ReportItems collection (that answered
another
> > question) however, I'm still confused about Textbox visibility.
> >
> > I have a boolean field in the database named OtherCharges. I want a
> textbox
> > to display only if this value is true - How can I do this? - To me,
there
> > should be a Visible property, instead, there is a Hidden and ToggleItem
> > property which are used so that the user can collapse / expand data - a
la
> > Crystal - I don't want to do that.
> >
> > Regards, Richard
> >
> >
> >
> >
> >
> >
> > "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> > news:eKefMYXXEHA.3012@.tk2msftngp13.phx.gbl...
> > > Use the ReportItems collection (e.g. =ReportItems!textbox1.Value) to
> refer
> > > to the value of another textbox.
> > > Note: expressions that refer to report items can only refer to values
of
> > > peer report items (those in the same grouping scope) or report items
in
> > any
> > > containing (ancestor) grouping scope.
> > > See also:
> > >
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_expressions_v1_7ilv.asp
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > >
> > > "Richard Wrench" <rwrench@.icsecurity.com> wrote in message
> > > news:%23eQA%23DXXEHA.556@.tk2msftngp13.phx.gbl...
> > > > I cannot figure out how to make a textbox or a row in a table
visible
> > > based
> > > > on another boolean variable. I don't want it to be based on the
user
> > > > toggling or collapsing something - I simply want it to display or
hide
> > > based
> > > > on a field in the dataset. Thanks!
> > > >
> > > >
> > >
> > >
> >
> >
>

Make (Select All) as default value in parameter

Dear Anyone,
Does anyone know how to Make (Select All) as default value in parameter selection on a multi-select parameter?

thanks,
Joseph

If the valid values list of the multi value parameter is dataset based, you could set the default value of the parameter to the same dataset field value.

-- Robert

|||

We have the hotfix for the (Select All) option applied (after applying SP1).

However, when the users change another parameter filter which cascades to change to the multivalued parameter filter, the (Select All) option is not reapplied. In other words, if new entries show up in the multivalued parameters list, they are not checked by default, so some records will be missed.

What is the best way to force a (Select All) again after the user filters on another dependent parameter filter?

Make (Select All) as default value in parameter

Dear Anyone,
Does anyone know how to Make (Select All) as default value in parameter selection on a multi-select parameter?

thanks,
Joseph

If the valid values list of the multi value parameter is dataset based, you could set the default value of the parameter to the same dataset field value.

-- Robert

|||

We have the hotfix for the (Select All) option applied (after applying SP1).

However, when the users change another parameter filter which cascades to change to the multivalued parameter filter, the (Select All) option is not reapplied. In other words, if new entries show up in the multivalued parameters list, they are not checked by default, so some records will be missed.

What is the best way to force a (Select All) again after the user filters on another dependent parameter filter?

Make (Select All) as default value in parameter

Dear Anyone,
Does anyone know how to Make (Select All) as default value in parameter selection on a multi-select parameter?

thanks,
Joseph

If the valid values list of the multi value parameter is dataset based, you could set the default value of the parameter to the same dataset field value.

-- Robert

|||

We have the hotfix for the (Select All) option applied (after applying SP1).

However, when the users change another parameter filter which cascades to change to the multivalued parameter filter, the (Select All) option is not reapplied. In other words, if new entries show up in the multivalued parameters list, they are not checked by default, so some records will be missed.

What is the best way to force a (Select All) again after the user filters on another dependent parameter filter?