Solved Insert Blank pages (seperator sheet) in report (1 Viewer)

Jimal

Member
Local time
Tomorrow, 03:01
Joined
Sep 29, 2020
Messages
60
Hello lifesavers..

I have generated a report for the list of enrolled students in a college successfully.. I have grouped the results based on category of enrollment Eg, Mechanical, Civil, Electrical, computer science, electronics and so on..
results are coming properly.. what I would require is a blank sheet at the beginning of every department (with the name of department in it) so that this sheet will act like a separator sheet between each department results..

any help would be appreciated..

regards
 

mike60smart

Registered User.
Local time
Today, 21:31
Joined
Aug 6, 2017
Messages
1,899
Hi Jima
Add a Group Footer and then in the Footer place 2 Page Breaks with a slight gap between each one
 

Jimal

Member
Local time
Tomorrow, 03:01
Joined
Sep 29, 2020
Messages
60
hello lifesavers...
I tried something by luck and it worked..... a Simple page break at the footer... ppphhhhh

however I would still need ur help to print the GROUP NAME on that blank page,,,,please
 

Jimal

Member
Local time
Tomorrow, 03:01
Joined
Sep 29, 2020
Messages
60
hi @mike60smart ..just posted my reply,,,,ya that's wt I did.

BTW any ideas on printing the group name in that blank page??
 

mike60smart

Registered User.
Local time
Today, 21:31
Joined
Aug 6, 2017
Messages
1,899
Add an Unbound Control and then in the Control Source type =[NameofyourGroupControl]
 

Jimal

Member
Local time
Tomorrow, 03:01
Joined
Sep 29, 2020
Messages
60
@mike60smart pls accept my ignorance....BTW where to add this unbound control...
at the footer?? ..
 

mike60smart

Registered User.
Local time
Today, 21:31
Joined
Aug 6, 2017
Messages
1,899
........Page Break
[=NameofGroupControl]
........Page Break
 

Jimal

Member
Local time
Tomorrow, 03:01
Joined
Sep 29, 2020
Messages
60
@mike60smart .. thank you... it does works
I tried one more method and it met my requirement
add name of groupcontrol in the GROUP HEADER
and then pagebreak
(of course force new page at footer)
 

Users who are viewing this thread

Top Bottom