HI, i have two parameters for which i have used DSParameterProcess(Select YearID,year from year) ,DSParameterYear(select Processid,Process from process) and DSMain(select title,key from Product as p inner join category as c on p.somekey=c.somekey where c.Process=@Process and c.Year=@Year i have used Stored procedure in all the datasets . i have also mentioned the query used in stored procedure. i have tested using textbox for year and ddl for Process. if i pass the year and process and getting the output, but to make year as an optional parameter i have checked "Allow Blank Value". when i view the report its not prompting for Parameter at the same its not displaying the report without year value. I guess it assuming the value to be NULL because of which the Joins used in the query fails. how can i set the parameter to be optional for Textbox and DDL. the user can choose any one either year or Process Thanks, Saraswathy Kumaravelu

DSMain(select title,key from Product as p inner join category as c on p.somekey=c.somekey where c.Process=@Process and (c.Year=@Year OR @Year IS NULL)Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/