Search results for query: *

I am working on a report that lists items with the qty hand, then it has a running total of the most recent receipts that I want to stop returning records on the receipt that brings the running total to equal or greater than the qty on hand. Open to any suggestions; sample data; item...

Crystal 2011, SAGE database - Providex Two tables, SO_header and SO_detail linked on SalesOrderNo I have a report that selects sales orders based on the ship date [so_header.shipdate]< CurrentDate+20, and order type (so_header.ordertype)in ["B", "S"]. It groups on Grp 1, ship date and Grp 2...

Using Crystal 2008 on Oracle data. I am creating a report with multiple sub-reports all based off a WO# or a WO# and part no. Using groups (group 1(a), 1(b) etc by WO# and group 2(a), 2(b) etc by Part no) I have 4-5 reports that are portrait 8.5X11 all loaded and running great. I have...

I am working on an average days to pay report. I am pulling all payments grouped by invoice and summing them to compare to invoice totals, then taking the max of the payment dates. Then I deduct the invoice date from the max payment date, returning a "days to pay" for each invoice but I can't...

Using crystal XI linking to a single SQL table I have a small sub-report that is selecting records based on {@CustomerNo} = {?Pm-?Customer} and {@Date} in [{?Pm-?EndDate}, {?Pm-?StartDate}] It returns AR balances for the start and end date for the selected customer. Date OpenBal Current...

I have a client that has a table that is a list of items and a column for each week (Mondays date) and then for each item they report "demand" for that week. Item \ 4/28/14 \ 5/5/14 \ etc... ABC \ 500 \ 50 CBA \ 25 \ 200 I need to convert it to Item \ Date \ Qty ABC \...

I have an access program used to create a .csv file used to upload invoicing to a customer (like EDI but not standard, the Purchase Order's (PO) are not sent electronically) The problem that I have encountered is that there are items called "KIT" items that the customer orders as a single part...

I am using Crystal X with an ODBC connection. I am trying to link a CUSTOMER table to a PRICING table on one of two possible fields, The customer Number or the pricing Level. One or the other will match in the pricing table for each customer. I have used a left join FROM the Customer TO the...