Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Apr 11, 2012 11:16 AM|LINK
Alright, what you're going to want to do in this case is use the query designer. Start first by doing a super simple query and see if you get anything from the database. If you do, then next thing to do is add a condition to the query like:
where dete = @dete AND isApproved = true
If that works, then we add another variable to the mix, namely Category:
where Category = @Category AND dete = @dete AND isApproved = true;
Since your boss is being tough about allowing you to show more details, this is the best I can do under the circumstances. If those queries return values, then we can try doing some more refinement.