Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameter Formula

Status
Not open for further replies.

rlporter

Programmer
Joined
Sep 7, 2003
Messages
24
Location
US
I am trying to create a report with 2 parameters.
1. Date
2. Class

I have tried this using the select expert with no luck.

{Employee_stc.STCDate} = {?Date} and
{Employee_stc.Class} LIKE {?Class_Name}

I actually need the report to show all students that have taken a class prior to the entered date. I was trying to get a single date to work above.

Thanks from a begginer.

rlporter
 
You should use < instead of = for your date.

Roz
 
I want the data in the report to be on or before the entered date.

I got each of the formula's working, one at a time, but I can't seem to get them working together.
 
Why are you using &quot;like&quot; in the second line of your fomula?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
 
As a begginer I am trying different things in an attempt to get it all to work. The right code is why I placed the question here.

rlporter
 
Go in to the record selection formula (Report->Edit Selection Formula->Record - rather than the select expert) and use:
(
{Employee_stc.STCDate} = {?Date}
)
and
(
{Employee_stc.Class} = {?Class_Name}
)

If you're going to enter just the first part of the class name, then use:

(
{Employee_stc.STCDate} = {?Date}
)
and
(
{Employee_stc.Class} like {?Class_Name}+&quot;*&quot;
)

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top