Search results for query: *

lbass to the rescue! Worked like a charm. Thank you so much. ~up4a

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

Now why didn't I think of that!! Running totals worked perfect. Sometimes I just need to get out of my own way! Thanks again LB!

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 got this to work in a new version of Crystal.. Sorry for the waste of time..

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

Shoot.. I spoke too soon. Using the above formulas it is returning values in the detail section and the start value int he header and the end in the footer but I need something that will select the start and end balance in the header or the footer. Back to the drawing board.

Thanks Charliy, end_balance and start_balance are not fields or formulas, I figured it out, I am using a formula to pull each start and end balance. If {date} = {?StartDate} then {OpenBal} etc.. then a formula to calculate the % change.. a total of 18 separate formula's [glasses]

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

Thanks for that! I will ask the client to do that and then I can just link to their document! Love this site!

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 got this to work but it is really slow.. SELECT A.SalesOrderNo, A.SequenceNo, A.SkipPrintCompLine , (SELECT Count(*) FROM SO_SalesOrderHistoryDetail B Where A.SalesOrderNo=B.SalesOrderNo AND A.SequenceNo>=B.SequenceNo AND A.SkipPrintCompLine<>"Y") AS PO_Line FROM SO_SalesOrderHistoryDetail AS...

The Query runs but it returns 1 for every PO_Line, it doesn't "re-number" (Thanks again for the help!)

I am not very skilled in code so the 'A.' is confusing me. The below is what I tried in the SQL Query editor (I simplified my original table/fields but the logic is the same..) when I try to run it, it requests each parameter value. SELECT A.SO_SalesOrderHistoryDetail.SalesOrderNo...

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

lbass, I had the same thought once I slept on it. I can get it to select the data now from the customer file and can hopefully complete the report with two sub-reports. I have to remind myself to step away from a project sometimes! (The second link is a pricing level in the customer file, so...

I can change the links by selecting the database menu, database manager and the links tab. With a left join it should include any data selected in the FROM table and only that that links in the TO table

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