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 derfloh 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: *

  • Users: old123
  • Content: Threads
  • Order by date
  1. old123

    Filter blank field

    Crystal XI I have a report which has unit & subunit in a same table , some of the subunits are blank. I need to run the report where the subunit is blank. Subunit field type is string. I tried few options but did'nt work. Any help is appreciated. Thanks
  2. old123

    Word Document

    MS WORD 2002 I have a document is MS Word which is basically a template with 5-6 tables in it . Main table is summery of sub tables and all the tables has numeric values in it. Is there a way to use formulas & link the sub tables with the main table(basically sum function)Importing a excel...
  3. old123

    Date help

    I am using CR XI and am connecting to an AS/400. The date and time formats are numeric My field is Hire date & it is store tlike 42180 this is mm/dd/yy so for 04/21/1980 it is 42180 04/23/2000 it is 42300 12/29/2003 it is 122903 I need to convert AS/400 numeric dates into a...
  4. old123

    Grouping on Running Totals

    Crystal XI Data coming from AS400 I have a attendance report in which i have seven running totals ,which is combinations of certain criterias. My current report is grouped on employee numbers , so it works fine however i need to now group them with running totals.Instead of sorting...
  5. old123

    Previous Records

    Crystal Ver 9 ODBC - AS400 I have a report showing records from a certain time period. Here is the output Bus No Date WO NO Meter Diff 001 08/05/2005 xxxx 187019 00 Group Footer Bus No Count Avg 00 Bus No Date WO NO Meter Diff 002 07/18/2005 xxxx 218816...
  6. old123

    Database change- NEED HELP

    crystal Version 9 Data Connection ODBC AS400 Iam a beginner in Crystal Reports . ALl of my reports were working fine untill this change. The SA decided to change the database tables names to seperate our data from other offices. Earlier the datbase was shared with all the departments. All the...
  7. old123

    Zero Value

    Iam posting another problem with the same report Iam working. I have calculated avg mean distance from the fleet however now I have noticed that quite significant data returns value 0 . i don't want to include the data in average calculation which has 0 value. I tried suppress feature & other...
  8. old123

    Average in Group Footer

    Crystal Version 9 Database AS400 Existing Report Bus no Mileage Differnce PB0001 79243 PB0001 84739 5,496.00 PB0001 90445 5,706.00 PB0001 96393 5,948.00 PB0001 101853 5,460.00 PB0001...
  9. old123

    Mean Distance ( How to avoid -ve numbers)

    Crystal report Ver 9 Database AS400 Existing Report Iam trying to find mean distance between failure Bus No WO no Mileage Differnce 9717 XXXXX 184049 0 9717 XXXXX 185723 1674 9717 XXXXX 186093 370 9717 189985 3892 9717 189987 2...
  10. old123

    Duplication/Overlapping of records -Artificial Records

    Crystal Version 9 Data AS400 Data is coming from 4 tables FM300 FM310 FM305 FM315 All of these tables are linked with Primary key Work Order Number. I have to generate a report for Road Calls with AC failure for month XX. Formula's used FM310.FMPSC is between 1300 -1318 FM300.FMWCC = 1...
  11. old123

    CALCULATE AVG ON THE COMPUTED FIELD

    I have a computed field "differnce" which is derived from this formula Grouped by XX {FM_300L2.FMPMR}- PREVIOUS({FM_300L2.FMPMR}) I need to find average of the filed "differnce" It seems easy however when i try to insert summary or create a formula it gave me an error . Please help.
  12. old123

    Reset a Formula after a group other than Running Total

    I have a formula which subtracts current value of the field with the previous value to get a differnce & it is groupwise with a Bus Number Formula is {FM_300A.FMPMR} - previous({FM_300A.FMPMR}) formula works fine for the first group but the next group first value gets subtracted with the last...
  13. old123

    Converting number to Date ( data coming from AS400)

    Iam using CR ver 9 to pull data off from AS400 . date field come over as a numeric (eg. 50601 which is 1st june 2005 )I need to convert this number 50601 to date 06/01/2005. i was trying to use numbertodate function which i downloaded from other site but did'nt work. Any help ........Iam new to...

Part and Inventory Search

Back
Top