requirement:actually i created a pie chart in .rdlc file
in my chart i have 2 values i.e, memname & no_of_books_taken
for members who are having no_of_books_taken=3, i need to get all those
memnames in a single color of pie chart

but i got 3 diff colors for 3 memnames.
how can i solve this,plz help me out
my query is:
SELECT t1.numofbookstaken, t1.memname
FROM booksissuetable AS t1 INNER JOIN
vbook AS t2 ON t1.numofbookstaken = t2.numofbookstaken
GROUP BY t1.numofbookstaken, t1.memname