Solved Insert Blank pages (seperator sheet) in report

[Jimal]

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]

Hi Jima
Add a Group Footer and then in the Footer place 2 Page Breaks with a slight gap between each one

 

[Jimal]

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]

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]

Add an Unbound Control and then in the Control Source type =[NameofyourGroupControl]

 

[Jimal]

@mike60smart pls accept my ignorance....BTW where to add this unbound control...
at the footer?? ..

 

[mike60smart]

@mike60smart pls accept my ignorance....BTW where to add this unbound control...
at the footer?? ..

Add the Control where you currently have your Page Break

 

[mike60smart]

........Page Break
[=NameofGroupControl]
........Page Break

 

[Jimal]

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

 

[mike60smart]

Glad to help