Click to See Complete Forum and Search --> : Grouping in Data Report


Spectre5000
October 9th, 2001, 11:29 AM
I have yet another question in regards to data reports in VB 6.0:

I have a data environment and a data report setup. I have established the proper connection, and the parent
and all child commands. When I run the data report, the output should be:

Beginning Balance
Sales
CHECKS
LastName FirstName Amount (1)
LastName FirstName Amount (2)
LastName FirstName Amount (3) etc.
CREDIT CARDS
LastName FirstName Amount (1)
LastName FirstName Amount (2)
LastName FirstName Amount (3) etc.

However, when the report is run, I get the following output:

Beginning Balance
Sales

CHECKS
LastName FirstName Amount (1)
CREDITCARDS
LastName FirstName Amount (1)
LastName FirstName Amount (2)
LastName FirstName Amount (3) etc.

CHECKS
LastName FirstName Amount (2)
CREDITCARDS
LastName FirstName Amount (1)
LastName FirstName Amount (2)
LastName FirstName Amount (3) etc.

CHECKS
LastName FirstName Amount (3)
CREDITCARDS
LastName FirstName Amount (1)
LastName FirstName Amount (2)
LastName FirstName Amount (3) etc.

Is there anyway possible to get the output to resemble the first way? I know in MS ACCESS I was able to do this
by using subreports. But now we are moving away from ACCESS as our database, and we need to keep all the reports
that we currently have by rewriting them in VB. Can this be done? Also, I tried having only 1 parent command and
multiple child commands for that parent, but I get an error stating that the Report Writer does not support multidimensional
hierarchies. Can this be done at all?