Page break in a chart report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi ,

Is it possible to insert a page break into a chart report? My report
contains too many entries for the one page, even in a landscape format. I
would like to break it down in several page.
Much help appreciated.
Chris1
 
Hi,
I have done this but it still does not work, the page break works on the
report all right but the data on the chart is not being split into multiple
pages which is what I am looking for. It seems that the page break should be
on the chart itself, tried that one but would not let me do it.
Is there a way to restrict the number of entries on the chart?
Thanks for your help,
Chris1.
 
Hi,

My Chart object is based on a query. I have used the chart wizard to do this.
Thanks a lot for your help.
Chris1
 
A typical chart looks like an image. I can't comprehend why you would want
to place a page break somewhere in a chart.
 
Hi - I understand what Chris is talking about. I use several lateral bar
graphs that are auto generated by the parameters I enter into the query (for
example, y-axis is people, and x-axis is revenue). If there are less than 12
y-axis categories (for a small dept) the graph is fine, but sometimes my
query returns 20 or more y-axis categories (large dept) which all need to be
displayed individually (i.e. no rolling them up into groups), and needless to
say, packed into a single one page graph, is illegible. I'm interested in
breaking this graph out over more than one page but haven't found anything
either. It would be nice if the graph could limit the number of y-categories
listed per page and know to automatically break to the next page and to
continue graphing the rest of the y-categories. Any suggestions? Thanks in
advance for your help.
 
You might want to try create a horizontal bar without using a graph control.
I created a report based on the top 50 records from the OrderDetails table
in Northwind.mdb.
Text box in Report Header section:
Name: txtMaxQty
Control Source: =Max([Quantity])
Text box in the detail section:
Name: txtQuantity
Control Source: [Quantity]
Left: 0"
Back Style: Normal
Special Effect: Shadowed
Back Color: 13434828
Border Color: 6723891

Code in the On Format event of the detail section:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.txtQuantity.Width = _
(Me.txtQuantity / Me.txtMaxQty * Me.Width) _
- Me.txtQuantity.Left
End Sub
 
Back
Top