Filtering table

Question

i want to generate report but if admin select particular date then it display only data from that date pls help me i dont understand how is it work

Vithal Wadje · Answer

user user input date as condition in where clause of sql query on date column

Abhishek Singh · Answer

Priya Approach would be as below Pass @Role and @date as parameter Do a check in report procedure as If(@Role='Admin') Select data from table where date=@Date Else Select data from table Hope this will help  let me know if you want any sample code for this. Abhishek