How Overwrite display text of Multi Select Dropdownlist

Hi.
I would like to overwrite a text which is displayed on a dropdownlist
when all items are selected. (with multi-selection enabled)
By default when all items are selected they are displayed separated by
coma, Instead of all items listed in a dropdown display I would like
to have for example "All Items"
Is it possible?
Thanks,
MaciejIn your dataset (or your proc, depending on how you set it up), you
need two columns. One of which should contain values to pass as
parameters, the other should contain the labels you want to see. Then
you can set up the available values section of the parameter so that
the value field points to your values and the label field points to
your labels. There are a few ways to add the "All" parameter. Here's
the one from Chris Hays' blog: http://blogs.msdn.com/chrishays/archive/2004/07/27/AllParameterValue.aspx
On Jan 22, 12:08 pm, MacChojna...@.googlemail.com wrote:
> Hi.
> I would like to overwrite a text which is displayed on a dropdownlist
> when all items are selected. (with multi-selection enabled)
> By default when all items are selected they are displayed separated by
> coma, Instead of all items listed in a dropdown display I would like
> to have for example "All Items"
> Is it possible?
> Thanks,
> Maciej|||In your dataset (or your proc, depending on how you set it up), you
need two columns. One of which should contain values to pass as
parameters, the other should contain the labels you want to see. Then
you can set up the available values section of the parameter so that
the value field points to your values and the label field points to
your labels. There are a few ways to add the "All" parameter. Here's
the one from Chris Hays' blog:
http://blogs.msdn.com/chrishays/archive/2004/07/27/AllParameterValue.aspx
Bear in mind, though - if you're using multi-select you're always
going to have the option given to select all from the multi-select as
opposed to your version of 'all' which exists as a single selection on
the list. I'm not sure you can suppress that, either.
Adam
On Jan 22, 12:08 pm, MacChojna...@.googlemail.com wrote:
> Hi.
> I would like to overwrite a text which is displayed on a dropdownlist
> when all items are selected. (with multi-selection enabled)
> By default when all items are selected they are displayed separated by
> coma, Instead of all items listed in a dropdown display I would like
> to have for example "All Items"
> Is it possible?
> Thanks,
> Maciej|||Thanks, Adam but this is not exactly what I'm looking for.
I want to have some text which overwrite text displayed in dropdown.
Lets say that we have 10 Items in dropdown,
Item1 and Item2 are selected dropdown so it displays Item1,Item2
when I select also Item5 dropdown displays Item1,Item2,Item5.
Thing is that I don't want to see this text in dropdown. I want to
have in that place something different:
Instead of "Item1,Item2,Item5" - "Text"
Thanks,
Maciej
On 22 Sty, 19:47, Adam Schmitt <adam.schm...@.gmail.com> wrote:
> In your dataset (or your proc, depending on how you set it up), you
> need two columns. One of which should contain values to pass as
> parameters, the other should contain the labels you want to see. Then
> you can set up the available values section of the parameter so that
> the value field points to your values and the label field points to
> your labels. There are a few ways to add the "All" parameter. Here's
> the one from Chris Hays' blog:http://blogs.msdn.com/chrishays/archive/2004=
/07/27/AllParameterValue...
> Bear in mind, though - if you're using multi-select you're always
> going to have the option given to select all from the multi-select as
> opposed to your version of 'all' which exists as a single selection on
> the list. I'm not sure you can suppress that, either.
> Adam
> On Jan 22, 12:08 pm, MacChojna...@.googlemail.com wrote:
>
> > Hi.
> > I would like tooverwriteatextwhich is displayed on adropdownlist
> > when all items are selected. (with multi-selection enabled)
> > By default when all items are selected they are displayed separated by
> > coma, Instead of all items listed in a dropdown display I would like
> > to have for example "All Items"
> > Is it possible?
> > Thanks,
> > Maciej- Ukryj cytowany tekst -
> - Poka=BF cytowany tekst -|||Regardless of what SSRS is capable of, what you're trying to do can
only be done theoretically if you have a replacement value for every
possible combination of available values. That said, if you didn't
have a terribly large set of available values, you could always create
a single select parameter and populate it with all of those possible
combinations, separated by commas, as values. That way you could
associate the appropriate text with those values in another field on
the database side and use that second field as your text. Other than
that, though, I'm not so sure you could replace that text short of
hiding the parameter and having the user ignore it completely (not
terribly useful if they need to be able to select values from it).
Good luck.
Adam
On Feb 26, 2:48 am, MacChojna...@.googlemail.com wrote:
> Thanks, Adam but this is not exactly what I'm looking for.
> I want to have some text which overwrite text displayed in dropdown.
> Lets say that we have 10 Items in dropdown,
> Item1 and Item2 are selected dropdown so it displays Item1,Item2
> when I select also Item5 dropdown displays Item1,Item2,Item5.
> Thing is that I don't want to see this text in dropdown. I want to
> have in that place something different:
> Instead of "Item1,Item2,Item5" - "Text"
> Thanks,
> Maciej
> On 22 Sty, 19:47, Adam Schmitt <adam.schm...@.gmail.com> wrote:
> > In your dataset (or your proc, depending on how you set it up), you
> > need two columns. One of which should contain values to pass as
> > parameters, the other should contain the labels you want to see. Then
> > you can set up the available values section of the parameter so that
> > the value field points to your values and the label field points to
> > your labels. There are a few ways to add the "All" parameter. Here's
> > the one from Chris Hays' blog:http://blogs.msdn.com/chrishays/archive/20=
04/07/27/AllParameterValue...
> > Bear in mind, though - if you're using multi-select you're always
> > going to have the option given to select all from the multi-select as
> > opposed to your version of 'all' which exists as a single selection on
> > the list. I'm not sure you can suppress that, either.
> > Adam
> > On Jan 22, 12:08 pm, MacChojna...@.googlemail.com wrote:
> > > Hi.
> > > I would like tooverwriteatextwhich is displayed on adropdownlist
> > > when all items are selected. (with multi-selection enabled)
> > > By default when all items are selected they are displayed separated by=
> > > coma, Instead of all items listed in a dropdown display I would like
> > > to have for example "All Items"
> > > Is it possible?
> > > Thanks,
> > > Maciej- Ukryj cytowany tekst -
> > - Poka=BF cytowany tekst -

