Recent content by hwwagen

dgillz, I followed your suggestion and added the formula to the report on each detail line. It accurately displayed true or false for the displayed dates. However, when I put this same formula into the record selection formula I have no records returned. When I change the record selection to...

This post is related to my post of yesterday regarding Record Selections not working. I've done some more investigation and it seems to be related to date issues betwwen FoxPro and the newer CR. In the very old version of CR this worked, but CR 2008 seems to be handling dates in some other...

I have done some more investigation into this. Removing the record selection formula returns all dates and they look like valid dates. Changing the formula to be {timesheet.date} < CurrentDate returns records (that appear to be the same) with the highest date being in 1899! There seems to be...

Crystal does report that the field is a date field. Removing the selection formula returns all records.

I have a report that was created in a very old version of Crystal Reports that used a record selection of: {timesheet.date} in LastFullMonth This worked well, but since upgrading to Crystal Reports 2008 it no longer returns any records. The SQL generated by this is: SELECT...

No, I don't have "Show all sections in Drill Down" turned on. If I only use global variables in the printing pass is there another method to build an array before that pass and subsequently using it in the printing pass?

Thank you. That was exactly what the problem was.

The following code displays the error message "A date is required here" when running at the marked location. This is a date field and I don't readily see anything wrong with the code. I would appreciate another set of eyes to examine it or someone with more experience to tell me what I've done...

Thank you for your response. I hope the following clarifies my situation. In my report header I have a function called BuildArrays that runs while reading records. This function accumulates all inventory levels. There are a number of groups in this report, but the primary ones of concern...

I'm using Crystal Reports 8.5 and have had some difficulty debugging why drill down information is different than the group info. I now see what happens, but don't see how to fix it. While reading records I build an array that sums the amount of inventory in stock for each item. While...