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:
I am using SAP Crystal Reports 14.
Thanks a lot!