Datareport an grouping

[36]

I have got some problems with the Datareporttool in VB6.
I type the SQL-Script in the Initialisation-section of teh report and then I set Reportname=recordset.
It works. But if I want to group the Informations, then it doent works so fine.
For grouping I use the Shape{select....} as Parentcmd ...
In the report I Insert the groupheader and the -footer.
Then I set Reportname=recordset from Parentcmd). How can I set the detailssection-datasource (childcmd)?

 

[gigsvoo]

Use GROUP BY statement in the SQL statement? Thanks

Neo

http://communities.msn.com.my/VisualBasicwithNeo

 

[36]

If i use Group by in sql then there comes the message, theat the report does not match the datasource.

 

[gigsvoo]

Or shall redesign the number of report textboxes? DO u think the GROUP BY will come out the require recordset? if yes, then rearrange the thing to fit. Thanks

Neo

http://communities.msn.com.my/VisualBasicwithNeo