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
|
|||
|
|||
Charts on a Report
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 |
Thread Tools | |
Display Modes | |
|
|