Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gegeying

    Conditionally suppress section

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

    Conditionally suppress section

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

    Conditionally suppress section

    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 ( (...
  4. gegeying

    Conditionally suppress section

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

    Conditionally suppress section

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

    how to sort data?

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

    how to sort data?

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

    How to conditional suppress whole group section

    (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...
  9. gegeying

    how to set a parameter's default value to a formula

    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?
  10. gegeying

    How to get the latest date value from multiple records?

    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 =...
  11. gegeying

    How to get the latest date value from multiple records?

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

    How to get the latest date value from multiple records?

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

    how to do grouping on exiting formula?

    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']...
  14. gegeying

    how to do grouping on exiting formula?

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

Part and Inventory Search

Back
Top