Search results for query: *

Hi ntbs2012, I work with Streamline frequently, let me know if I can be of assistance. Thanks

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...

@SkipVaught: I've tried this idea, of using the MATCH() function in order to be able to pick out matches, and then resort them afterwords. @xlbo: Some of the data is from database, the other lists are maintained in excel which is why I can't always go the SQL Query route. I've had exactly the...

@Gruuuu They are not data points. the "lists" are generally records of information from two different locations. For instance, one such occasion was a list of Product ID's from our system with descriptions and other relevant information, and a second list with Product ID's and pricing...

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...

Thanks for the reply, but I'm not sure how to do what you've mentioned. Can you please explain the steps to me and what the correct settings should be? Thanks, Narmi

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...

Thank you so much curlycord! I will try this tonight and report back

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...

I haven't tried that type of query, primarily because I only manage the databsae by default (there's no one else here that can do it) and I am very new at it. I'm guessing I'll have to join all the lists and sort them and I'll get similar records on top of one another instead of beside each other.

@mintjulep The problem with that Idea is that the records are not entirely accurate. For instance, I have the name of the customer in all three lists but in one of the lists the fax number is wrong. Technically, it will be identified as a unique record when it's not. I want to identify based...

I already have the lists in verticle format, that's not really the issue, I want the records to line up and I want spaces between the records to fill in any gaps in the data.

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 just tried it. It was because the workbook was shared. Thanks again people.

It is a shared file, I'll try "un-sharing" it. And yes, I've selected cells first :)

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...

Thanks! I tried it out and it worked perfectly.

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...