Parameter Formula

[rlporter]

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

 

[rosalindr]

You should use < instead of = for your date.

Roz

 

[rlporter]

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.

 

[dgillz]

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

http://www.trianglepartners.com

 

[rlporter]

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

 

[synapsevampire]

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