record selection based on dates

[ABSquare]

Hi,
I am working on a crosstab report with the order date (current year MTD) in rows. Now I would like to add the previous year month to date values underneath it in the crosstab with the percentage difference.

In my record selection criteria, I have given the following condition and still it is not working

{Acquisition.Order Date (mm/dd/yyyy} in monthtodate
or
{Acquisition.Order Date (mm/dd/yyyy} in lastyearMTD

I would appreciate if somebody could help me with the logic or formula.

Thanks in advance

 

[satinsilhouette]

Your record selection doesn't know what to do, you are asking for Month To Date and you are asking for Last Year MTD, record selection cannot do both.

There are several suggestions here. You actually need 2 queries to pull this off, a subreport for the LYMTD would be one.

A manual crosstab would probably work best in this situation.

An SQL View on the database to do all this for you ahead of CR would be another.

 

[synapsevampire]

The record selection can do both.

What's your Crystal version and the database/connectivity used?

Post what's in the Database->Show SQL Query if applicable.

-k