Is it possible to have a List box or a combo box instead of a Drop downlist

Hi

Is it possible to have a list box or a combo box for selecting parameters instead of having a drop down list...

and If yes how can i do it?

Regards

Karen

Sure you can. Just drag a listbox control onto your page. Set the autopostback property to true if you want to allow postback and SelectionMode to Multiple if you want to allow more than one item to be selected. Then to access the items programmatically, you can do something like this.

Dim xAsString =String.Empty

For iAsInteger = 0To ListBox1.Items.Count - 1

If ListBox1.Items(i).Selected =TrueThen

x = x & ListBox1.Items(i).Text &","

EndIf

Next

|||

Thanks adyle,

it is possible to do this in the report manager??

Regards

Karen

|||

Hi Karen,

Can u tell me how to add a dropdown to my report ?

thanx

Magik

|||

Magic

do u wanna have a drop down list that has check boxes in it for multiple selections if so.. then

1) in your report parameter select the parameter that u want make as a dropdown and then select the multivalue check boxes...

2) if you want u can create a different dataset to popluate the drop down list and select query from the avaliable values.. and then select the dataset etc. and click ok.

3) in your stored procedure should like this...

Declare the @.Param as nvarchar(max)

@.sqltext nvarchar(max)

if the @.Param is NULL

Begin

select * from whatever and include the joins

Else

Begin

Select @.SqlText = 'Select * from tablename where Field or columnname in @.Param'

Exceute (@.sqltext)

End

Hope this helps,

Regards

Karen

sql

Is it possible to have a List box or a combo box instead of a Drop downlist

Hi

Is it possible to have a list box or a combo box for selecting parameters instead of having a drop down list...

and If yes how can i do it?

Regards

Karen

Where? No, in the Report Manager. Yes, in custom applications that use the report viewer controls.|||

using Report manager.. how can i use it in report viewer control... cause i am letting the users view the same reports using Report viewer.. can u please give me some links as to how to do it...

regards

Karen

|||

In the Report Viewer control you can hide the parameter area and replace it with your own. You may find the following article useful.

|||

Teo Lachev,

Thanks for ur answer... is it possible to do something like this in the stored procedure directly.. cause i am calling a stored procedure for that particular parameter and it list the all the plans in that drop down box...

My main Stored procedure to run the Report has 4 Parameter... and to populate one of the Parameters in the report i am using another sproc so that i can get all the plans... and if this is the case .... how do i get the values in a list...

Regards,

Karen

|||

So, once you decide to implement your own parameter area, it is up to you what controls to use or validation logic to implement to validate the parameter values. Essentially, you are building a custom WinForms or ASP.NET front end to handle parameters.

Is it possible to have a List box or a combo box instead of a Drop downlist

Hi

Is it possible to have a list box or a combo box for selecting parameters instead of having a drop down list...

and If yes how can i do it?

Regards

Karen

Where? No, in the Report Manager. Yes, in custom applications that use the report viewer controls.|||

using Report manager.. how can i use it in report viewer control... cause i am letting the users view the same reports using Report viewer.. can u please give me some links as to how to do it...

regards

Karen

|||

In the Report Viewer control you can hide the parameter area and replace it with your own. You may find the following article useful.

|||

Teo Lachev,

Thanks for ur answer... is it possible to do something like this in the stored procedure directly.. cause i am calling a stored procedure for that particular parameter and it list the all the plans in that drop down box...

My main Stored procedure to run the Report has 4 Parameter... and to populate one of the Parameters in the report i am using another sproc so that i can get all the plans... and if this is the case .... how do i get the values in a list...

Regards,

Karen

|||

So, once you decide to implement your own parameter area, it is up to you what controls to use or validation logic to implement to validate the parameter values. Essentially, you are building a custom WinForms or ASP.NET front end to handle parameters.

Is it Possible to download mails?

Hi,
I have a mail box in one machine. I just want to download all the mails
from that machine to the server which is running SQL Server 2000 and store
them in the database. Is this Possible? If so, let me know how this can be
done efficiently.
I would like to download mails automatically from that machine to the
server whenever the mails arrive.
Regards,
Sevugan.CYOu could use the XP xp_readmail, descriptions are written in the BOl for
that. For further control over the mails you should use another technology,
like something coding on your own in .NET to query the mailbox with Webdav
or something like that.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Sevugan" <Sevugan@.discussions.microsoft.com> schrieb im Newsbeitrag
news:DBD4354E-5A4A-4B1E-8747-CBF0FF913C95@.microsoft.com...
> Hi,
> I have a mail box in one machine. I just want to download all the mails
> from that machine to the server which is running SQL Server 2000 and store
> them in the database. Is this Possible? If so, let me know how this can be
> done efficiently.
> I would like to download mails automatically from that machine to the
> server whenever the mails arrive.
> Regards,
> Sevugan.C|||Hi,
xp_readmail Reads a mail message from the Microsoft? SQL Server? mail
inbox. How do I bring all the mails from the mail client(Microsoft Outlook)
to
sql server mail box. How can I see the mails in the SQL Server mail box.
Can u give me a small examle? This will be very helpful for me.
I am new to SQL Server mails.
Regards,
Sevugan.C
"Jens Sü?meyer" wrote:

