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!

Register Log in
  • Congratulations Rhinorhino 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: psimon1
  • Order by date
  1. psimon1

    summary on a formula

    Sorry...that was an accident.
  2. psimon1

    summary on a formula

    I have the 'reset' formula that you mentioned earlier in the employee header. Which is the evaluate formula? Which formula should I have in the employee header?
  3. psimon1

    summary on a formula

    Yes, it's in the group #1 header (for department).
  4. psimon1

    summary on a formula

    Thanks. The grand total works fine but I'm still struggling with the dept totals.
  5. psimon1

    summary on a formula

    I am missing something. My display total in group footer #1 for department isn't totalling all of the individual employees' projected earnings. It seems to be taking the max. employee proj_earnings 1 10 2 20 3 30 total 30 I put the 'reset' formula in the...
  6. psimon1

    summary on a formula

    Thank you for the response, Ian. I got this to work except for the "group summary.' You are correct; I am doing a per department summary. Under "Change Group Options", do I need to use a formula as group sort order?
  7. psimon1

    summary on a formula

    Hello I am running CRXI and want to know how to do this. There has to be a way. I am trying to create a report to determine projected earnings for employees and departments. I have a formula derived on an employee grouping called Projected Earnings. I have another grouping for...
  8. psimon1

    summary on a formula

    Hello I am running CRXI and want to know how to do this. There has to be a way. I am trying to create a report to determine projected earnings for employees and departments. I have a formula derived on an employee grouping called Projected Earnings. I have another grouping for...
  9. psimon1

    restoring menus - office 2007

    Hello I have XP Pro with a new version of Office 2007. I hate the ribbons and want to remove them. Give me FILE, EDIT, etc... and I am a happy guy. I know that there's a Chinese company that makes a tool that allows you to restore the menus but don't know if that's an inherent option in...
  10. psimon1

    can I do this in Crystal or do I need views?

    Thank you. I was able to write a report for "max" date but not the second. I think that your "next" one might work. Very interesting... Here's the code for the three views that I had in mind: CREATE VIEW vwEMPLOYEE1 AS select row_number() over (partition by EMPLOYEE ORDER BY DATE_STAMP) AS...
  11. psimon1

    can I do this in Crystal or do I need views?

    Hello We run SQL Server 2005 and I know for a fact that, with a series of views, I can easily do this. I don't know if a. I can do this in CRXI b. this report will take excessively long. In short, I'm looking for a systematic way of pulling the employee's second most recent status date. An...
  12. psimon1

    CROSSTAB CALCULATIONS

    Hello If I pull from the following table: employee, check date, amount 123,1/1/07, 1000 123,1/2/07, 1150 etc into a crosstab: CHECK DATE 1/1/07 1/2/07 123 1000 1150 is there a way in CRXI to input a calculated field, such that I get a separate...
  13. psimon1

    keeping details on crosstab in CRXI

    Oh, a basic concatenation. Thanks.
  14. psimon1

    keeping details on crosstab in CRXI

    Yes, it's a string. So what would the formula be? I'm curious to try it. Thanks.
  15. psimon1

    keeping details on crosstab in CRXI

    Thank you. Yes, I am exporting it to Excel. {table.division}+" "+totext({table.position},0,"") had too many arguements, though. Phil
  16. psimon1

    keeping details on crosstab in CRXI

    Hello There has to be a way to do this but the brain must not be up yet... I am doing a CRXI Crosstab report and get the following output: Before you ask, yes, it does have to be a crosstab report because of the way in which the data is structured.d division positioni minimum salary mid...
  17. psimon1

    basic question on MID function

    Hello I'm more of an Access guy and I know that there are differences between Jet SQL and TSQL. We're running SQL server 2005 and I can't seem to find an equivalent to Access' mid function. In other words, I really liked how I could pull part of a record as follows: MID(NAME, 3,2) AS NAME...
  18. psimon1

    probably a basic question

    I had to add the group first (by employee). After that, it worked like a charm. I still like the Access way more, but this will suffice. Thanks!
  19. psimon1

    probably a basic question

    I can't just use a formula in Crystal. select expert on CHECK DATE Maximum (CHECK DATE)? Thanks. That seems easiest to me but I think like an Access man.
  20. psimon1

    probably a basic question

    Hello I'm more of an Access guy but I know that you can do this. If I have a table: EMPLOYEE, CHECK DATE, CHECK AMOUNT 123, 1/1/07, 100 123, 2/1/07, 200 123, 3/1/07, 300 456, 1/1/07, 100 789, 4/1/07, 100 and I want to return each employee's maximum check date, such that I receive: 123...

Part and Inventory Search

Back
Top