| Author |
Message |
ccouto
Newbie
Joined: 20 Jun 2012
Location: Brazil
Online Status: Offline
Posts: 23
|
   Posted: 21 Jun 2012 at 4:20am |
|
thanks for giving me strength,
is trying to help me
|
 IP Logged |
|
hilfy
Admin Group
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
|
Posted: 21 Jun 2012 at 4:22am |
Look again at what I posted - you forgot the first "<= 0". -Dell
|
|
|
|
IP Logged |
|
ccouto
Newbie
Joined: 20 Jun 2012
Location: Brazil
Online Status: Offline
Posts: 23
|
Posted: 21 Jun 2012 at 4:30am |
|
He would look like?
Sum ({@ConsumoMedio}, {AGR_DEM_MOV_ITENS_V.ID_PRODUTO}) and {@Saldo} <= 0
correct?
If yes, was so placed.
:(
|
|
IP Logged |
|
hilfy
Admin Group
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
|
Posted: 21 Jun 2012 at 4:46am |
No. Sum ({@ConsumoMedio}, {AGR_DEM_MOV_ITENS_V.ID_PRODUTO}) <= 0 and {@Saldo} <= 0
-Dell
|
|
|
|
IP Logged |
|
ccouto
Newbie
Joined: 20 Jun 2012
Location: Brazil
Online Status: Offline
Posts: 23
|
Posted: 21 Jun 2012 at 4:56am |
Continued from products that have zero balance.
Come on, I'm doing steps:
I have 6 groups (company, type, grade, class, subclass and product)
In the group header # 6 I put all the data to be printed.
I was there in the section expert, selected the group header # 6 clicked the formula button next to SUPPRES (the drill down) and typed the formula that you directed me, had not missed test and the compilation of the formula.
Sum ({@ConsumoMedio}, {AGR_DEM_MOV_ITENS_V.ID_PRODUTO}) <= 0 and {@Saldo} <= 0
However when I print the balance = 0 keeps coming.
I did something wrong? : (
|
|
IP Logged |
|
hilfy
Admin Group
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
|
Posted: 21 Jun 2012 at 5:04am |
If you're doing this in a group header section, you might want to try using this formula in the Group Selection formula. To do this, click on the down-arrow just to the right of the Select Expert button and select "Group" or go to the Report Menu, Select Expert, Group. Then select any field that's on your report - this is just so that the Select Expert will come up and you can get to the formula to edit it manually. If you don't see the formula, click on the "Show Formula" button. Paste in the formula that we've been working on and click on "OK". -Dell
|
|
|
|
IP Logged |
|
ccouto
Newbie
Joined: 20 Jun 2012
Location: Brazil
Online Status: Offline
Posts: 23
|
Posted: 21 Jun 2012 at 6:50am |
|
Could you send me this screen for my email?
I cant find.
carine.couttto@gmail.com
Sorry, I'm now learning to use the crystal.
|
|
IP Logged |
|
ccouto
Newbie
Joined: 20 Jun 2012
Location: Brazil
Online Status: Offline
Posts: 23
|
Posted: 21 Jun 2012 at 7:07am |
|
Friend, I tested here and it worked!! = D
Thank you very much.!! hehehe
I was in expert selection
I selected the option goup and typed the following formula
SaldoFinal @ {} <> 0
And apparently it worked.
|
|
IP Logged |
|
ccouto
Newbie
Joined: 20 Jun 2012
Location: Brazil
Online Status: Offline
Posts: 23
|
Posted: 21 Jun 2012 at 7:07am |
|
Friend, I tested here and it worked!! = D
Thank you very much.!! hehehe
I was in expert selection
I selected the option goup and typed the following formula
{@SaldoFinal} <> 0
And apparently it worked.
|
|
IP Logged |
|
|
|
