Here I attached my screen shot to easily under stand to give solution then I written above I Had 3 parameters when I would be select "Real Time" in Type of view then automatically select null or any other else in View parameter. Report Name : UNPAIDCOMMISSION In this I had Three Parameters which are 1.@Typeof View 2.@View,3.@Entity 1 @Typeof View has drop down 1. Snapshot and 2.Real Time but @View is working with on depending @Typeof View because of my query is 1.1 When I will be selecting "Snapshot" in @Typeof View then it displaying three dates in @View but again When I will be selecting "Real Time" in @Typeof View then It will be selected default NULL or anything else automatically in @View then How to set for @View Parameter PLease Check it this Main Sproc For UNPAIDCOMMISSIO ============================= ========================================= When I click on Preview Then Report call first the Sproc which is [Report].[RSP_UnpaidCommission] then that three parameters are available in this above Proc When I select Real Time in @Typeof View then default select one value in @View parameter whether it is Null or Anything else Can Anyone give reply asap!!!!!!!!!!!!! Hi TIM Thanks for your reply I had query over here Where could I enter this Expression It means 1. Parameter Level or 2.Dataset Level

Here I attached my screen shot to easily under stand to give solution then I written above I Had 3 parameters when I would be select "Real Time" in Type of view then automatically select null or any other else in View parameter. CAn Any one give reply asap?

Your screen shots are not displaying. Sounds like you are talking about setting the default value of a parameter. Defaulting to null is easy. Set the parameter to allow null values then set the default to use a specific value. You will see that the default "specific" value is null. If you want something else as default, type that value in place of the (null) that it defaults to. You can also set the default using a formula (with some restrictions) to programatically set the default value of the View parameter based on the value of the View Type parameter: =IIf(Parameters!ViewType.Value="Real Time","X",IIf(Parameters!ViewType.Value="blah","Y",IIf(Parameters!ViewType.Value="blahblah","Z",Nothing))) Please Mark posts as answers or helpful so that others can more easily find the answers they seek.

Just create Temp Table In Populate Sproc and then Call Temp Table in Real Time and Then go to Report Select the Available Values as Select the Radio button Get Values from Query then Select Default Values as Get Values from Query Like this Create Table #TempData ([SnapShot Label] Varchar(255)) INSERT INTO #TempData Values ('NA') Then Click on Preview

Like this Create Table #TempData ([SnapShot Label] Varchar(255)) INSERT INTO #TempData Values ('NA')

Hi Nsrao, Glad to hear that you have resolved the issue by yourself and thanks for share your soluation. Regards, Fanny Liu Fanny Liu TechNet Community Support

Thanks Fanny Liu With Best Regards, Nageshwar