T
TC
I have a report with a line chart in the Detail section. When I open the
report the chart shows all of the data in one chart and all of the records
then show the same chart. For what ever reason it does not seem to be
recognizing the link child/master fields.
If I then open the design view and then open and close the SQL statement for
the graph and then go back to the print view all of the reports are perfect.
I have looked over all of the other posts here and I have not found the
solution yet. Here is the SQL statement that I put in the "On Print" of the
Details section.
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
On Error Resume Next
Dim objGraph As Object
Set objGraph = MeROP.Object
objGraph.Refresh
objGraph.Repaint
objGraph.Application.Update
DoEvents
Set objGraph = Nothing
End Sub
Thank you in advance for any help or suggestions.
report the chart shows all of the data in one chart and all of the records
then show the same chart. For what ever reason it does not seem to be
recognizing the link child/master fields.
If I then open the design view and then open and close the SQL statement for
the graph and then go back to the print view all of the reports are perfect.
I have looked over all of the other posts here and I have not found the
solution yet. Here is the SQL statement that I put in the "On Print" of the
Details section.
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
On Error Resume Next
Dim objGraph As Object
Set objGraph = MeROP.Object
objGraph.Refresh
objGraph.Repaint
objGraph.Application.Update
DoEvents
Set objGraph = Nothing
End Sub
Thank you in advance for any help or suggestions.