Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: J33
  • Content: Threads
  • Order by date
  1. J33

    Calculate sum when project phase starts with a specific digit

    Hi, In our project field we have a 6-digit project number and then a 4-digit project phase. As an example 123456-9500. I need the total sum calculated, in a subreport, for the purchase order rows that have the a project phase beginning with a 9, in other words projectnumber-9??? -> Parameter...
  2. J33

    Subreport, subtract from sum

    Hi, I have a subreport that is calculating the sum of shipped items per item code (from sales order rows) that belongs to a project number and a bill of materials. Now I need the subreport to take the stock places in consideration and subtract from the "shipped items sum" the rows that have...
  3. J33

    Monthly exchange rates, select only newest rate on each currency for currency conversion on row

    Hello, I have a stock value report made with crystal reports that shows the all item codes in stock (one row for each item code in the report), including item description, amount in stock, previous currency price, currency and also calculates the amount in stock * previous currency price. I...
  4. J33

    Calculating OTD report, 4 different dates

    Hi, we have an OTD-report (through our ERP) with 4 different dates. I simplified the names in the code. The issue I have now: When CONFIRMED does not have a date, but OLDCONF does -> It will not calculate the OLDCONF - SHIPMENT. How can I fix this? And yes, this issue appears when the dates are...
  5. J33

    Parameter Field range value issue

    Hi, I am using CR XI and a OLEDB connection. I want to use a Parameter Field allowing multiple, discrete and range values. Now I am facing a small issue with the range: If I select the range: Rows 1-9 from an offer request - I get rows 1-16 (all rows) If I select the range: Rows 1-10 from an...

Part and Inventory Search

Back
Top