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 Mike Lewis 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: sopomeres
  • Order by date
  1. sopomeres

    Charting a RunningTotal

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

    Converted DB Runs Slower (97 > XP)

    Awesome...I will check out it. Thank you!
  3. sopomeres

    Converted DB Runs Slower (97 > XP)

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

    Connecting to Excel Spreadsheet

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

    Top 10 Percent

    LB, It works for a straight list with no grouping. Now how do you apply this so it shows the top ten percent for each job group in a report? Thanks for the help! Chuck
  6. sopomeres

    Top 10 Percent

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

    Querying a GroupWise Calendar

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

    GroupWise Calendar Connection

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

    Max Date in a Range

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

    Saturdays

    This provided me with Saturdays for the first half of the year only. I will check to see if there are filters or suppressions set up. Thank you. How can I identify every Saturday prior to '1/2/1999' going back 10 years?
  11. sopomeres

    Saturdays

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

    Using a formula as a parameter

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

    Formatting a number

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

    Org Chart from a Database

    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)...
  15. sopomeres

    CrossTab with Nulls/Blanks

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

    6 mos from a date

    It worked. Thanks all. DateAdd('m',6,{YourDate}) -Chuck
  17. sopomeres

    6 mos from a date

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

    Charting Months

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

    Applying a format to every other group

    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

Part and Inventory Search

Back
Top