locked
help for grouing in report.rdlc RRS feed

  • Question

  • User563015232 posted

    I have one database table Sales_data.Fields are as under.

    sales_id

    date

    sales_type    : there is 2 types of sales. 2 wheeler * 4 wheeler.

    company

    amount

    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 honey.jagyasi@gmail.com.

     

    Thank you.

    Friday, April 8, 2011 5:08 AM

Answers

  • User-305876627 posted

    SELECT SALES_TYPE, SUM(AMOUNT)

    FROM TABLENAME

    GROUP BY SALES_TYPE, COMPANY

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, April 12, 2011 1:13 PM