Search results for query: *

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

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

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

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!

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.

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