select planttype ,sum(noof50kgsbags*50)[50 Kg],sum(noof70kgsbags*70)[70 Kg] from K_FeedPlantEntryIndent WHERE (date BETWEEN '2013-04-01 00:00.000' AND getdate()) AND (attrited = 'True') group by planttype order by planttype
planttype 50 Kg 70 Kg KJL 353550 2416120 Rohini 56150 220990 Sneha 43950 0 Suguna 1290850 0
plantype KJL Rohini Sneha Suguna 50 kg xx xx xx xx 70 Kg x x x xx
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)