Problem3: How to separate Body Part in the Data Report

I want to show report, which the detail have to separate into 2 parts and 2 set of sql commands too.

Is it possible to separate 2 set of of data and SQL commands on the same report. If Yes, how to do it, Thank you (Again)

I don't think because there is one DataSource property inwhich we assign object of Recordset.

But may be I am wrong.

You could right click on the report and add Group Headers and have two sections and then drag where necessary...:)

But what code should we write in order to pass two queries.

Just add two command objects so you can have two queries in there, and in the first section drag the first object & in the 2nd section drag the second command object...that is it...

oh yeah.

I didn't think about this.

Thanks

One Datareport can set only one Data environment and one data member (SQL command), so how we can add 2 SQL commands in one data report ..... :confused:

Hi mxnmx

You wrote...

Quote:

---

mxnmx: Just add two command objects so you can have two queries in there, and in the first section drag the first object & in the 2nd section drag the second command object...that is it...

---

I would very much like to see this.. Could i please ask you to write code or sample project and post here...

Thanx.