Parameter printed as report header?? POSSIBLE???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report based on a crosstab query. In the query, I have issues
(1/1/04, 2/1/04, 3/1/04, etc.) - then the crosstab tabulates them and names
them Jan, Feb, Mar, etc. When running the query, I have set the following
parameter/prompt:

Between [Type the beginning date] And [Type the ending date]

Usually, I'll enter the prompts within a year's period, such as: beginning
(1/1/04) and ending (12/31/04)

What I'd like is for whatever is entered in the parameter/prompt to be
displayed on the heading of the report, but I don't know how to do this.

It seems like I've seen this addressed before, but I could be mistaken. Can
someone give me some advice?

THANKS!!

Teri
 
I have a report based on a crosstab query. In the query, I have issues
(1/1/04, 2/1/04, 3/1/04, etc.) - then the crosstab tabulates them and names
them Jan, Feb, Mar, etc. When running the query, I have set the following
parameter/prompt:

Between [Type the beginning date] And [Type the ending date]

Usually, I'll enter the prompts within a year's period, such as: beginning
(1/1/04) and ending (12/31/04)

What I'd like is for whatever is entered in the parameter/prompt to be
displayed on the heading of the report, but I don't know how to do this.

It seems like I've seen this addressed before, but I could be mistaken. Can
someone give me some advice?

THANKS!!

Teri
Click to expand...

In the Report header, add an unbound control.
Set it's control source to:

="For Sales between " & [Type the beginning date] & "And " & [Type
the ending date]

The text within the brackets must be identical to the bracketed text
in the query.
 
THANKS FRED!!!

fredg said:
I have a report based on a crosstab query. In the query, I have issues
(1/1/04, 2/1/04, 3/1/04, etc.) - then the crosstab tabulates them and names
them Jan, Feb, Mar, etc. When running the query, I have set the following
parameter/prompt:

Between [Type the beginning date] And [Type the ending date]

Usually, I'll enter the prompts within a year's period, such as: beginning
(1/1/04) and ending (12/31/04)

What I'd like is for whatever is entered in the parameter/prompt to be
displayed on the heading of the report, but I don't know how to do this.

It seems like I've seen this addressed before, but I could be mistaken. Can
someone give me some advice?

THANKS!!

Teri
Click to expand...

In the Report header, add an unbound control.
Set it's control source to:

="For Sales between " & [Type the beginning date] & "And " & [Type
the ending date]

The text within the brackets must be identical to the bracketed text
in the query.
Click to expand...
 
Back
Top