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
|
|||
|
|||
Parameter Problems
I'm having trouble displaying parameters in a report that has a chart. I'm
charting data from a querry, and want to display the parameters used in the report. Using the format [Parameter Name] is not working. It works for me in other reports that don't contain charts. What am I missing? |
#2
|
|||
|
|||
Parameter Problems
On Tue, 17 Jul 2007 15:02:03 -0700, Bill wrote:
I'm having trouble displaying parameters in a report that has a chart. I'm charting data from a querry, and want to display the parameters used in the report. Using the format [Parameter Name] is not working. It works for me in other reports that don't contain charts. What am I missing? Are you trying to have a chart label show something like this? "Sales for May 2003" With the date changing according to the query parameters? If a form is used to enter the parameter... Make sure the chart has a Title label. Code the Report section's Format event that the chart is placed in: Me!OLEUnbound0.ChartTitle.Text = "Sales for " & Format(Forms!frmDate!StartDate, "mmmm yyyy") Me!OleUnbound0.Refresh If just the query parameter prompt is used: Me!OLEUnbound0.ChartTitle.Text = "Sales for " & [Enter Date] Me!OLEUnbound0.Refresh where [Enter Date] is identical to the bracketed text in the query parameter. Change OLEUnbound0 to whatever the control name is of your chart control. Alternatively, you could simply place a label over an unused portion of the chart: LabelName.Caption = "Sales For " & [Enter Date] [Enter Date] being the query parameter prompt. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#3
|
|||
|
|||
Parameter Problems
Fredg, Thanks, but unfortunately, you lost me - I'm struggling through the basics of Access. I'm trying to do exactly what you guessed, and put a note on my report showing the date range that the data is from. Using a text box in a report without any chart works fine, but in a report created using the chart wizard, all I get is #Name? for the parameter [Enter Date]. Will using a form to define the parameters resolve this problem? Thanks again in advance, Bill |
Thread Tools | |
Display Modes | |
|
|