How remove blank values from report parameter list

Hi,

In report designer, while adding report parameters how to remove blank or empty values from parameter drop down list. Blank values will appear even after unchecking "Allow blank value" option.

Thanx

I think you messed something up. Allow blank values only means that you can put in a empty string as a parameter value. If you have a data driven combobox you will have to redefine the query that fills the combobox to make it only to show non blank values. Look for the column you specified as value column if you can filter the values out, that are retrieved from the database.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
sql

How I post a message on MSMQ?

Hi,
I want to execute a T-SQL for adding a message on a message queue, I know
that I can create a DTS task but I want to include it on a trigger. I found
extended procedures like xp_createprivatequeue and so on but no procedure to
push a message, Also I know that I can create my own xp to do it but I was
wondering if there is a simpler way,
thanks!
Salva
Salvador Alvarez Patuel
salvador.alvarez@.exony.com
Exony Ltd - London, UKHi
That is an undocumented XP and you should not use it.
SQL Server has no built-in methods to acces MSMQ. That belongs in a
middle-tier or your application.
Regards
Mike
"Salvador" wrote:

> Hi,
> I want to execute a T-SQL for adding a message on a message queue, I know
> that I can create a DTS task but I want to include it on a trigger. I foun
d
> extended procedures like xp_createprivatequeue and so on but no procedure
to
> push a message, Also I know that I can create my own xp to do it but I was
> wondering if there is a simpler way,
> thanks!
> Salva
> --
> Salvador Alvarez Patuel
> salvador.alvarez@.exony.com
> Exony Ltd - London, UK