Search results for query: *

In CR8.5, is there a way to represent a runningtotal in a chart? Thanks. Chuck

I converted and Access 97 database to Access XP and it processes queries and macros a lot slower now. It also increased in size since I converted it. Any idea on why? Thanks. Chuck

I am running CR 8.5 and I am trying to connect to data saved in a spreadsheet. I have tried creating new data sources to the spreadsheet, but the it returns 'no fields'. Is there an add-in I need to install. Is CR8.5 compatible with Excel XP? Also, the spreadsheet has mutiple worksheets...

CR8.5: I have a list of employees with salaries. How can I display employees with the top ten percent salaries. Thanks. Chuck

Is there anyway I can set up a connection to Novell GroupWise calendar? I'd like to report on specific meeting types. Thanks. Chuck

I'm looking to query a shared GroupWise calendar to track hours in specific meetings. Any idea on how I can connect to a GroupWise calendar for querying? Thanks. Chuck

In CR8.5: How can I capture the greatest {table.PayPeriodEndDate} that falls in the range of {table.HireDate} - 14 days. Thank you. Los

In CR8.5, how in a formula can I identify or list all Saturdays in a year? Thank you. Los

CR8.5: I have concatenated an employee's firstname and lastname in a formula named "@Name". Is there a way I can use this formula as parameter to include a pick list? Thanks. Chuck

How can I drop the decimal places and thousands separator of a number AND convert to text all in the same formula? Thank you. Los

I have never linked Visio 2000 to a database...in this case our Lawson HR database. I understand how to connect using ODBC, but I guess I'm looking for the ideal table setup to create a dynamic org chart. Should I link Visio with a view, table, multiple tables? What shoud be in the table(s)...

I would like to create a crosstab for showing ethnic races for employees. (Count of employees by race) If a particular race is not represented in our staff, how can I have the crosstab display a blank cell or a '0' (zero)? Thanks! Chuck

How can I set up a formula to provide me with a date that is 6 months from a given date. ex: 1/2/04 --- 7/2/04 6/22/04 --- 12/22/04 Thanks. Chuck

In Cr8.5, is there a simple way to chart activities that occur in a month's timeframe? I am looking to create a column chart showing the count of an activity by month. Do I have to create a formula using.. If {table.datefield} in DateTime {2004, 01 ...~ then "January" else .... Thanks. Chuck

In CR8.5, is there a way to apply a background color to a group that displays on every other item in the grouping? ex: group #1 line 1 shaded line 2 not shaded line 3 shaded line 4 not shaded Thank you. Chuck

In CR 8.5, how can I show percentage values rather than counts in a crosstab? Thanks. Chuck

I'm looking to link the ssn's from 2 different tables from 2 different databases. How can I link the two if the below is true: database 1: ssn = 123-45-6789 database 2: ssn = 123456789 Any ideas? Thanks! Chuck

CR v8.5: When pulling a date from a FoxPro db, the year "1999" is appearing as "2099". Any ideas on how to fix this??? Thanks. Chuck

I'm running IIS on W2003. How can I add another site that has a different IP address (and DNS) pointing to it. It would be 2 sites with 2 IP addresses on one server. Thanks. Chuck

An 'attend' table has 4 fields: student_id, d001, d002, and d003. In the d fields the followng codes are accepted: AE, AU, AT . How can I count the number times each student_id has the "AT" value entered in the three d fields? Example: attend.d001 = "AT" attend.d002 =...