Recent content by up4a

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