shape query vb6

[softtahir]

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

[wes4dbt]

Read this http://www.vbforums.com/showthread.p...ataenvironment