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?
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...
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 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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.