dorneles Posted February 19, 2008 Report Share Posted February 19, 2008 Hello Spirin, How to filter the content of a field that has no index. I would filters to not leave ESTOQUE = 0? http://img148.imageshack.us/my.php?image=prod31ua3.jpg FW 2.6 + HB 0.9950 + Pelles + Clipper 5.3 + VLib + xDevStudio Quote Link to comment Share on other sites More sharing options...
Spirin Sergey Posted February 19, 2008 Author Report Share Posted February 19, 2008 Hello, dorneles, citação:Hello Spirin, How to filter the content of a field that has no index. I would filters to not leave ESTOQUE = 0? id=quote>id=quote>There are many ways: 1) In object inspector of dataset (shortest): Fiter -> "ESTOQUE <> 0" Filtered -> True 2) By script only (longest): var CB: Integer; procedure ItemsAfterOpen(Sender: TfrxComponent); begin CallHbFunc('DbSelectArea', ['MYAREA']); CB := CreateCodeBlock('{||ESTOQUE <> 0}'); CallHbFunc('DbSetFilter', [CB]); end; procedure ItemsBeforeClose(Sender: TfrxComponent); begin CallHbFunc('DbSelectArea', ['MYAREA']); CallHbFunc('DbClearFilter'); FreeCodeBlock(CB); end; 3) If you use SetWorkArea() - method: // It's Harbour code: USE MYAREA SET FILTER TO (ESTOQUE <> 0) FrPrn:SetWorkArea("BBB", Select("MYAREA")) FrPrn:DesignReport() //or ShowReport() Quote Link to comment Share on other sites More sharing options...
dorneles Posted February 24, 2008 Report Share Posted February 24, 2008 1-Need for total operation: DESPESA : 80.00 VENDA A VISTA: 200.00 2-I have a report from credit and debit how to differentiate am doing this: Total: [sum ()] http://img209.imageshack.us/my.php?image=caixa31wi3.jpg FW 2.6 + HB 0.9950 + Pelles + Clipper 5.3 + VLib + xDevStudio Quote Link to comment Share on other sites More sharing options...
dorneles Posted February 24, 2008 Report Share Posted February 24, 2008 Solved, use the Object DB Cross-tab, missing only do the calculation dac column D - C ? http://img218.imageshack.us/my.php?image=caixa311so6.jpg FW 2.6 + HB 0.9950 + Pelles + Clipper 5.3 + VLib + xDevStudio Quote Link to comment Share on other sites More sharing options...
evandro Posted February 24, 2008 Report Share Posted February 24, 2008 Olá, Na totalização tentei assim: [sUM( [iIF( > 35 , , 0 )] )] Mas dá um erro: Invalid variant operation Então qual seria a forma correta de usar o IIF() para uma soma condicional? []s, Evandro G. de Paula Curvelo - MG evandro@skillnet.com.br (Escr. - na Cidade) imortal@skillnet.com.br (Res. - na Roça) FWH 2.6+PellesC+MyMake+xHarbour.org 0.99.5+SqlLib I PREPARATÓRIO PARA O VI ENCONTRO FIVEWIN - JULHO/2008 - CURVELO - MG Editado por - evandro on 25/02/2008 14:28:13 Quote Link to comment Share on other sites More sharing options...
dorneles Posted February 25, 2008 Report Share Posted February 25, 2008 Olá Evandro, estou usando assim. [sum(IIF(='D',,0))] FW 2.6 + HB 0.9950 + Pelles + Clipper 5.3 + VLib + xDevStudio Quote Link to comment Share on other sites More sharing options...
evandro Posted February 25, 2008 Report Share Posted February 25, 2008 Olá, Estava com uma chave a mais, a do iif(). Agora funcionou legal. Valeu. []s, Evandro G. de Paula Curvelo - MG evandro@skillnet.com.br (Escr. - na Cidade) imortal@skillnet.com.br (Res. - na Roça) FWH 2.6+PellesC+MyMake+xHarbour.org 0.99.5+SqlLib I PREPARATÓRIO PARA O VI ENCONTRO FIVEWIN - JULHO/2008 - CURVELO - MG Quote Link to comment Share on other sites More sharing options...
evandro Posted February 26, 2008 Report Share Posted February 26, 2008 Olá, citação:3-Quando será liberada a versão final?3. I think after ~2 week. id=quote>id=quote>E aÃ, Spirin? Como está a versão final? Para quando? []s, Evandro G. de Paula Curvelo - MG evandro@skillnet.com.br (Escr. - na Cidade) imortal@skillnet.com.br (Res. - na Roça) FWH 2.6+PellesC+MyMake+xHarbour.org 0.99.5+SqlLib I PREPARATÓRIO PARA O VI ENCONTRO FIVEWIN - JULHO/2008 - CURVELO - MG Quote Link to comment Share on other sites More sharing options...
Spirin Sergey Posted February 27, 2008 Author Report Share Posted February 27, 2008 E aÃ, Spirin? Como está a versão final? Para quando? []s, Hello, Evandro, Sorry for such delay. The code is ready for release. My only problem is "bureaucratic" (a payment scheme). I hope that the release-version will be at next week. --- Spirin Sergey. "Paritet Soft" Company. FRH beta: http://www.paritetsoft.ru/frh.htm FRAX sales: http://www.hotsoft.ru/ALASKA/frax_eng.htm Quote Link to comment Share on other sites More sharing options...
Spirin Sergey Posted March 1, 2008 Author Report Share Posted March 1, 2008 Hello. Documentation and version of FRH are updated today. It's a final pre-release version. I hope that release version will be at next week. --- Spirin Sergey. "Paritet Soft" Company. FRH beta: http://www.paritetsoft.ru/frh.htm FRAX sales: http://www.hotsoft.ru/ALASKA/frax_eng.htm Quote Link to comment Share on other sites More sharing options...
evandro Posted March 8, 2008 Report Share Posted March 8, 2008 Olá, citação:I hope that release version will be at next week. id=quote>id=quote>Só para lembrar que a "next week" já passou. []s, Evandro G. de Paula Curvelo - MG evandro@skillnet.com.br (Escr. - na Cidade) imortal@skillnet.com.br (Res. - na Roça) FWH 2.6+PellesC+MyMake+xHarbour.org 0.99.5+SqlLib I PREPARATÓRIO PARA O VI ENCONTRO FIVEWIN - JULHO/2008 - CURVELO - MG Editado por - evandro on 10/03/2008 10:28:06 Quote Link to comment Share on other sites More sharing options...
miragerr Posted March 8, 2008 Report Share Posted March 8, 2008 hehehehe Evando tem que perguntar de que ANO Jackson Douglas Boa Vista FWH 8.02 Lamborguini ( isso voa gente ) PellesC+xH 1.1.0 email : miragerr@osite.com.br MSN : jackson_rl@hotmail.com SKYPE : jackson_rr Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.