Crystal Reports IX: How to suppress printing a Group Header when the details start on the next page?
I’ve got a report with a large group-header, and want to suppress it if the details don’t start until the next page, where the group header is repeated. Any ideas?
Forcing a page-break is not an acceptable option, as there are some sections that will print with a single detail record, thus wasting large amounts of paper.
The group-header is repeated on the next page with the Repeat Group Header on Each Page checkbox. I’ve figured the solution out, but thanks for asking. Hopefuly, you learned something.
Hi. How did you configure your Group Header to cause it to be repeated? Are you sure that it’s not the Page Header that’s being displayed on the next page?
One option you have is to enable the New Page Before option on your group header. This ensures that the group header begins at the top of a page thus leaving the maximum amount of space possible below the header for the details to be printed.
Response to author’s Additional Details:
If you don’t mind, can you share how you solved the original issue?
Also, for those reading this Q&A, the Repeat Group Header on Each Page option isn’t located in the Section Expert. You need to use the Change Group feature and then go to the Options tab to enable the Repeat Group Header on Each Page.
Since there are only 2 hours left before this question is closed I thought I’d post some additional information that might be helpful to the viewing audience. I don’t know how the author opted to solve the problem but I did come up with a viable solution (albeit a somewhat ugly one) using Global Variables.
Create the following 2 formulas:
@Group Header Print Count Reset
// Group Header Print Count Initialization
WhilePrintingRecords;
Global NumberVar GroupHeaderPrintCount;
GroupHeaderPrintCount = 0
@Group Header Print Count Increment
// Group Header Print Count Increment
WhilePrintingRecords;
Global NumberVar GroupHeaderPrintCount;
GroupHeaderPrintCount = GroupHeaderPrintCount + 1
Add the formula @Group Header Print Count Reset to the Report Header. Also add it to the Group Footer. Add the formula @Group Header Print Count Increment to the Group Header.
Then, assign to the Group Header’s suppression formula the following:
// Group Header Suppress
WhilePrintingRecords;
Global NumberVar GroupHeaderPrintCount;
if (GroupHeaderPrintCount > 0) then
true
else
false
I haven’t tested this (ran out of time) but it should work. Hope it’s helpful.
Jeff
The Crystal Maze – Winning Group
|
|
CB Radio Crystal 2576 – 28.8150 MHZ CH-17R D GROUP $4.00 |
|
|
CB Radio Crystal 2577 – 13.2750 MHZ CH-4R Q GROUP $4.00 |
|
|
VINTAGE CRYSTAL BEAD GROUP ~ NECKLACES, BRACELET, EARRINGS ~ BRILLIANT SPARKLE $24.00 |
|
|
CB Radio Crystal 2581 – 27.5900 MHZ CH-15R H GROUP $4.00 |
|
|
Prima * SAY IT IN CRYSTALS * Pearls & Roses Jewels Embellishments Group 1 $3.95 |
|
|
Prima * SAY IT IN CRYSTALS * Pearls & Roses Jewels Embellishments Group 1 $3.95 |
|
|
Prima * SAY IT IN CRYSTALS * Pearls & Roses Jewels Embellishments Group 1 $3.95 |
|
|
Prima * SAY IT IN CRYSTALS * Pearls & Roses Jewels Embellishments Group 1 $3.95 |
|
|
Prima * SAY IT IN CRYSTALS * Pearls & Roses Jewels Embellishments Group 1 $3.95 |
|
|
Prima * SAY IT IN CRYSTALS * Pearls & Roses Jewels Embellishments Group 2 $3.95 |
|
|
Prima * SAY IT IN CRYSTALS * Pearls & Roses Jewels Embellishments Group 2 $3.95 |
|
|
Prima * SAY IT IN CRYSTALS * Pearls & Roses Jewels Embellishments Group 2 $3.95 |
|
|
Prima * SAY IT IN CRYSTALS * Pearls & Roses Jewels Embellishments Group 2 $3.95 |
|
|
Crystal Group CS1000 Computer Chassis, New $211.65 |
|
|
Prima * SAY IT IN CRYSTALS * Pearls & Roses Jewels Embellishments Group 3 $2.95 |
|
|
Prima * SAY IT IN CRYSTALS * Pearls & Roses Jewels Embellishments Group 3 $2.95 |
|
|
Prima * SAY IT IN CRYSTALS * Pearls & Roses Jewels Embellishments Group 3 $2.95 |
|
|
Prima * SAY IT IN CRYSTALS * Pearls & Roses Jewels Embellishments Group 3 $2.95 |
|
|
Prima * SAY IT IN CRYSTALS * Pearls & Roses Jewels Embellishments Group 3 $2.95 |
|
|
Super Groups LP Various Doo Wop The Platters Crystals Chiffons Coasters 1980 $10.99 |
|
|
Lot of 12 GIRL GROUP SINGERS 45 Records CRYSTALS Orlons SHIRELLES Lesley Gore $7.00 |
|
|
Galena: Superb Group Of Hoppered Crystals: Kruschev Dol Mine, Bulgaria. $89.00 |
|
|
Da Doo Ron Ron: The Very Best of the Crystals * by Crystals (Girl Group)… $31.17 |
|
|
CB Radio Crystal 2583 – 13.6275 MHZ CH-23T C GROUP $4.00 |
|
|
Calcite Crystal Group with Included Highly Unusual Habit: Lowville New! $75.00 |
|
|
GROUP OF 18 COMEDY DVD’s-CARREY-CRYSTAL-FARLEY-AYKROYD-MURPHY-SHEEN “NO RESERVE” $9.99 |
|
|
New Waterford Crystal ornament – 10 Lords A Leaping $25.00 |
|
|
TOURMALINE CRYSTAL “STARBURST” FLOATER GROUP, GILGIT, PAKISTAN $85.00 |
|
|
SWAROVSKI SILVER CRYSTAL “LITTLE STAR 2005 CHRISTMAS THEME GROUP” 681402 MIB $84.29 |
|
|
SWAROVSKI SILVER CRYSTAL “1997 ANGEL HANGING ORNAMENT CHRISTMAS – THEME GROUP” $145.89 |
|
|
5.3oz BRILLIANT RED VANADINITE CRYSTAL GROUP MINERAL $39.99 |
|
|
CB Radio Crystal 1861 – 33.1350 MHZ CH-15R G GROUP $4.00 |
|
|
0.6″ Translucent MilkyGreen EUCLASE Terminated Crystals in Group-Brazil-for sale $200.00 |
|
|
Black Licorice Necklace by Touchstone Crystal- Member of the Swarovski Group $0.99 |
|
|
Black Licorice Bracelet by Touchstone Crystal- Member of the Swarovski Group $0.99 |
|
|
60S GIRL GROUP POP SPECTOR LONDON THE CRYSTALS HE’S SURE THE BOY I LOVE PIC/SLE $18.37 |
|
|
SWAROVSKI SILVER CRYSTAL JADE-LOVLOTS THEME GROUP L/ED $151.30 |
|
|
21 GRAM SHINY PINK RUBELLITE TOURMALINE CRYSTAL GROUP, CORONEL MURTA, BRAZIL $325.00 |
|
|
Electron Paramagnetic Resonance Crystals Field Lattice Transition Group Ions $49.95 |
|
|
107g,AZURITE group w/MALACHITE crystals specimen $4.99 |
|
|
Group Of 200+ HF Radio Crystals Fits Collins KWM & S-line $55.00 |
|
|
NEW Vendor Development Group TRS45GF Crystal River Gas Fire Pit FREE SHIP $789.25 |
|
|
SHINY OLDTIME TOURMALINE CRYSTAL GROUP, ERONGO, NAMIBIA $65.00 |
|
|
HUGE SPARKLY CASTLE QUARTZ CRYSTAL GROUP w BLUE GREEN FLUORITE $95.00 |
|
|
Xceptional 5.4″BlueGreen HEULANDITE Crystal Group-India $350.00 |
|
|
CB Radio Crystal 2036 – 26.6200 MHZ CH-10R B GROUP $4.00 |
|
|
The Eight Crystal Alliances By Group of 5 (COR) $28.24 |
|
|
GIQ- Growth Interference Quartz Crystal Group Large PC $38.99 |
|
|
Gemmy Creamy Calcite Crystals Group $14.44 |
|
|
CB Radio Crystal 2748 – 28.7750 MHZ CH-14R F GROUP $4.00 |
|
|
BRILLIANT RED VANADINITE CRYSTAL GROUP $28.99 |
|
|
CB or Ham Radio Crystal 2352 – 33.8200 MHZ CH-15R XL GROUP $1.99 |
|
|
” Black Quartz” Crystal Group Of the Lowville Quartz Locality…New Find! $42.00 |
|
|
LOU CRYSTAL & GROUP: Dreaming Of An Angel $40.00 |
|
|
CRYSTAL TONES: A Girl I Love (rare vocal groups 45) $350.00 |
|
|
BEAUTIFUL WATERFORD AND CRYSTAL GROUPING FOR ONE PRICE $75.00 |
|
|
Junk Drawer With Group Of Old Chandelier Crystals – Lot # 1 $5.50 |
|
|
Junk Drawer With Group Of Old Chandelier Crystals – Lot # 2 $5.50 |
|
|
Junk Drawer With Group Of Old Chandelier Crystals – Lot # 3 $5.50 |
|
|
Junk Drawer With Group Of Old Chandelier Crystals with some issues – Lot # 4 $0.99 |
|
|
Crystal Embellishments 22 mm CLEAR in groups of 100 $13.00 |
|
|
Group of 2 Crystals and 1 Polished Gemstone $100.00 |
|
|
Bright Calcite Crystal Group !! $15.29 |
|
|
The Best of the Crystals [ABKCO] by Crystals (Girl Group) (The) (CD, Sep-1992… $18.00 |
|
|
Bright Sparkly Gemmy White Quartz Crystal Group $17.99 |
|
|
9.0″ Brilliant Gemmy ELESTIAL SMOKY QUARTZ Crystal Group+Matrix Brazil-for sale $400.00 |
|
|
QUARTZ CRYSTAL SMALL GROUP OF 5 $3.99 |
|
|
CB Radio Crystal 1876 – 27.2450 MHZ CH-25T A GROUP $4.00 |
|
|
Top Quality Tabular QUARTZ Crystal Group – Arkansas – Cabinet size $74.00 |
|
|
Indiana Jones Kingdom of the Crystal Skull Group Poster $9.99 |
|
|
A GROUP OF SIX COLLECTIBLE PIECES CRYSTAL POTTERY AND DECORATIVE FIGURES $19.00 |
|
|
HEMATITE CRYSTAL GROUP Buckskin Mountains Arizona $7.95 |
|
|
The Crystals 45 Then He Kissed Me / Brother Julius Philles 115 60s Girl Group $3.99 |
|
|
Italian Leaded Crystal Green and Clear Decanter Cristallerie MA.VI Group $26.00 |
|
|
JUICY GEM GRADE DANBURITE CRYSTAL GROUP CLASSIC CHARCAS MEXICO – NO RESERVE! $9.99 |
|
|
FINE FLUORESCENT RARE BENITOITE CRYSTAL GROUP – NO RESERVE! $9.99 |
|
|
GROUP LOT OF 5 BLADED HEMATITE WITH QUARTZ CRYSTALS , Planet, AZ. #SM136 $3.50 |
|
|
LARGE COMPLEX RED TO VIOLET SPINEL CRYSTAL GROUP VIETNAM – NO RESERVE!!! $5.99 |
|
|
THUNDER BAY ONTARIO CANADA CRYSTAL SILVER SPECIMEN GROUP – NO RESERVE!! $11.50 |
|
|
EXCELLENT LARGE FLUORESCENT BENITOITE CRYSTAL GROUP WITH JOAQUINITE – NO RESERVE $9.99 |
|
|
EXQUISITE OLD TIME C&H MINE MICHIGAN CRYSTAL SILVER GROUP – NO RESERVE!!! $11.50 |
|
|
LARGE 6 INCH VERY FINE GREEN PHANTOM SELENITE CRYSTAL GROUP $11.65 |
|
|
POLYLITHIONITE Crystal GROUP Fine Mineral Specimen MSH $70.00 |
|
|
EUDIDYMITE SERANDITE KUPLETSKITE Crystal GROUP Fine Mineral Specimen MSH $95.00 |
|
|
PRINCESS HOUSE CRYSTAL 5-PIECE GROUPING $15.00 |
|
|
SPECTACULAR VERY FINE ORANGE TO WHITE BARITE CRYSTAL GROUPING $1.50 |
|
|
144 SS20 Swarovski Flatback Crystal Rhinestone Group A $10.50 |
|
|
144 SS20 Swarovski Flatback Crystal Rhinestone Group A $11.50 |
|
|
144 SS20 Swarovski Flatback Crystal Rhinestone Group A $11.50 |
|
|
144 SS20 Swarovski Flatback Crystal Rhinestone Group A $11.50 |
|
|
144 SS20 Swarovski Flatback Crystal Rhinestone Group A $11.50 |
|
|
144 SS20 Swarovski Flatback Crystal Rhinestone Group A $11.50 |
|
|
144 SS20 Swarovski Flatback Crystal Rhinestone Group A $11.50 |
|
|
144 SS20 Swarovski Flatback Crystal Rhinestone Group A $11.50 |
|
|
144 SS20 Swarovski Flatback Crystal Rhinestone Group A $11.50 |
|
|
144 SS20 Swarovski Flatback Crystal Rhinestone Group A $11.50 |
|
|
144 SS20 Swarovski Flatback Crystal Rhinestone Group A $11.50 |
|
|
144 SS20 Swarovski Flatback Crystal Rhinestone Group A $11.50 |
|
|
144 SS20 Swarovski Flatback Crystal Rhinestone Group A $11.50 |
|
|
144 SS20 Swarovski Flatback Crystal Rhinestone Group A $11.50 |