Filtering table
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
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Vithal WadjePosted Oct 3, 2014, 5:45 AM
Abhishek KumarPosted Oct 3, 2014, 5:39 AM
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