object ManyGrpForm: TManyGrpForm Left = 114 Top = 39 Width = 770 Height = 657 Caption = 'ManyGrpForm' Font.Color = clWindowText Font.Height = -13 Font.Style = [] Scaled = False PixelsPerInch = 120 TextHeight = 22 object QuickRep: TQuickRep Left = 12 Top = 14 Width = 992 Height = 1403 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False DataSet = RepQuery Description.Strings = ( 'This report shows how to create a master/detail report from a TQ' + 'uery component and use multiple TQRGroups in the same report') Font.Color = clWindowText Font.Height = -13 Font.Style = [] Options = [FirstPageHeader, LastPageFooter] Page.Columns = 1 Page.Orientation = poPortrait Page.PaperSize = A4 Page.Values = ( 100 2970 100 2100 100 100 0) PrintIfEmpty = False PrinterSettings.Copies = 1 PrinterSettings.Duplex = False PrinterSettings.FirstPage = 0 PrinterSettings.LastPage = 0 PrinterSettings.OutputBin = First SnapToGrid = True Units = MM Zoom = 100 object DetailBand1: TQRBand Left = 47 Top = 121 Width = 898 Height = 25 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = True Frame.DrawRight = True AlignToBottom = False Color = clWhite ForceNewColumn = False ForceNewPage = False Size.Values = ( 52.900000000000000000 1900.766666666670000000) BandType = rbDetail object QRDBText3: TQRDBText Left = 47 Top = 0 Width = 51 Height = 21 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.979166666666700000 100.541666666667000000 0 108.479166666667000000) Alignment = taRightJustify AlignToBand = False AutoSize = False AutoStretch = False Color = clWhite DataSet = RepQuery DataField = 'PartNo' Font.Color = clWindowText Font.Height = -17 Font.Style = [] ParentFont = False Transparent = False WordWrap = True FontSize = 10 end object QRDBText4: TQRDBText Left = 108 Top = 0 Width = 84 Height = 18 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 38.100000000000000000 228.600000000000000000 0 177.800000000000000000) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Color = clWhite DataSet = RepQuery DataField = 'Description' Font.Color = clWindowText Font.Height = -17 Font.Style = [] ParentFont = False Transparent = False WordWrap = True FontSize = 10 end object QRDBText5: TQRDBText Left = 448 Top = 2 Width = 88 Height = 21 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.979166666666700000 947.208333333333000000 5.291666666666670000 185.208333333333000000) Alignment = taRightJustify AlignToBand = False AutoSize = False AutoStretch = False Color = clWhite DataSet = RepQuery DataField = 'ListPrice' Font.Color = clWindowText Font.Height = -17 Font.Style = [] Mask = '#0.00' ParentFont = False Transparent = False WordWrap = True FontSize = 10 end end object QRBand1: TQRBand Left = 47 Top = 171 Width = 898 Height = 30 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = True Frame.DrawLeft = True Frame.DrawRight = True AlignToBottom = False Color = clSilver ForceNewColumn = False ForceNewPage = False Size.Values = ( 63.500000000000000000 1900.766666666670000000) BandType = rbGroupFooter object QRExpr4: TQRExpr Left = 448 Top = 2 Width = 89 Height = 21 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.979166666666700000 947.208333333333000000 5.291666666666670000 187.854166666667000000) Alignment = taRightJustify AlignToBand = False AutoSize = False AutoStretch = False Font.Color = clWindowText Font.Height = -17 Font.Style = [] Color = clWhite Master = QuickRep ParentFont = False ResetAfterPrint = True Transparent = True WordWrap = True Expression = 'sum(listprice)' Mask = '#0.00' FontSize = 10 end object QRLabel5: TQRLabel Left = 298 Top = 2 Width = 143 Height = 18 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 38.100000000000000000 630.766666666667000000 4.233333333333330000 302.683333333333000000) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = 'Total this customer' Color = clWhite Font.Color = clWindowText Font.Height = -17 Font.Style = [] ParentFont = False Transparent = True WordWrap = True FontSize = 10 end end object QRBand2: TQRBand Left = 47 Top = 146 Width = 898 Height = 25 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = True Frame.DrawRight = True AlignToBottom = False Color = 14671839 ForceNewColumn = False ForceNewPage = False Size.Values = ( 52.916666666666700000 1900.766666666670000000) BandType = rbGroupFooter object QRExpr1: TQRExpr Left = 448 Top = 0 Width = 88 Height = 21 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.979166666666700000 947.208333333333000000 0 185.208333333333000000) Alignment = taRightJustify AlignToBand = False AutoSize = False AutoStretch = False Font.Color = clWindowText Font.Height = -17 Font.Style = [] Color = clWhite Master = QuickRep ParentFont = False ResetAfterPrint = True Transparent = True WordWrap = True Expression = 'sum(listprice)' Mask = '#0.00' FontSize = 10 end object QRLabel4: TQRLabel Left = 328 Top = 2 Width = 113 Height = 18 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 38.100000000000000000 694.266666666667000000 4.233333333333330000 239.183333333333000000) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = 'Total this order' Color = clWhite Font.Color = clWindowText Font.Height = -17 Font.Style = [] ParentFont = False Transparent = True WordWrap = True FontSize = 10 end end object ChildBand1: TQRChildBand Left = 47 Top = 201 Width = 898 Height = 12 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False AlignToBottom = False Color = clWhite ForceNewColumn = False ForceNewPage = False Size.Values = ( 25.400000000000000000 1900.766666666670000000) ParentBand = QRBand1 end object QRGroup1: TQRGroup Left = 47 Top = 47 Width = 898 Height = 26 Frame.Color = clBlack Frame.DrawTop = True Frame.DrawBottom = False Frame.DrawLeft = True Frame.DrawRight = True AlignToBottom = False Color = clSilver ForceNewColumn = False ForceNewPage = False Size.Values = ( 55.033333333333300000 1900.766666666670000000) Expression = 'Company' FooterBand = QRBand1 Master = QuickRep object QRDBText1: TQRDBText Left = 5 Top = 5 Width = 74 Height = 18 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 38.100000000000000000 10.583333333333300000 10.583333333333300000 156.633333333333000000) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Color = clWhite DataSet = RepQuery DataField = 'Company' Font.Color = clWindowText Font.Height = -17 Font.Style = [fsBold] ParentFont = False Transparent = True WordWrap = True FontSize = 10 end end object QRGroup2: TQRGroup Left = 47 Top = 73 Width = 898 Height = 48 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = True Frame.DrawRight = True AlignToBottom = False Color = clWhite ForceNewColumn = False ForceNewPage = False Size.Values = ( 101.600000000000000000 1900.766666666670000000) Expression = 'orderno' FooterBand = QRBand2 Master = QuickRep object QRExpr2: TQRExpr Left = 35 Top = 2 Width = 174 Height = 18 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 38.100000000000000000 74.083333333333300000 4.233333333333330000 368.300000000000000000) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Font.Color = clWindowText Font.Height = -17 Font.Style = [] Color = clWhite ParentFont = False ResetAfterPrint = False Transparent = False WordWrap = True Expression = #39'Orderno : '#39'+str(orderno)' FontSize = 10 end object QRExpr3: TQRExpr Left = 250 Top = 2 Width = 128 Height = 18 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 38.100000000000000000 529.166666666667000000 4.233333333333330000 270.933333333333000000) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Font.Color = clWindowText Font.Height = -17 Font.Style = [] Color = clWhite ParentFont = False ResetAfterPrint = False Transparent = False WordWrap = True Expression = #39'Date : '#39'+SaleDate' FontSize = 10 end object QRLabel1: TQRLabel Left = 478 Top = 28 Width = 54 Height = 14 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 29.633333333333300000 1011.766666666670000000 59.266666666666700000 114.300000000000000000) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = 'List price' Color = clWhite Font.Color = clWindowText Font.Height = -13 Font.Style = [] ParentFont = False Transparent = False WordWrap = True FontSize = 8 end object QRLabel2: TQRLabel Left = 58 Top = 25 Width = 39 Height = 14 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 29.633333333333300000 122.766666666667000000 52.916666666666700000 82.550000000000000000) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = 'Partno' Color = clWhite Font.Color = clWindowText Font.Height = -13 Font.Style = [] ParentFont = False Transparent = False WordWrap = True FontSize = 8 end object QRLabel3: TQRLabel Left = 108 Top = 25 Width = 65 Height = 14 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 29.633333333333300000 228.600000000000000000 52.916666666666700000 137.583333333333000000) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = 'Description' Color = clWhite Font.Color = clWindowText Font.Height = -13 Font.Style = [] ParentFont = False Transparent = False WordWrap = True FontSize = 8 end end end object RepQuery: TQuery Active = True DatabaseName = 'DBDEMOS' SQL.Strings = ( 'select * from customer a, orders b, items c, parts d' 'where a.custno = b.custno' ' and b.orderno = c.orderno' ' and c.partno = d.partno' 'order by a.company, orderno') Left = 18 Top = 10 end end