Adhoc Parameter Display

[pwomack]

I have a report that uses an adhoc parameter. I want to display the value of the parameter in the report heading.

I created a data row variable named "CompletionDateRange" and set its value like this:

CompletionDateRange = v_ProjectList_ActualProjectComp

v_ProjectList_ActualProjectComp is the name of the parameter I see when I open the parameters editor by selecting the Tools...Parameters... menu.

What I see in the CompletionDateRange text control in the report heading is the value of the first CompletionDate from the database record and not the date range parameter I entered (e.g., 01/01/2007-12/31/2007).

How can I get the adhoc parameter value to display in the report heading?

 

[ASG0856]

forget the data row variable named "CompletionDateRange" and create a text box whose VALUEXP = v_ProjectList_ActualProjectComp