Placing A Parameter 2

[BoeingSK]

Sorry for the lack of Knowledge, this is my first time using a parameter field. I have set it up to choose a date range but I don't know where to place it so it works.


Up and Coming Technical Guy

 

[Madawc]

A typical parameter date range has a start and end date, defined as dates. In Report > Selection > Record, put a test

{record.date} in [?StartDate to ?EndDate]

Display it with something like

 "DAte ranged from " & ToText(?StartDate, "dd MM yyy") & " to " &  ToText(?EndDate, "dd MM yyy")

Fancier options are possible, using the DateAdd and DatePart functions. Take a look in Help.

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.


Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[BoeingSK]

Sorry Crystal XI,

I HAVE ENTERED
{TKT_HDR.ENTER_DATE} in [?StartDate to ?EndDate]
and it gave me an error message

A number,currency amount, boolean, date,time-date, or string is expected here.

I have all of the records pulling for the last two years, IU want the users to be able to selct their own ranges as needed.

Up and Coming Technical Guy

 

[Madawc]

Are these all date format?

Have you set up the correct parameters?

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[BoeingSK]

Yes it is a date time field, I have set the parameter where it shows the calendar to choose the dates you want. When i select a date range the reports stays the same it doesn't reduce to only the range. The parameter is set as follows:
Name: Month Date Range

Type: Date

List of Values : static

Value Field : Blank

Description Field : Blank

Options

Prompt text: Enter Month Range

Prompt with Description: False

Default Value:

Allow Custom Values: True

Allow Multiple values: False

Allow Discrete Values: False

Allow Range Values: True

Start :

End :


Up and Coming Technical Guy

 

[Madawc]

Is enter date in date format? Do the parameters display OK? (Comment out the select to test this.) You can also test using >= and <=, greater/equal and less/equal, easier format.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[BoeingSK]

eNTER DATE IS A DATE TIME FIELD, I have format it to only show date on the report. But It pulls date and time through the table.

Up and Coming Technical Guy

 

[lbass]

Go to report->selection formula->record and enter:

{TKT_HDR.ENTER_DATE} = {?Month Date Range}

Select the parameter from your field list instead of typing it in to make sure it matches.

-LB

 

[BoeingSK]

Amazing, That worked , I have a long way to go on learning these parameters. Know of any tutorials or references on parameters.

Up and Coming Technical Guy