> YOu could use the XP xp_readmail, descriptions are written in the BOl for
> that. For further control over the mails you should use another technology
,
> like something coding on your own in .NET to query the mailbox with Webdav
> or something like that.
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Sevugan" <Sevugan@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:DBD4354E-5A4A-4B1E-8747-CBF0FF913C95@.microsoft.com...
>
>|||HI
Well I have an idea but i am not sure about this.
1)I think you can use the mail component and write a code or a script to
retrieve mails from the machine and make connectivity to the SQL server and
store your mails in the database
2) you can also use SQL DMO to connect to SQL Server and store your mails in
the database.
"Sevugan" wrote:

> Hi,
> I have a mail box in one machine. I just want to download all the mails
> from that machine to the server which is running SQL Server 2000 and store
> them in the database. Is this Possible? If so, let me know how this can be
> done efficiently.
> I would like to download mails automatically from that machine to the
> server whenever the mails arrive.
> Regards,
> Sevugan.C|||Maybe this will help !
You can connect on you server with the same credential than SQL Server,
then check mail !
Pollus Brodeur|||I have started a mail session. I used xp_findnextmsg to get the next
message id.
when I executed the below statement.
EXEC xp_readmail '0x04B72100' it keeps on executing. I am not getting any
response from the server. What could be the problem.
How could I resolve this?
Sevugan.C
"Jens Sü?meyer" wrote:

> YOu could use the XP xp_readmail, descriptions are written in the BOl for
> that. For further control over the mails you should use another technology
,
> like something coding on your own in .NET to query the mailbox with Webdav
> or something like that.
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Sevugan" <Sevugan@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:DBD4354E-5A4A-4B1E-8747-CBF0FF913C95@.microsoft.com...
>
>

is it possible to do this?

Hi,

I have a table with 2 columns. If the condition for that text box evaluates to true i want to hide the second column and make the first columns width equal to the First and the second... for example this.

Company Match

Years of service Vesting %

its gonna display like this if the condition is false..

if true i want it to display

Company Match

Immediately Eligible (this should be in the middle) right now i can display it like this

Company Match

Immediately elgigible..

Any help will be appreciated.

Regards

Karen

Instead of hiding a column, why dont you use two asp:label and Hide the other if your condition matches. That makes your life more easier.

|||

i want to do this in the report itself?

Regards

Karen

|||

Each colum is act as a textbox

Go to its properties -> Visiblity-> Hidden

The value for Hidden can be an expression like " = iif(CDec(Parameters!xxxVal.Value) > 0.00,false,true)"

|||

Instead of hiding a column, why dont you use two asp:label and Hide theother if your condition matches. That makes your life more easier.

|||

how can i use asp:Label in SSRS? Never mind guys i solved it

Karen

sql

is it a good practice to do integrity check before perform backup?

On maintenance plan, there is a check box on integrity tab page, is it a good
way to do that first? if there is error found, will the backup stop? thanks
Hi
It depends on what error it will find. Actually, you can checkbox but make
sure that you uncheck Attempt to repair... option.
"tulip" <tulip@.discussions.microsoft.com> wrote in message
news:06E26A1F-4F08-4D81-9502-07E9DB0F5041@.microsoft.com...
> On maintenance plan, there is a check box on integrity tab page, is it a
> good
> way to do that first? if there is error found, will the backup stop?
> thanks
|||My approach is that if you have plenty of maintenance window for doing the
integraity checks (i.e. DBCC checks), do them by all means. And if you are
running into integrity issues, you may want to perform the DBCC checks more
regularly. It becomes a more difficult question when you are dealing with a
large amount of data and when you are struggling to contain your maintenance
jobs inside a limited maintenance window. In that case, you may have to forgo
the DBCC checks or do them very selectively.
Linchi
"tulip" wrote:

> On maintenance plan, there is a check box on integrity tab page, is it a good
> way to do that first? if there is error found, will the backup stop? thanks

is it a good practice to do integrity check before perform backup?

On maintenance plan, there is a check box on integrity tab page, is it a good
way to do that first? if there is error found, will the backup stop? thanksHi
It depends on what error it will find. Actually, you can checkbox but make
sure that you uncheck Attempt to repair... option.
"tulip" <tulip@.discussions.microsoft.com> wrote in message
news:06E26A1F-4F08-4D81-9502-07E9DB0F5041@.microsoft.com...
> On maintenance plan, there is a check box on integrity tab page, is it a
> good
> way to do that first? if there is error found, will the backup stop?
> thanks|||My approach is that if you have plenty of maintenance window for doing the
integraity checks (i.e. DBCC checks), do them by all means. And if you are
running into integrity issues, you may want to perform the DBCC checks more
regularly. It becomes a more difficult question when you are dealing with a
large amount of data and when you are struggling to contain your maintenance
jobs inside a limited maintenance window. In that case, you may have to forgo
the DBCC checks or do them very selectively.
Linchi
"tulip" wrote:
> On maintenance plan, there is a check box on integrity tab page, is it a good
> way to do that first? if there is error found, will the backup stop? thanks