[AccessD] Page Break and SubReport

Charlotte Foust cfoust at infostatsystems.com
Wed Nov 19 17:46:15 CST 2003


Put it in the main report and set the pagebreak to Visible =  the
subreport's HasData property.

Charlotte Foust

-----Original Message-----
From: Susan Geller [mailto:sgeller at cce.umn.edu] 
Sent: Wednesday, November 19, 2003 2:31 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Page Break and SubReport


I have a report that has a subreport.  In the subreport there sometimes
is data and sometimes not.  When there is data, I want a page break and
then the subreport.  When there is not data, I want no page break and no
subreport.  When I put the pagebreak in the main report, I get a page
break regardless of what's in the subreport.  When I put it in the
subreport, I still get a page break even when the subreport doesn't show
because there is no data.  I've tried a couple of code manipulations
that look to see if there is no data and if there isn't set the
subreport to invisible, but that doesn't work.  Suggestions?

--Susan


Susan B. Geller
Office of Information Systems
College of Continuing Education
University of Minnesota
306 Wesbrook Hall
77 Pleasant Street SE
Minneapolis, MN 55455
Phone:  612-626-4785
Fax:  612-625-2568


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list