Search results for query: *

Due to systems mergers from acquisitions, differences in how we handle customers with accounts versus customers without accounts and because we have a mailing address and ship to address to deal with a customer name or DBA (that's "doing business as" not database administrator!)could be be in...

I am using Crystal 11.5.8.826. The Purchasing portion [PurHdr] of our system uses a PO Number [PurHdr.Ponum] that is an 8-character string field and the Sales Order [OrdLin] system from the same vendor records the PO Number as a number field [OrdLin.Lpono]. I need to link the two table on PO...

I am using Crystal 11.5.8.826. I am creating a report to list all the contract pricing we have for customers. There are four different types that we use, each supported by a separate table. They are by Part, by Supplier, by Product Category and Master (which assigns everything for the master...

I am using Crystal 11.5.8.826 I have a report that allows the user to see which customers have special pricing for an item. There are parameters for Supplier and Part Number. The report then lists all customers who have special pricing where cntr_price.sup = {?Supplier} and cntr_price.part =...

I am using version 11.5.8.826. I have a list of customers that I would like to see on a report just showing total sales for the fiscal year to date (9/1 to 8/31). The list has 49 customers, but only 38 of them have sales so far this fiscal year. I entered the 49 customer numbers into the...

Our system has five bin location fields for recording where an item may be stocked in each store. At this time we only use up to three of these, but that could change at any time to go up to four or five. They are BINLOC1, BINLOC2, BINLOC3, BINLOC4 and BINLOC5. I need to be able to create...

I am creating a report that groups based off a formula, not a field. We have a Product Category field (two letters, such as AA) that every item is assigned. I am grouping off the first letter, derived by using Left(ProdCat,1), and then I use another formula to assign a description to this...

I am using Crystal 11.5.8.826 How can you force all possible Groups to appear on a report even if their value totals zero? I am working on a spreadsheet that will be populated by an export from Crystal Reports that will show by location the sales for each product category group for each...

I am using Crystal 11.5.8.826 I am creating a "Dead Stock" report that list everything that we are closing out company-wide. The report itself works flawlessly, save for one field. I need to list "Available Locations" that would show which location had it in stock (but not the total available...

I have created a vacation calendar using the "Create a calendar-style report" document by LBass. This is a very handy report. I used this report for 2009 data and it worked flawlessly. My question is: How do I roll it forward for the new year? I have updated the Calendar.xls file so that the...

I have a customer database where they have inserted a pair of asterisks in the Customer Last Name field if the customer has a resale certificate on file with us. This was done to make it easier for our counter staff to see at a glance that one was present. The customer's name will appear as...

I am trying to create a report that shows the number of sales each hour for each location. Unfortunately the system does not record the time of the sale, only the time that lines are added to a pick ticket....this will be "close enough" for our report. There are two related tables: OrdHdr...

I have a report that calculates the average days outstanding for each invoice. My report is grouped by customer ID and then by Due Date with the option set to "The section will be printed for each year." Now I want to compare from year to year (the total for the current year group vs the...

I am creating an Employee Phone Listing that I want to print with multiple "columns" of data so that it works down the left side and then wraps to the next column like a newspaper. We are a small enough organization that we will all fit on one page. I have my Page Layout set to Landscape and...

We use cycle counting for physical inventory. Each part number is assigned a three digit cycle count code where the first digit is the number of times the part is counted each year (1-4), the second digit is the month it is counted for the first time and the last digit is the week of the month...

Crystal Version 11.5.0.313 I am trying to create a Physical Inventory Count Sheet by inventory location (Bin #). Our system has five bins available for each part (BinLoc1 through BinLoc5). We only use up to BinLoc3 at this time, but may go to the 4 or 5 bin in the future.. Every part must...

I have created a dynamic cascading prompting in CR XI where the user first selects the Supplier (multiple selections allowed) and then selects the Part Number(s) for the selected Supplier(s). It works fine...except, I only get a list of 72 Suppliers at the first level (out of 9,814), but can...