how to generate report client wise in c#

Question

how to generate report client wise:

i want select client in drop down and all data show and create report or convert into excel

 

 

 

 

 

or convert grid data in excel according to client how it possible please help: