Search results for query: *

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

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

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

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

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

Hi, Does anyone knows how to create a formula to calculate Sum of an Amt field whereby if current month is > Sep, sum from current year's Sep to current month, if current month is <= Sep, sum amt from last year's Sep to this year's Sep. The main point is sum 12 mths but must start from...

Good day, Hi, anyone knows how to create a summary report where the amount field of different PO No are sum up by month & group by company name. Report that I have created shows several differrent rows. I group the Company Name field & sum amount field according to, the formula used is ...

Hi, Good day! Did anyone knows what to do ? I have 4 reports which show same data (only titles are different), they are to be showed at the same time when user click a button ??? What I do now is create & save them in separate report name, then shows all of them when user click on the...

Anyone know why the export button won't work at run time ? It works well at design time. Do I have to activate it or something like that ? I want my user to export their report data to Microsoft Excel. I m using CR4.6, VB6 & Win2k pro. Thanks a lot. best regards, ngcn [bigsmile]

Hi, I m trying to do this for a few days already, but it don't seem to work, sigh! [sadeyes] For example : I have a field named Qty, it can store +/- before it, e.g. +/-200, now I m trying to do a calculation with it, but first I have to trim off the &quot;+/-&quot;. How do I go about it ...