I was searching too for a code like this and based on the last post of Eugene (A BIG THANK YOU FOR YOUR CODE!!!), I've play a little with it...

Oh! I was not aware of this. Thanks for the info.

I don't think that "like" can be used. Why not Left(xxx, 2) in your example ?

=IF(Left(MyField,2)="ET";"Mybitmap.bmp";"")

Is it not possible by adding a "=IF(NOT(MyFields.Value Is Null);'http://xxxxx';'')" If the field is not null, the Action will be set to the url otherwise to an empty string.

(remark...

I hope not... There is a potential risk with the security no ?

I don't think that this is possible and this for a simple reason : it isn't possible to superpose objects with SSRS (not in the 2005 version).

You can have a...

With a SQL task you can fired a SQL directly on your table. Then, store the value in variables.

I don"t doubt that you'll find tutorials on Google for this.

Is this a good reason ? Why not asking for adding a table ?

I think that this solution will be the best one and the more flexible (just...

Why not a table in your database with the dayname and the email address of your recipient ? And then read this table in your SSIS package, put recipients...

Image two parameters : Country and the City.

If the user select "Belgium" in the Country Dropdown, then the SQL for City should be

SELECT City FROM tblCities WHERE Country=@Country ORDER...

In Excel, go to Data - Get external data.

MS Query will then be launched and will allow you f.i. to connect to a SQL db and to fire a T-SQL,...

Layout is one of the major problem with SSRS; IMHO.

A work around : put a table object in your report and put your fields on this table. When exporting...

Not tested

Property Format = "MM/dd/yyyy hh:mm"

I've learned something. Thanks !

Use the Reporting Server configuration tools. You'll find it in Programs -> MS SQL Server -> Configuration tools.