Creating Groups in Data Report

[Tina]

I am trying to design a Data Report in VB6 and need to create sub groups. But i dont seem to be doing it right. I get an error messege whenever I manually insert a group.

Also, Is crystal report easy to use? I have never used it before and would welcome any suggestions on how to create one.

[Dr_Michael]

From my experience with Data Reports, it seems that it is not a good utility. Crystal Reports are more powerful but not so easy to use.
Anyway, about the grouping you want, I tried also to do it manually and I get an error: "Report sections do not match with current data source".
Well, if you have only 1 table, then right click on the command, go to the grouping tab and select the field(s) that you want to be the grouping fields. Now, right click on the report and select: retrieve structure. It will clear the report, and you have to design it again!
If you have 2 tables, make one parent and the other child. Such way you achieve grouping easily.
Let's say my question now: What if you have only 1 table and want grouping and sub-grouping inside this????

Michael Vlastos
Automation Engineer
Company SouthGate Hellas SA
Development Department
Athens, Greece

yes, Crystal reports are easier to use and manage. Try ur best and enjoy.

[Tina]

The data for my report is from a SQL which is linking 4 tables and I need to have 4 levels of grouping. Is this possible ?

[Dr_Michael]

You use 4 tables, ok. Do they have any relation among each other? If yes, create the same relation hierrarchy to your data environment by adding child commands to parent ones. If you do it, retrieve structure to your data report and you will get grouping headers/footers. If you nees more, it will be done by the way I have already told you (using grouping tab).
But: what happens if you have 1 table only and want 2 groupings? This is my situation and still I have not an answer... :-(

Michael Vlastos
Automation Engineer
Company SouthGate Hellas SA
Development Department
Athens, Greece