-
shape query vb6
Hi all,
Is it possible to use SHAPE Command if I have only one table in my database
This is an example of how my table looks like
----------------------------------------------------------------------------------
ID Override Type Action Data1 Data2 Data3
-----------------------------------------------------------------------------------
1 N Detailed 1 11 12 13
1 N Detailed 2 11 12 13
1 N Summary 1 11 12 13
1 N Summary 2 11 12 13
1 N Summary 3 11 12 13
1 Y Detailed 1 11 12 13
1 Y Detailed 2 11 12 13
1 Y Detailed 3 11 12 13
1 Y Summary 1 11 12 13
1 Y Summary 2 11 12 13
I'm using DataReport without DataEnvironment taking data from Access 2K.
I wanna have report with 2 groups and 1 detail, so it'll look something like this
----------------------------------------------------------------------------
Override = Y
----------------------------------------------------------------------------
Report Type = Detailed
Action 1 11 12 13
Action 2 11 12 13
----------------------------------------------------------
Sub-Total 22 24 26
----------------------------------------------------------
Report Type = Summary
Action 1 11 12 13
Action 2 11 12 13
Action 3 11 12 13
----------------------------------------------------------
Sub-Total 33 36 39
----------------------------------------------------------
----------------------------------------------------------------------------
Total 55 60 65
----------------------------------------------------------------------------
please send me shape command
-
Re: shape query vb6