Version7 Linking table with date detail to table with bi-weekly data

[modglin]

I have a table that I am trying to link that has detailed information by date for each location. I have another table that has information by employee by location by pay period. How do I group the dates in the first table so that the dates are grouped would have the same ending pay period date? (ex: Dec 28 - Jan 10 would be the detailed information to tie to the date of Jan 10 on the other report.

If I create a sub report in Crystal, can I use the total from the sub report in a formula using a total from the original report?

 

[kenhamady]

To group by pay period create a formula like the following to use as your group field:

Truncate( ({YourDate}- Date(2000,12,27) )/14)
* 14 + Date(2000,12,27) + 14

I think you could use any Wednesday in place of 12/27.

You can bring back the value from a subreport if you use a shared variable (versions 7 and 8).

Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)