title: ssrs reports line chart how to add category group based on the column data
body: <p>I am developing a sql server report which is basically conversion of an excel report. Without modifying the sp, i would like to create a sql server line chart report.</p>
  
  <p>i have the rows returned something like this:</p>
  
  <p>Date             Technicianname TechnicianType  IssuesFixed</p>
  
  <p>2011-03-04        XXXXX           engineer        20
  2011-03-04        YYYYY           sr.Engineer     35
  2011-03-05        ZZZZZ            engineer       22
  2011-03-05        WWWWW            sr.engineer    40</p>
  
  <p>My line graph should be one line progress shows for engineer and other line shows progress for sr.engineer. </p>
  
  <p>While i add the category groups, i can use aggregate functions but not  any filters.. like techniciantype=engineer, techniciantype=sr.engineer.</p>
  
  <p>Could you please guide me how can i proceed with it..?</p>
  
  <p>Thanks in advance.</p>