Skip to Content
0
Former Member
Apr 11, 2014 at 04:03 PM

Crystal Reports: How to print Details subsection once per page?

1450 Views

Hi all,

I inherited a report with Group Header and multiple subsections in Details section.

Currently captions for Details D are printed in Group Header. This is not very nice because there is data in subsections Details A to Details C, so it is not obvious to which data the captions refer to. Here is a rough report layout:

Group Header Item Description UOM

Details A Project items used in

Details D Bolts Each

Details D Nails Lb

My idea was to create new Details subsection right above Details D and move captions there. So the task would be to print Details subsection with captions once per page.

To do that I created a formula that concatenates a caption with PageNumber. Then I applied Suppress If Duplicated to this formula. However, it prints a concatenated heading (Item Description 1) on first page only.


Trying to troubleshoot this behaviour, I created a new report that consists of a single column, placed PageNumber on its Details section, and applied Suppress If Duplicated to PageNumber. It worked fine. But when I create subsections within Details section, it starts behaving the same wrong way: prints PageNumber on first page only. The only case when it works fine is when I put PageNumber into last of Details subsections. But it does not suit me.

Questions:

  1. Can my current approach with Suppress If Duplicated eventually work?
  2. Are there other ways to print Details subsection once per page?

I am using SAP Crystal Reports 14.

Thanks a lot!