Crystal Web Rpts 8 and Date Ranges

[CartoonDog]

Hi gang. I am not concerned with performance, just getting the accurate results. My original report has a range of values that uses this selection criteria:

{CUST_ORDER_LINE.PROMISE_DATE} in {?Due Date}

?DueDate is a Date Range with no default values. The above report selection seems to work fine.

When I attempt to convert it to a web report, I didnt think that there was a way to pass a range value, so I pass two discrete Dates for the range and use the following selection criteria:

{CUST_ORDER_LINE.PROMISE_DATE} in ({?StartDate} to {?EndDate})

This produces a different result than the original report! Any ideas? Thanks

Cartoondog.

 

[synapsevampire]

Not sure why that is, you might try:

{CUST_ORDER_LINE.PROMISE_DATE} >= {?StartDate}
and
{CUST_ORDER_LINE.PROMISE_DATE} <= {?EndDate}

-k

 

[rosemaryl]

Dear Cartoondog,

The only reason I can think of that the results would be different is that when you set up a range formula you can set it to include/exclude start and include/exclude end of the range and that would account for the differences.

To see what is different, you could do a Database/Show SQL Query for both reports and see what is actually getting passed to the database for the date times and in addition you should look at the set up of the date range parameter for the include/exclude part.

regards,

ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762