Record Selection based on a Parameter Table in the DB

[jsteff]

I have a multi-record table that contains:
Report Key Code (5 num)
StartDate (date/time)
EndDate(date/time)

The DB app prompts the user to enter a starting and ending date for the report.

I have a Crystal Rpt that is supposed to filter the JobDate based on the proper report key THEN use the start/end dates it finds in that row.

I have added the ReportKey table twice to the report. Then I linked the JobDate once to the StartDate AND I linked the JobDate once to the EndDate. I use the following selection criteria as a formula in the Select Expert.
I do not get any results.
{ReportKey1.AcctNo}=99991 and
{ReportKey2.AcctNo}=99991 and
{job.jobdate}<={ReportKey1.EntDate} and
{job.jobdate} >={ReportKey2.ChngDate}

Any Ideas?????

 

[synapsevampire]

Check the Database->Show SQL Query and examine the SQL being passed. Post it here if you still have problems.

And remove the:

{ReportKey1.AcctNo}=99991 and
{ReportKey2.AcctNo}=99991 and

until you get the date portion functioning.

-k