cross tab rpt: function cannot be used; it must be evaluated later

[psimonnyco]

sfd

Hello

I'm running CRX against SQL Server.

I have a 'second pass' error and am looking for a simple solution without a custom view.

I have a transactional table with transactional data, sampled as follows.

EMPLOYEE, HOURS, PAY CODE
1, 40, REG
1, 2, REG
1, 10, OVT
1, 8 VAC
2, 40, REG
2, 10, OVT
3, 8 VAC

I'm doing a crosstab report to give me:

REG OVT VAC SUM
EMPLOYEE 1 42 10 8 60
EMPLOYEE 2 40 10 8 58
EMPLOYEE 3 8 8

I'd like to use the select expert on SUMOFHOURS >40 but can't. See below. Any ideas? Thanks.

1. Why does a formula produce the error?

"The function cannot be used because it must be evaluated later"?


Answer: This error usually happens when trying to insert a second pass function into a record selection. Since Crystal Reports evaluates record selection formulas during the first pass of the data, they cannot contain second pass functions.

 

[lbass]

Please do not crosspost. This is an inappropriate forum for this question anyway.

-LB

 

[psimonnyco]

I don't have the 'box.net' application. I'm not sure about how I can send you the screen shot.

 

[dgillz]

Please post in a crystal reports forum, not a crystal enterprise forum.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?