Search results for query: *

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

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?

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

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