Then as far my knowledge it will get refresh because it will execute all the dataset once again based on selected parameter value

Are you excuting any query based on the selecting parameter value?.

Use IIF or something like this

is it asking sql server username/password or system username/password?

As far i know you can execute the query in the dataset based on the selected parameter but you can't execute the datasets based on parameter because all the dataset...

I think flash is not possible but you can add gif image.

Thanks SIVA and DEAN. I need SSAS book for 2005. I need this to learn SSAS 2005 and then to get cerification in 70-445 Business Intelligence exam.

Please specify some...

Please expand your problem. I'm not clear with your issue

Thanks for your valuable reply Scott.

Which is the best book or site to learn SSAS?

Use

=Fields!Test1.Value-Fields!Test2.Value in the expression of thrid column.

Hope this will help you

Waiting for your test result

Hope the below url will help you

http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/9e6043f1-c458-4540-be59-d37b02feab8a/

Waiting for your test result

Thansk for your reply.

I solved this issue by adding

Imports System.Security

Imports System.Security.Permissions

Please help me experts

You can filter the data using query

select * from tablename where columnname=(select case User!UserID when 'manager name' then columnname else User!UserID)

In Sql where columnname=columnname it will list entire data...