Bi-Weekly Cross Tab Report

[TEM3]

I am using the following formula to select records for a start of the month to current date cross tab report:

({ALL_ASSIGNMENTS.Date Assigned} in date(year(currentdate),month(currentdate), 01) to currentdate)

Now I need to provide a bi-weekly report that will go from Saturday through the end of the second Friday.

Suggestions please??

 

[TEM3]

Never mind on the above. It was a stupid question really. I will just do parameter fields for the bi-weekly date range. What I really needed was a formula for year to date, which I modified from the monthly formula above.

But now I want to combine the two cross tabs, based on different selection criteria, into a side by side report. Do I need to just do two reports and combine them with a sub-report, or is there a way to do two cross tabs in the same report with different selection criteria??