Data report grouping

[giyer555]

Hi!!! friends I have got another Q related to data report pls help.

I retrieve the data using the following query in a forms command click event

Ssql = "select a.emp_code, b.emp_name, a.br_code, b.account_no, b.bank_code, c.bank_name, a.total_sal from emp_earnded a, emp_mast b, bank_mast c where a.emp_code = b.emp_code and b.bank_code = c.bank_code and b.pay_mode = 0 and a.Month = " & cbomonth.Text & " and a.Year = " & cboyear.Text & " and a.posted = 1 order by b.bank_code, a.br_code, a.emp_code"
DataEnvironment1.Commands(11).CommandText = ssql
dtrbankstmt.Sections("pqr&quot.Controls("lblmonth&quot.Caption = strmonth & " " & cboyear.Text
dtrbankstmt.Show

I need to print the report as per individual bank_code in separate pages

The report should be displayed as follows -

Bank_code 555 Bank_name xyz

Header
Emp_code, emp_name, br_code, account_no, total_sal

Detail
Emp_code, emp_name, br_code, account_no, total_sal

Report Footer
No of record 50 Total Sal 555555

 

[giyer555]

Johnwm, CCint anyone pls guide

 

[giyer555]

Have i posted my thread in the wrong forum??