Search results for query: *

Hi LB, I've started to apply the instructions you gave to my report, but our items are stored as numbers and I keep getting an error when creating the second formula: if {table.item} = {?selecteditems} then {table.item} else {@null} it tells me "A Number is Required Here

Yes! that seems to be a better way to explain it.

LB, thanks that seems to work. Now I'm running into another issue with a second report I'm working on. In this case I'm looking for customers who purchased three or more specific items and nothing else. Again I seem to be running into the same problem where Crystal reports will bring in...

Hi, The suggestion above worked somewhat, however in some cases the data repeats itself and is counted as 2 but it's the same exact information. Any other ideas? Thanks again.

Hi, If this has already been answered I apologize, couldn't find an answer while doing a search. I'm trying to show customers that have purchased a specific item from us and never purchased anything else. but the report keeps showing ALL the customers that purchased the item even if they have...

Thank you that worked great!

I'm sorry I'm still a little unclear with how to use the above formulas. An example of our data is this: studentname classenddate John 3/22/06 Tom 3/29/06 Joan 4/22/06 Nancy 4/05/06 Todays date is 2/22/06 and the report I'm trying to write needs...

We are a training provider and we need to be able to generate a list of students that are six weeks out from completing their class. Our database has a field that is called "class end date", how can that be used to pull a list of those students who are six weeks away from completing? is that...

Thank you very much!

Hi, I'm wondering if it's possible in crystal 11 to count the number of weeks or month between two dates. Would this be done in a formula or does crystal have a built in funtion for something like this? Thanks, Joe

Shetlandbob, Thanks for the suggestion, but I'm not really sure how to create a "look back over" section or how to modify the current formula to do such. Joe

Yes, the only exception is that once someone is determined eligible, the formula need to reset back to "not eligible" until the next 90 days.

Hi Dave, I'm sorry about not being clear about the cells/rows. Let me try this: A B C 1 WEEK ENDING SICK USED BONUS DAY 2 1/7/2005 0 Not Eligible 3 1/14/2005 0 Not Eligible 4 1/21/2005 0 Not...

Ok thanks. Here is an example: WEEK ENDING SICK USED BONUS DAY 1/7/2005 0 Not Eligible 1/14/2005 0 Not Eligible 1/21/2005 0 Not Eligible 1/28/2005 0 Not Eligible TOTAL JAN 0 Not Eligible 2/4/2005 0 Not Eligible...

Yes R23 to R42 checks to see whether someone has used any sick time. If they have, the value would be greater than 0 and they would get "not eligible" A23 contains the week ending date. This will change from week to week. A24, A25, etc. Is it possible to attach a file on here? It would be...

Hi, Our HR department has released a new policy for our employees that states if no sick days are used within a 90 day period they receive one personal day to be used within 30 days. So I created an excel spreadsheet to keep track of this, but I’m running into some trouble with my IF...

Yes! I'm sorry I wasn't familiar enough with excel to figure that out on my own, but thank you for your help! Joe

Thank you bluedragon2. After a little bit of playing around with VLookup I think I've figured it out. Again, big thanks! Joe

I'm sorry to keep posting regarding the same issue; the formula is finally working up to a point...

John, Thank you very much, I think you solved it for me! Joe