How long does it take to startup SQL Service with AWE enabled

Hi,
We have a fail-over cluster with a SQL Server 2000 instance installed on it.
There are 6GB memory available on the cluster, and we have the /PAE switch
turned on. I want to enable AWE in SQL Server and allocate 3-4GB to SQL
server. but from what I read about turn on AWE, some paper warned that the
startup process of SQL service will take a lot longer. Does anybody have
experience about how long it takes to startup SQL in a cluster with AWE
enabled with 3GB memory allocated? And if we experience a timeout error
before SQL Service started, what can we do?
Thanks
Hong Wang
Yes, the failover process will take longer with AWE enabled. The reason is
that the AWE memory must be "zeroed out." This takes extra time. However,
we have found that the Recovery Interval controls most of the failover
timing and that managing the Shared Volumes consumes more time than the AWE
clearing.
With 8 GB RAM, Windows 2000, SQL Server max server memory set to 6.5 GB, a
typical failover for a busy system could take 3 to 5 minutes. The recovery
process could take up to 15 minutes or so on a busy system once services
were restored on the new node.
There is also a KB article that discusses application processes "awareness"
of clustered instances. Basically, the application must use retry logic for
detected database connectivity errors, which can be trapped. However, this
would be good practice even if the database was hosted on a stand-alone
system.
Sincerely,
Anthony Thomas

"Hong Wang" <HongWang@.discussions.microsoft.com> wrote in message
news:4CBDA708-88EF-49F6-A55C-70C3F90F5F1A@.microsoft.com...
> Hi,
> We have a fail-over cluster with a SQL Server 2000 instance installed on
it.
> There are 6GB memory available on the cluster, and we have the /PAE switch
> turned on. I want to enable AWE in SQL Server and allocate 3-4GB to SQL
> server. but from what I read about turn on AWE, some paper warned that the
> startup process of SQL service will take a lot longer. Does anybody have
> experience about how long it takes to startup SQL in a cluster with AWE
> enabled with 3GB memory allocated? And if we experience a timeout error
> before SQL Service started, what can we do?
> Thanks
> Hong Wang

how link executionid of sysdtslog90

I have enabled logging using database.

When I try to query the sysdtslog90 table using System::ExecutionInstanceGUID to link executionid - it is not matching.

Any resolution?

Thanks

The variable System::ExecutionInstanceGUID always matches the sysdtslog90.executionid column when I try it.

Are the times matching up? Are you looking in the right table? Try using a Script Task to fire an event with the ExecutionInstanceGUID in the description text, so that it is logged and you can compare the two values in the same row.

|||

It worked when I pass the System::ExecutionInstanceGUID as VARCHAR parameter instead of GUID in SQL Task parameter mapping. And when the stored procedure recieves the same parameter as uniqueidentifier

sorry for my late response.

Thanks