cornishteeth
Board Regular
- Joined
- Dec 6, 2002
- Messages
- 117
OK. I was a little vague on my last post, so a little
more in depth this time. I have a Report that contains a
chart. The chart is derived from a parameter query that
contains DATE, SumOfFootage, and EmployeeName. The
parameters come from the criteria in the Date field and
is Between [Start] And [Stop]. The chart is a bar graph
that contains EmployeeName on the Y-axis and SumOfFootage
on the X-axis. First question, how would I be able to
put the date range entered on the chart itself. I
attempted to put it on the report, but a few things went
wrong. First, #Name? kept appearing. I discovered the
record source was not set to my query. I changed it.
Then, I have a total of 22 of the same reports. Weird?(I
have 22 employees??) So, if I can make it to where it is
entered on the Chart itself or even on the report, that
would be delightful. Next, I want the names on the Y-
axis to go from the greatest value from the X-axis to the
least value. For example, if Bill had 100, Chuck had 2,
and Dean has 20, the chart would descend from Bill to
Dean to Chuck. Looked throughout the properties and
didn't seem to find it anywhere. Hope this is more in
detail. Thank you in advance for your help.
Frank
more in depth this time. I have a Report that contains a
chart. The chart is derived from a parameter query that
contains DATE, SumOfFootage, and EmployeeName. The
parameters come from the criteria in the Date field and
is Between [Start] And [Stop]. The chart is a bar graph
that contains EmployeeName on the Y-axis and SumOfFootage
on the X-axis. First question, how would I be able to
put the date range entered on the chart itself. I
attempted to put it on the report, but a few things went
wrong. First, #Name? kept appearing. I discovered the
record source was not set to my query. I changed it.
Then, I have a total of 22 of the same reports. Weird?(I
have 22 employees??) So, if I can make it to where it is
entered on the Chart itself or even on the report, that
would be delightful. Next, I want the names on the Y-
axis to go from the greatest value from the X-axis to the
least value. For example, if Bill had 100, Chuck had 2,
and Dean has 20, the chart would descend from Bill to
Dean to Chuck. Looked throughout the properties and
didn't seem to find it anywhere. Hope this is more in
detail. Thank you in advance for your help.
Frank