Charts on a Report
I am using Windows 7, Access 2007 and Report View.
I used the Report Wizard to add [SignInDte] and [TotalStudents]
I used the rectangle control to add the rectangle bar to the Detail Section
of the Report.
I am sorry but I don't know how to get to the debug window?
"Duane Hookom" wrote:
What Access version and what view when you "run the report"?
What do you see if you print the value to the debug window?
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
debug.Print "Width: " & ([TotalStudents] / 100) * (1440 * 4)
rctBar.Width = ([TotalStudents] / 100) * (1440 * 4)
End Sub
Is TotalStudents a text box in the detail section?
--
Duane Hookom
MS Access MVP
"Summing multiple fields on a form"
t.com wrote in message
...
I want to display a chart on a report. I created a query named
qryJanGraph,
which contains 2 fields [SignInDte]& the other is a calculated field name
[TotalStudents]. The expression used in the query for the calc field
[TotalStudents] was sum([Current]+[New]). I placed the 2 fields on the
report
in the Detail Section, along with a Rectangle Bar and added an Event
Procedure in OnFormat. It reads
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
rctBar.Width = ([TotalStudents] / 100) * (1440 * 4)
End Sub
Whn I run the report the Bars for all the numbers are the same...HELP
|