Search results for query: *

Hello all, I'm trying to design a report that lists items we have not sold in 6 months, and yet have stock of. I have three tables at play here, two that link to give me the sales data, and a third which has the inventory amount I need. I can very easily do this report to show stock of what...

Hello all, I frequently have to compare large sets of records from different data sources at work. I have done quite a bit of research and have not found an effective way to do this. I need to be able to match these lists (often exports from Crystal Reports) as follows: Original Data: List...

Hello all, I seem to have (another) little problem! When our receptionist is on the phone (ext 221) incoming calls go directly to voicemail instead of ringing the prescribed number of times before hitting the CCR tree. If any other extension is using the phone this does not happen...

Hello all, We seem to be having some really strange problems with our system and I don't quite have any idea where to start fixing the problem. I'll do my best to accurately describe the situation and problems below. We have a CCR tree setup such that one of the options allows you to leave a...

Hello all, I'm trying to create a report to measure sales of each product split up between quarters. I've created Current Year Quarter formulas for each of the 4 quarters which only count the sale of the product if it's part of that quarter (I was able to use the current year quarter formula...

Hello everyone, I have the super-fun duty of managing three databases that all have the same customer data in them. We have three divisions to our small company and each division has its own database. I've been here only a while and am noticing inconsistencies between the data in the different...

I'm trying to conditionally format a spreadsheet that my boss gave me to reflect products we carry and products that are special order items. For some reason, the conditional formatting option is greyed out. I've tried clearing all other formatting that may conflict with this. The file is in...

Hello, I'm a Crystal Newbie and have searched the forums and can't find a solution to my line numbering problem. I'm currently using this formula to calculate line numbers: WhilePrintingRecords; Global NumberVar RowNumber; RowNumber:=RowNumber +1; How do I get these numbers to reset for...