sql server - ssrs reports line chart how to add category group based on the column data -
i developing sql server report conversion of excel report. without modifying sp, create sql server line chart report. i have rows returned this: date technicianname techniciantype issuesfixed 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 my line graph should 1 line progress shows engineer , other line shows progress sr.engineer. while add category groups, can use aggregate functions not filters.. techniciantype=engineer, techniciantype=sr.engineer. could please guide me how can proceed it..? thanks in advance. try putting date category field, issuesfixed data field, , techniciantype series field. have 2 progress lines, 1 engineer , sr. engineer, date on horizontal axis, issuesfixed on vertical axis. if want filter individual names, or other variable, right-click on 'variable/b...