Last post Apr 12, 2011 01:13 PM by codemihir1
Apr 08, 2011 05:08 AM|honeyjagyasi|LINK
I have one database table Sales_data.Fields are as under.
sales_type : there is 2 types of sales. 2 wheeler * 4 wheeler.
I want to find total of all sales items & also want to find suntotal as per type in report.rdlc file in table format..
pls send me code ASAP on email@example.com.
Apr 12, 2011 01:13 PM|codemihir1|LINK
SELECT SALES_TYPE, SUM(AMOUNT)
GROUP BY SALES_TYPE, COMPANY