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
|
|||
|
|||
Report Problems
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 |
#2
|
|||
|
|||
Report Problems
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. -- Duane Hookom MS Access MVP -- "Frank" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|