title: Implementing Advanced Filter Page
body: <p>I have a page which gives user to generate report based on different filters selected.
  I need some suggestion or idea on my thoughts</p>
  
  <ol>
  <li><p>Loop through each filter control
  (checkbox, multi select list,
  radiobox list)  and build dynamic
  where conditions and conjunctions
  for each filter and then run query</p></li>
  <li><p>Get all the data (i think this will 
  causes an overload with all 4-5
  tables joined) and then use Linq to
  filter this data based on user selection  </p></li>
  <li><p>Is there a better way to implement
  this?</p></li>
  </ol>