title: Generating report from two separate tables using visual studio
body: <p>I've got a table(concepttable) which has stored emotions in conceptname column such as happy sad etc. Users can add more emotions in it via asp web form. 
  In the same dataset there is another table called (blog) that has a string of multiple blog entries with there entry dates.</p>
  
  <p>How would i go around by using a <strong>service report</strong> to use a droplist that displays the stored emotions in (conceptname) and then shows how many times that selected emotion such as sad has appeared in all blogcontent strings in the blog table?</p>
  
  <p>Any help is appreciated, I've been trying blindly using joins and full text searches but am not certain what way to go around to achieve this.
  Ive attached an image showing the data sources.<img src="https://i.stack.imgur.com/drgNM.png" alt="enter image description here"></p>
  
  <p>The output i want to achieve is a chart similar to this:</p>
  
  <p><img src="https://i.stack.imgur.com/Mvdgy.png" alt="enter image description here"></p>
  
  <p>Sorry if this is vague, add a comment if your not sure what i mean. Thanks for any help!</p>