paramiter fields

[Guest_imported]

I have inserted a date paramiter field to capture a specific range of data. How can I have the range that I enter show up in the report header so people will know what the range of the dates were for the data. Thanks.

 

[dragonlair]

Mr. Potter
Any Parameter or any field for that matter can be added to any text field on the report. The first thing to do is to write a formula such as: "Date Range From " & {DateParameterFrom} & " To " {DateParameterTo}. Then insert this formula into your report where ever you wish. I hope that this helped. If not let me know and I will try again.

 

[Alincon2001]

If you use two parameters, start date and end date, you can just drag and drop them onto the report heading.
If you use only one parameter, with a range, it does not work - at least in v7.0

 

[EagerBeaver]

Create 2 parameters, one for start date and one for end date.

Then go to the select expert and create a new query.

Choose the date field that you want the report to report on, the value should be "is between" and then select the start date parameter and then the end date parameter.

so your query formula will look like this:

{Your_table.Your_field} in {?START DATE} to {?END DATE}

 

[MalcolmW]

If you are using a date range parameter, then to print the values for this parameter on the report, use the Minimum({?DateRangeParam}) and Maximum(({?DateRangeParam}) functions in a formula (or one formula for each) to extract the extremes of the range. Malcolm Wynden
I'm for sale at

http://wynden.net

malcolm@wynden.net