Datareport grouping problem !! SOS!!!

[FionL]

VB 6.0 --> Report Desinger

I would like to add 2 grouping header in the same datareport but once I added the 2nd grouping header the runtime error message "Report Section do not match data Source" prompted out!!!!!!! Anybody please HELP !!

The following are steps that i had tried on:

(1) the connection was build thru dataEnvironment (and its
confirmed working)
(2) added a new report
(3) set the datasource and datamember to the report
(4) insert a new group header/footer (A)
(5) retrieve the structure of the report
(6) insert another group header/footer (B)
(7) Drag in data_grouping_field from dataEnvironment into
header (A) and (B) respectively.
(8) Run the program and the following runtime error prompted
out.--> "Section do not match data Source"

Should this be the correct way to add in a new grouping header?
VB 6.0 --> Report Desinger

[mustafi]

Hi

Im in the same boat but this what data report does:
If you want to group by 2 columns the data report
expects them in the same Group/Header section.

Eg. Select hit_date, username, hit_count from hit_table

If group your report by hit_date and username and then
retrieve the structure in data report only 1 Group Header/Footer
will be inserted. Put both the controls in the Header/Footer
and run the report. You will notice it is grouped correctly but not quit like you want. The best answer is to use a child query(s) if you can, this will allow you till have the groups , group totals you
are proberly looking for.

If you find another way PLEASE LET ME KNOW ASAP