Crystal Reports Select and sum specific totals on Cross tab. Ive decided that the only solution is to re enter the whole query as a sub report, selecting on B and V only. This seems to me to be a long winded method of getting to an apparently simple task. Does anyone have a simpler solution. Heres the orginal sql on which the xtab is based. SELECTRELFB. STATUS1, RELFB. STATUS2,RELEA. SATZART, RELEA. FIRMENNR, RELEA. ARTIKELNR, RELEA. BEZEICHNUNG, RELEA. EDATUM, RELEA. EJAHR, RELEA. EMONAT, RELEA. ETAG, RELEA. ANR, RELEA. MENGE, RELEA. ME, RELEA. UMSATZ, RELEA. AGKNZ1, RELEA. STATUS2,RELFIRMA. KTXT, RELFIRMA. FGKNZ1FROMINFOR. RELFB RELFB,INFOR. RELEA RELEA,INFOR. RELADRESSE RELADRESSE,INFOR. RELFIRMA RELFIRMAWHERERELFB. RNR RELEA. RNR ANDRELFB. ADRNR2 RELADRESSE. ADRESSENR ANDRELADRESSE. FIRMANR RELFIRMA. FIRMANR ANDRELEA. SATZART ABA     RELFB. STATUS1 LORDER BYRELEA. STATUS2 ASCThe new criteria would select STATUS2 as one of either B or V, and create a grand total. Is there a solution without using the sub report optionBold, Italic and changing font color for certain fields Bold, Italic and changing font color for certain fields beammie TechnicalUser. Per Recode, the number one finalist is former General Electric CEO Jeff Immelt, who could be coming before the companys board of directors for a final vote in as. We provide support for Accpac accounting software, SAGE 300 ERP, payroll software, biometric time and attendance system, fingerprint door access, eLeave. Author Message Crystal Method Newbie Joined Location United Kingdom Online Status Offline Posts 15 Topic Select and sum specific. Seagate Crystal Report 8. TutorialBuy Seagate 6TB BarraCuda Pro 7200RPM SATA 6Gbs 256MB Cache 3. Inch Internal Hard Drive ST6000DM004 Electronics Amazon. Standard Vga Graphics Adapter Driver Windows 7 32 Bit more. FREE DELIVERY possible on eligible. The SAP Community is the quickest way for users to solve problems, learn more about SAP solutions, and invent new ways to get things done.