Search results for query: *

Dear Lakshmikiran, Thanks, what a big mistake I've done. It works perfectly ! regards, ngcn

Hello, I have a varchar field that store quantity order with "+/-" in front of it and I need to check if qty receive is more than this quantity order field, so the following statement was created. First, the "+/-" was replace with "", then I convert it to float, but unfortunately, I've...

Thanks for ur fast response, below is the sql statement. sql="SELECT v.vehicle_Code, v.yearmfg,c.description,t.catcode,t.vehno,t.tdate FROM Category c inner join Vehicle v on (c.category_code=v.category_Code) left outer join VTransansaction t on (t.VehNo=v.VehNo) WHERE t.TransDate >DateFrm...

Hi all, Does anyone knows how to display header data if there was no record found ?? I am using Crystal Report 8.5 & VB6 form to filter report. The header data are extracted from 3 different tables in database, one of the table is the transaction tables that i am extracting its records from...

synapsevampire, Thanks for your reply. I tried to explain again, I am using CR8.5, SQL 7 & VB6 for the report. The situation is like this : There is no blank space after the detail section in the CR because I won't know when the user want to leave a space after an detail item. The user can...

hi all, I have this report which enable user to control whether they want to leave a blank space(row) after a certain data row in report. User can control by insert a blank item (a data which don't have Item_Desc, Qty, UOM). But, the problem is I can't show this blank item unless user...

AndrewBaines, You misunderstand me or I have mislead you, I think the subject should be "truncate trailing zero". The report can be displayed perfectly on my pc & clients pc, no matter what modification I done to it. It's only that specific formula that cannot be displayed...

Can anyone help me out ??? I don't know why is that I can't get my client to view the report with a formula field correctly(only one formula that is not display accordingly) in their pc. All they see is QtyRecv in 2 digits of decimal point. There is no problem for me to view/print from my pc...

dgillz, Yes, I did. I copied the .rpt file to the location where I call this report from my VB system. I m sure that I did it b'coz what ever changes I made to the report can be displayed at the client side, only the formula mentioned failed to do so. regards, ngcn

Naith, I encountered problems when clients open this report. The formula works perfectly when I open the report from my pc, but when it is open from clients' pc, the field with this formula is being round up to 2 places of decimal points. e.g. 23.5984 becomes 23.60. I m sure that it is the...

Naith, Thank u very much..... It works fine !!! Best regards, ngcn

what kind of subject is that ???? just don't know how to write the subject. Hope that u can understand !! ;) I have an Unit Price field in a report, where I want it to display 2 places of decimal point by default, but if user enter with 3 places decimal point value, then the field will show it...

Hi Naith, I have tried out ur formula @F3 coz I already have the subtotal calculated, and in the Group footer which is where the subtotal situated, I suppress using ur formula as below : {@F3}=1 or {PODetails.ItemNo} = maximum({PODetails.ItemNo}, {PODetails.PONo}) {x} is being replaced by...

dgillz, If page 4 of group a is the last page, then subtotal for the last page will not be shown, Grandtotal is shown instead. so it should be : Page 1 of group a : Subtotal-10,000 Page 2 of group a : Subtotal-13,000 Page 3 of group a : Subtotal-12,000 Page 4 of group a : Grandtotal-38,500 -...

Hi guys, How to show Subtotal for a group where page number >1 and page number is not the last page ? The last page of the group is used to show Grand total. eg. If there are 3 pages for a PO. Thr first 2 page will show subtotal, & the last page will show the grand total. I manage to count...

ngolem, Ur formula is a success! But I put the @Initialization in Material Code Group section, cause there are more than one material code in a PO. Thank u very much ! best regards, ngcn

Hi guys, When I open up my thread this morning, I was shock & glad to see so many replies, thanks for ur replies. [bigsmile] synapsevampire is right, Balance is not a field, it is a calculation field. I will tried out Ngolem's formula, if it works, I will tell u guys. Thanks! best regards, ngcn

dgillz, Could u pls elaborate "minimum summary on Balance" ? regards, ngcn

Dear all, I need to calculate the Balance of a material ordered through PO. The formula is (Bal:=Qty Order minus Received Qty) for the first batch of Qty received, then (Bal:=Bal minus Received Qty) for the subsequence batch of Qty received. Please refer to example below. Report ...

kenhamady, It is not exactly the same, its a Financial year from 1st Sep to 31 Aug (12 months). I want to calculate the Year To Date Total for the total amt of Qty * Rate. If current month is > Sep, sum current year's Sep until current month, if current month is <= Sep, sum amt from last...