Recent content by psimon1

Sorry...that was an accident.

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?

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

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

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

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?

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

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

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

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

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

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

Oh, a basic concatenation. Thanks.

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

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