Search results for query: *

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

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

Thanks Ian If possible I need total values at base of calculation grouping. E.g Bank. XX Accounts rec. XX Current assets. XX Fixed assets. XX TOTAL ASSETS. XXX Accounts pay. XX Current liab TOTAL LIABILITES XXX Equity. XX TOTAl EQUITY. XXX Is this...

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

Awesome!! Thank you so much! I knew I was making this much harder than it actually was

Hi Pete Thanks for response. Totally agree with your comments re: requirement of every transaction in the database. I created the below formula to calculate the opening balance (including the grouping per account code) else the whole of all transaction values are totalled rather than per...

Sorry I didn't explain very well There are no totals. That is what I am trying to calculate. For example: (DATA) ACC CODE DATE REF AMOUNT ACCFEE 1/7/10 888 $55.00 ACCFEE 1/7/11 458 $60.00 ACCFEE 30/6/12 871 $99.00 BNKFEE 1/9/10 789...

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

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

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

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