how to use more then one record set in a data report.

I am using Datareport of vb and geting value through this code.

dim rs as new ADODB.recordset
rs.open "select * from table",con
set Datareport1.datasource=rs
datareport1.show

its work well

Now I want to use one more reocrd set for sum up some data as well what I have to do for this.

instead of using it a code what u can do add dataenvironment1 in ur project then make the connection1 connected through ur database. then add one command go to it's properties. then connect it to connection1. then instead of taking a table go for the SQL Builder which will help u to make more than 1 table in ur builder and u can choose ur fields.

There is the RptFunction control in DataReport which could do some of the most common summarizing functions like Sum...