Automated Titles for Parameter Queries

  • Thread starter Thread starter K. Georgiadis
  • Start date Start date
K

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?
 
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.
 
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
 
Back
Top