Automated Titles for Parameter Queries

[K. Georgiadis]

I run a parameter query where the value requested is a
date, e.g. 1/1/2000.

Is there any way to design the Report based on this query
so that the parameter value is automatically printed as
part of the report title?

 

[Les]

You can create a new column in your query that contains
the parameter date. Something like this:

InputDT:[Enter date]

Then, you can include InputDT as part of your report
headings.

 

[Patrick]

HI!!

What I would do in this situation is create a Gobal
variable and affect the date to it:

GlbDate="21/10/04" ' type: date or string
(from where you would get this date from)

then in the report's 'Open' event i would write this:

lblDate.Vaption=glbDate (lblDate= The report title label
name)
NOTICE. If it doesn't work with a Date type try the string
type.

I hope you see what I'm trying to do here...
So everytime you need to send this date of yours to the
report you just have to store-it in the Global Variable
and affect-it to the desired label on your report in
the 'Open' event of the report in question.

Hope this Helps!!
PAtrick