I actually pass employee id of a single employee and that it generate report for employee but how can i do this if there are multiple employee having same criteria . if store procedure generation multiple employee data than That much reports should be generated.As i am new to this, help me out.... Thanks :)I actually pass employee id of a single employe