Search results for query: *

I need to create a cycle count report to count weekly using crystal 10.0. We use progression series 7.6.400 sql. hope someone can help me.

I am working with Progression Series 7.6.400 SQL I created a new report field in alerts not in report select also using CRYSTAL SYNTAX this is how I put it in. if {IMRECHST_SQL.qty_received}is >= 0 then 0 else {IMRECHST_SQL.qty_received} Got error keyword then is missing and then I also...

When I put this formula in it gives me an error saying the keyword "then" is missing. I am using Progessive Explorer database and Crystal Reports 10

I need a formula like below, just not sure what to put after the else. if {IMRECHST_SQL.qty_received} is <=0 then 0 else (in this I want the actual amount received {IMRECHST_SQL.qty_received} What I am getting in the received qty is, if the qty was received it is showing -450 and if it hasn't...

I need a formula like below, just not sure what to put after the else. if {IMRECHST_SQL.qty_received} is <=0 then 0 else (in this I want the actual amount received {IMRECHST_SQL.qty_received} What I am getting in the received qty is, if the qty was received it is showing -450 and if it hasn't...

I use Crystal Reports with Progression Explorer. The problem I am having is on the following sample report. It is duplicating my qty ordered. If I click on do not duplicate then it doesn't give the qty ordered if the Purchase order number is different. PO number qty ordered 12345...