Search results for query: *

Crystal XI to Access 2007 database I have the following data ID VAR DateTimeStamp 90009 G8 24/5/09 00:00:00 90009 G8 24/5/09 11:00:00 90009 G8 24/5/09 12:00:00 90009 G99 24/5/09 13:00:00 90009 G99 24/5/09 14:00:00 90009 G99 24/5/09 14:30:00 90009 G99...

Crystal XI connected to Access 2007 Simple question. I have a Group on names. I would like the group names to display regardless of no results. e.g. Customer 1 0 Customer 2 0 Customer 3 0 I have multiple group headings and would like to display each. Standard way I would do this is...

Hi Using Crystal XI to Access 2007 database Group # ID Start date End Date @Start @Archive 1/5/09 1/5/09 True False 12/5/09 12/5/09 False True 30/5/09 31/5/09 False True For each Group #ID I and @Archive = True I need to confirm...

Crystal XI, Access 2007 database I need to create a distinct count of record ID's in seperate workflow stages. There are multiple instances of the record ID as it passed through stages of life cycle. The workflow has various stages. The ones I need to track are "Start", "DataEntry"...

Access 2007 database, Crystal XI Need to calculate difference between two date/times in days,hrs, mins also calculate an average if item critera has meet "start" & "archive" status. See example Each record has a unique id. Therefore have applied a group to ID. Created a formula to identify...

Access 2007 Database, Crystal XI Creating a report that requires a count of list of items e.g Name Number #Set 10 #Set1 12 #Partial 13 #Complete 20 Counts were initially counted in VB and then passed to Crystal. I would like to calc in Crystal. The Report is to only take...

Using Crystal XI connected to Access 2000 database. I want to create a Group via selection of memo type field. The field I require is NOT displayed in fields I can group on. Why is this? Do I need to convert field type? Thanks in advance.

Using Excel 2003 Is it possible to automatically create monthly columns based on a @datediff calculation? For example: @datediff result is based on columns the difference between columns C & D say 1/12/07 - 1/12/08 = 12 months Is it possible to automatically create columns Dec '07, Jan'08...

I am using MS Office 2003. I have been supplied documents saved in the mdi format. The images open and display formatted within MS Office Doc Image application, yet if the "send Text to Word" function is used all formating is lost. Is there a download or other function that can at a minimum...

Using Crystal V11, ODBC connection to SQL database Am using a Grouping formula to create the following headings. SALARIES & WAGES 10,000 BONUS & ALLOWANCES 8,000 EMPLOYER SGC -5,000 SUPER SAL SAC -4,000 EXEMPT TRANS 3,000 I am using a formula (see formula...

Using Crystal XI - ODBC connection to SQL 2000 database. I am using the below formula to provide data grouping. Via Group Expert I have selected specified order, nominated appropriate order and flagged any other items remain within their own groups. Code "LCTACD" should fall under my formula...

Crystal version 11, ODBC to SQL 2000 I have designed a report to display only records on a monthly basis if the summed period in days is greater than or equal to 14. (The user enters report date parameters Date_From and Date_To) REPORT DESIGN: GH#1 – Emp_No GH#2 – Date_From – Sectioned to...

ODBC link to SQL 2000 database. Using Crystal 11 Performing conversion to "hour values" from database so can have crystal perform sum calc. Formula is if isnull({t510_payroll_transaction.t510f120_hours}) then 0 else ( val(split({t510_payroll_transaction.t510f120_hours},":")[1])*60 +...

ODBC connection to SQL 2000 database. Using Crystal Version 11 I have created a report to display pay transaction details, these grouped as Group 1 Pay Entity Group 2 Grouping Formula – Taxed Earnings, Untaxed Earnings, SGC, Net Pay Group 3 Grouping Formula – Codes...

Using Crystal 11 with ODBC connection to SQL 2000 database I need to write a report to compare values that have been entered via timesheet transactions (these held within timesheet header and time sheet line tables) and actual payroll transactions (held in payroll transaction table) A common...

Crystal 10 with ODBC connection to SQL 2000 database. Need to sum "Hours" field from table but is displaying as string value. Crystal errors with "bad time format string" when trying to convert. Have tried functions ctime, tonumber etc. even totext and then converting but still errors. Val...

Crystal 11, ODBC to SQL 2000. I have a large report, all data is derived by date range parameter from one database field - "processed period" I need to insert a subreport which requires date criteria from two fields - "From" & "To" I am unsure if or how I can utilise the one date range...

Crystal 10 – ODBC link to SQL 2000 database Require a report to determine employees that did not receive pay rise via increment increase. Employees are linked to classifications which determine their rate of pay and effective date value applied. Report consists of two tables:- Payroll...

Using Crystal 11, ODBC connection to SQL 2000 database Data extracts are being performed to gather statistical information. This made up of around 10 separate reports. Records are selected on a date range basis however, depending upon the report are linked to different fields e.g. pay end...

Crystal reports version 10, ODBC connection to SQL 2000 database I am creating an employee FTE report, drawing on payroll summary records. Records are limited via range parameter linked to payroll end date field. To calculate FTE value I need to sum eft records, per employee and divide this...