Report Problems

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

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
 
First of all, consider dumping your parameter/prompt query in favor of
pulling the criteria values from text boxes on forms. Your criteria woudl
then be something like:
Between Forms!frmDates!txtStart and Forms!frmDates!txtStop
You can then reference Forms!frmDates!txtStart and Forms!frmDates!txtStop in
text boxes on your report.

It makes perfect sense that you would have 22 copies of your chart if it is
in the detail section of a report with 22 records.

To set the order of values in your chart, change the Row Source property of
the Chart Control.
 
Back
Top