If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating a Graph in a report...
Hello,
I'm creating a graph on my report. To do this I'm creating a Microsoft 2000 Graph Object. The problem I'm having is I get the same graph for every record in my query. I know I'm getting different records each page as I print the values at the top of the page But the graph never changes! Using the properties of the Graph object I tried using the "Link Child Fields" and "Link Master Fields" to facilitate the changing of records but I get a message - "Cant build a link between unbound forms" Any ideas? Thanks in advance Andy |
#2
|
|||
|
|||
Creating a Graph in a report...
I assume you get the message when you click on the builder ('...') control on the link child/master property.
Just type in the linking fields, don't bother trying to use the builder. Might also help to have a hidden textbox in the detail containing the linking field. Additionally type this code in the Print event of the group that holds the chart: Private Sub WHATEVER_GROUP_THE_CHART_IS_IN_Print(Cancel As Integer, PrintCount As Integer) On Error Resume Next Dim objGraph As Object Set objGraph = Me.NAME_OF_GRAPH_OBJECT.Object objGraph.Refresh DoEvents Set objGraph = Nothing End Sub Basil ----- wrote: ----- Hello, I'm creating a graph on my report. To do this I'm creating a Microsoft 2000 Graph Object. The problem I'm having is I get the same graph for every record in my query. I know I'm getting different records each page as I print the values at the top of the page But the graph never changes! Using the properties of the Graph object I tried using the "Link Child Fields" and "Link Master Fields" to facilitate the changing of records but I get a message - "Cant build a link between unbound forms" Any ideas? Thanks in advance Andy |
#3
|
|||
|
|||
Creating a Graph in a report...
THANK YOU BASIL!
-----Original Message----- I assume you get the message when you click on the builder ('...') control on the link child/master property. Just type in the linking fields, don't bother trying to use the builder. Might also help to have a hidden textbox in the detail containing the linking field. Additionally type this code in the Print event of the group that holds the chart: Private Sub WHATEVER_GROUP_THE_CHART_IS_IN_Print(Cancel As Integer, PrintCount As Integer) On Error Resume Next Dim objGraph As Object Set objGraph = Me.NAME_OF_GRAPH_OBJECT.Object objGraph.Refresh DoEvents Set objGraph = Nothing End Sub Basil ----- wrote: ---- - Hello, I'm creating a graph on my report. To do this I'm creating a Microsoft 2000 Graph Object. The problem I'm having is I get the same graph for every record in my query. I know I'm getting different records each page as I print the values at the top of the page But the graph never changes! Using the properties of the Graph object I tried using the "Link Child Fields" and "Link Master Fields" to facilitate the changing of records but I get a message - "Cant build a link between unbound forms" Any ideas? Thanks in advance Andy . |
Thread Tools | |
Display Modes | |
|
|