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!

  • Congratulations strongm 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: icerubes
  • Content: Threads
  • Order by date
  1. icerubes

    Crystal Reports 2011 Table Join (data match issue)

    Crystal Reports 2011. Connecting via ODBC to Pervasive 11 database. I wish to link 2 tables. The first table is the Master record holder. The second table holds all the underlying detail. The join is very simple - Table 1.Quote# right outer join Table 2.Quote#_Add. (not enforced). e.g...
  2. icerubes

    Create Running Balance Calc

    [highlight #EF2929][/highlight]Using Crystal 11, ODBC connection to Pervasise Database. I have created a report that lists transactions for each GL account between user nominated dates. e.g. Parameters - Start date and End Date #Group1 - Account type (Income, Expense etc) #Group2 - GL Account...
  3. icerubes

    Total "Select" Group Summarized Values

    Hi Using Crystal 11 with ODBC access to Pervasive Database Report structure is #Group Header 1 - COA TYPE #Group Header 2 - COA CODE Details #Group Footer 2 - summarized total of COA CODE #Group Footer 1 - summarized total of each COA Type #GROUP 1 - COA Type is categorised -...
  4. icerubes

    Crystal Report 2011 Calculate Opening balance

    Hi Using Crystal 2011. Connecting to Pervasive 11 database via ODBC. The database calculates Chart of Accounts (COA) opening / closing values each and everytime user nominates a period. It DOESNT hold any values other than at transaction level :(. It literally calculates the balance from the...
  5. icerubes

    Outlook 2010 Subject Line to Excel 2010

    Hi Using Windows 7 platform. MS Office 2010 Suite. For a nominated folder in Outlook I would like to extract only the emails within specific date range and that meet criteria of the wording "Authorised" in the email subject line. e.g. Outlook folder = Arnold Date range = 1/12/12 - 31/12/12...
  6. icerubes

    CrossTab Multiple Fields Formula

    Evaluation (fully functional) copy - SAP Crystal Reports Standard report structure is:- Group #1 - Estimator Group #2 - Debtor Fields - Quote#, Quote Date, Job#, Job Inv $ There will not always be a Job for each Quote. Therefore for a Job to be counted or summed the JOB#...
  7. icerubes

    Cross Tab Formula Help

    Crystal Reports XI Group #1 - Estimator Group #2 - Debtor Fields - Quote#, Quote Date, Job#, Job Inv $ Sample report (Group 1) - TC (Group 2) - AVI (count of Quote#) (Sum Job Inv $) (Count of Job #) (Sum of Job Inv $) AG 10...

Part and Inventory Search

Back
Top