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
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