Search results for query: *

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

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

Thanks Pete for asking that again, I got it wrong the first time and it works now. I'm still learning and I hope my knowledge and stupid questions get better soon. Thanks again :)

I created a new report with the currency table and entered the group selection {Currency.Date} = Maximum({Currency.Date}). It leaves the EUR out (in red, copied straight from the DB). If I get the EUR included with the group selection, then everything should work...

Hi, I tried this and it removes all EUR results (as well as those which have blank currency value) but shows all other currencies. If it matters, EUR is only once with date 2002-02-02 00:00:00 as "1" in the list as it is in this case the homecurrency in the ERP. Ideas how to fix it?

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

LB, this works perfectly. Thank you very, very much for your help! I learned something new again :)

When confirmed is null, but oldconf is not: Then I want to calculate the difference OLDCONF-SHIPMENT. On Time Delivery report, where we want the difference calculated. This is the idea: I haven't created the original formula, and struggling to get this right.. but I'm learning more every day...

I copied the formula from your post to notepad: -> replaced the {CONFIRMED} etc. to the correct table names -> copied the formula from notepad -> Edit formula in Crystal -> Erased the old formula and pasted your formula The Difference value is in "Number" format and the dates are "Date"...

Thanks for your answer, I changed in the report as you suggested - However it still does not calculate the difference as it should. As an example: REQDATE 2018-10-31, OLDCONF 2018-10-31, CONFIRMED null/blank, SHIPMENT 2018-12-04 This gives the difference "0 days", and it should be "-34 days"...

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

Ok, thank you for the help! I could not figure this out without your advice.

Thanks for your quick answer. I am a self-taught beginner and haven't used the SQL expression editor or conversions. What I did try and surprisingly works: 1. Changed the Parameter to Number 2. Added 'Val({table.row}) in {?ParameterRange}' to the formula field -> This changed the type to Boolean...

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