Using Sub Report values in the Record Selection

[QueTech]

Hi,

I am using Crytal 10 pulling data using OLE connection to SQL database on Windows XP workstation. I have a report the produces two shared datevars startdate and startplusgrace. Is it possible to drive my main report using these two shared datevars. I need to run these dates against my Period table. For example, Period.Calender_date>=startdate and
Period.Calender_date<=startplusgrace.

 

[synapsevampire]

You should at least be able to make the main the sub, and vice versa.

You might also eliminate the need for a subreport with either a SQL Server View, or use a Command object within a single report.

You should be able to join the period table and at least use a subquery in lieu of the subreport.

-k

 

[QueTech]

I have created a view using the two table I used to derive my date.
startdate changedate
Staff 1 1/01/2005 1/25/2005
Staff 1 1/01/2005 6/25/2005
Staff 1 1/01/2005 12/02/2005
Staff 2 4/01/2006 4/24/2006

How do I filter the records to the most recent changedate 12/02/2005.

Also after that is done how would I compare the two date to get the most recent. It is very obvious but I would check anyway.

Finally i need to add 7 or 14 day s to the date I get. Dependant on the changeresaon ( "New Employee" or " Updated Employee").