Hello, Just started working with reports and I have a existing report I'm trying to modify that connects salesline and bom, the report look has a sales line header with bom detail underneath.
I am trying to have the bom data sorted and u'd think that would be as easy as drag and dropping itemid over to the <data source/bom/sorting> area and doing the generate specs from query but apparently not. CutListSalesLine (var,usr) Methods Data Sources Query Methods classDeclaration Data Sources SalesLine(SalesLine) Fields Sorting Ranges Data Sources BOM(BOM) Fields Sorting ItemId Ranges Data Sources Relations SalesLine.ItemBOMId == BOM.BOMId Designs ReportDesign1 AutoDesignSpecs Body:SalesLine_Body_1 Methods Body:BOM_Body_1 Methods String:BOM_ItemId_1 Generated Design PageHeader:PgHdr_1 Section Group: SalesLine PageFooter:PageFooter ProgrammableSection(1):BlankLine ProgrammableSection(2):DisplayGeneralText ProgrammableSection(3):NumGeneralText Any suggestions? Thanks Kevin ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ [Non-text portions of this message have been removed]