Hi, I have created a report which have begdate and enddate as parameters.In the enddate i want the current date to be default,so I used the function today.now and for the Begdate i need to set the recent date for account period.........so what I did is i created a dataset(select Begdate from Account_period) to get the values for the Begdate...in the available values i have given the data set and the name of the column and got the values but i need to set the default value for the BegDate.......so default value shld be like it shld have recent value date from the account period....let say this is feb...so it shld have feb datefrom the account period dataset....so how to write the expression can any one help me..

I'm not sure I understand your question correctly, but if you jst want to set the recent date from the begdate field, you can try setting the default values to get values from a query, and in the create the dataset with the following query and choose this dataset. SELECT MAX(begdate) FROM TABLENAME Let me know if you need anything else..SqlUser2011

I'm not sure I understand your question correctly, but if you jst want to set the recent date from the begdate field, you can try setting the default values to get values from a query, and in the create the dataset with the following query and choose this dataset. SELECT MAX(begdate) FROM TABLENAME Let me know if you need anything else..SqlUser2011

got the answers... select Top (1) acct_period,begin_date,account_year from account_period Where begin_date <= GetDate () order by begin_date desc