Report Problem

[wop0703]

I have created a chart report from a query. My chart looks fine. here is what I want to do. I have a field in my query called Period. I was to diplay the value in Period on my chart report at the top, in the report header of page header. Is this possible?

 

[KenHigg]

Are you kicking off the report from a form where you enter the period you want?

 

[wop0703]

Well, they enter a begin date and an end date. From those two dates they entered I created a new field called Period in which I capture the two dates they entered. I want to display Period at the top of my Chart Report.

 

[KenHigg]

I would think you could just reference the text box(s) on the form. On the report, in a text box:

= "Between " & forms!myFormName!myStartDateBox & " and " & forms!myFormName!myEndingDateBox

Would this work?

 

[wop0703]

It is not working.

 

[KenHigg]

Did you replace myFormName with your form name, etc...?

 

[wop0703]

yes, i think it may have something to do with trying it in a chart report. If i create a general report, it will work, but for some reason, in a chart report it is not working.

 

[KenHigg]

You may just have to do it outside of the chart control on the report, say just above it...

 

[wop0703]

Do you mean do it in the report header or page header? Because that is where I have been trying it and it is not working.

 

[KenHigg]

And it works fine as long as there is not a chart object in the report?

 

[wop0703]

well, in another report I created, it worked, but there was no chart in that one. If I take the chart out of the one i am working on now, there are no parameters set up.

 

[KenHigg]

You got me stumpted on this one... I'm still guessing it's something other than the chart object giving you the problem...

 

[wop0703]

Can I display the value of a field in my report if it is in the query that I used to create the report?

 

[KenHigg]

As long as the form is open, you should be able to use any field on the form in the report using something like:

forms!myForm!myTextBox

 

[VanRoekel.Clint]

Here is the text that I use in the page header on my report which contains a graph:

=Forms![Get Dates]![Start Date] & " - " & Forms![Get Dates]![End Date]

The form is named "Get Dates" and the fields in the form are "Start Date" and "End Date"

You need the square brackets if the name of your form or your field has a space in it.

The source query for the graph uses the same parameters from the form.