Search results for query: *

Thanks lBass. I went to check all the related fields. guess what, it just like what you said, some showing null and that fails the formula. Now, my report works perfect. thanks again for your help. Happy a nice day

The report is still no working, even though I did as below {@error1} in ["","0"] and {@error2} in ["","0"] and {@error3} in ["","0"] and {@error4} in ["","0"] HOWEVER, if I changed the formula order, for example, {@error3} in ["","0"] and {@error2} in ["","0"] and {@error1} in...

Here is the contents of some error formular. ERROR2 IF {WORKORDER.WORKTYPE} = "CONTRACT" and ISNULL ({WORKORDER.WO14}) then "2" ELSE "0" ERROR4 IF {@NoError4} = "Error_4" AND {WORKORDER.WO20} <> "Y" AND ( {WORKORDER.WORKTYPE} in ["SHA","INMATE"] AND ( (...

Thanks, Charliy. I did as you said, put "0" there. However, the report still hide some of the bad data. any idea? Thanks

hi, anyone can help me on this? I have several formula: @error1, @error2,... @error4. The report use those formula to evaluate the data. In detail section, there are good and bad data. If the data is bad, value from the corresponding error formula will show up. For Example...

Thank dhookom. Your expression works fine. however, I have a long list (about 45 segment_no) need to show on report. I tried and I was told that the expression is too long. do you have other way ? many thanks.

I am trying to create a report in Access 2002. Below is the SQL. SELECT segment_detail.segment_no, Shops.County, segment_detail.shop, segment_detail.routes, sponsors.name FROM Shops INNER JOIN (sponsors RIGHT JOIN segment_detail ON sponsors.sponsor_id = segment_detail.sponsor_id) ON Shops.Shop...

(crystal 8.5) Here is the example Location 1 workorder 1 John Doe 6/12/2007 4hrs Temp 6/21/2007 8hrs Workorder 2 Mary 7/01/2007 6hrs Tom 7/12/2007 8hrs Since for workorder1, the 2nd record contain "temp", I need the whole group "workorder1" to suppress. how to do...

I am trying to create a parameter, which sould allow multiple values. and Its default value is in fact from a formula. i.e. Mid ({EQUIPMENT.GLACCOUNT},11 ,5 ). I am using Crystal report 8.5. how to do that?

LBass, thanks for your quick reply. But here comes another problem, how to show corresponding METERREADING for the latest ACTDATE? i.e latest_date = maximum({workorder.actdate}, {equipment.equipno}) I create another formula to show meterreading; latest_meter =...

Data example: in <WORKORDER> table: [WO] [EQNUM] [ACTDATE] [METERREADING] WO1 EQ001 02/01/2006 1000 WO2 EQ002 03/21/2006 200 WO3 EQ001 05/02/2007 3000 WO4 EQ003 06/10/2005 4000 WO5 EQ003 09/12/2006 6000 in <EQUIPMENT> table: [EQNUM] [EQTYPE] [EQLOCATION] EQ001 T D1 EQ002 S D2 EQ003...

Here is my question: 2 tables: equipment, workorder they are linked: equipment.eqnum = workorder.eqnum for each eqnum, there could be >1 workorder. Fields of <workorder> table like WORKORDER, EQNUM, ACTDATE, METERREADING Fields of <equipment> table like EQNUM, EQTYPE,EQLOCATION On the...

Well, maybe my question is not clear. I am trying to create a group(group 1) on existing formula(called f1), which is for group 2. It should looks like following: Group 1 Group2 Group3 To create this Group 1, I create a following formula as f2: If f1 in ['001','003','004']...

how to grouping on exiting formula Here is my question: On the report, there are currently 2 groups: Group #1 Name: @activity_no Group #2 Name: @district_no For example: 001 D1 D2 D3 002 D1 D2 D3 003 D1 D2 D3 004 D1 D2 D3 005 D1 D2...