Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Labels in details repeat on next page

Status
Not open for further replies.

swiss2007

Technical User
Aug 13, 2007
92
US
I have 3 columns College, Year and programs and the data looks like

College Year Program
2005-2006 1styear Maths
Physics
English
Earth Science

2006-2007 2ndyear AB
CD
EF
GH
IJ
KL
MN
OP
QR

2007-2008 3rdyear AAA
BBB
CCC
DDD
EEE
FFF
GGG

The labels(Colleger,Year and Program) are not hard coded
and are dynamic which are directly driven from the database.


There are many details sections and each of it is suppressed in the
report using section expert and writing a formula like

IF({PCPT_FORMS;1.field_cd} <> 'QE0006B') THEN TRUE


Now I need to do 2 things.

1) Is there a way to repeat the dynamic header labels (College,Year and Program) on all the pages if the data spans more than one page.How do we accomplish this since the labels are placed in details section

2)If the data spans on more than one page, is there a way to show
Continued in the beginning of next page.


Expected output.

(Page 1)

College Year Program
2005-2006 1styear Maths
Physics
English
Earth Science

2006-2007 2ndyear AB
CD
EF




(Page 2)
College Year Program
Continued GH
IJ
KL
MN
OP
QR

2007-2008 3rdYear AAA
BBB
CCC
DDD
EEE
FFF
GGG
 
One correction, The label is not college but College Year.
Any help is appreciated,
Thanks
 
If the data is grouped, you should have the option to repeat the group header on each page. Or to suppress some of it, using
Code:
If InRepeatedGroupHeader ...

PS. It helps to give your Crystal version - 8, 8.5, 9, 10, 11, 2008 or whatever. Methods sometimes change between versions, and higher versions have extra options. In this case, it probably makes no difference.

[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP [yinyang]
 
Thanks Madawc for the reply but the problem is the data is not grouped.
 
If you put the header data into the detail section along with the other fields, how does it appear (with no section suppression)? Please show sample data (labeled).

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top