cancel
Showing results for 
Search instead for 
Did you mean: 

'Special Fields' in Formula Editor

Former Member
0 Kudos

Can 'Special Fields' be added to a formula in Crystal Reports?

I'm trying to create a formula whereby if a record (FIELD: NUMBERPRGN) didn't show up on the previous run (SPECIAL FIELD: Print Date) but it shows on the current run, that I can add some form of formatting to the record to indicate the changes. The run dates are ran weekly on Fridays. I'm using the 'special field' print date in the main report which consists of 24 subreports set up in calendar format. The subreports are based off each day of the week (FIELD: PLANNED_START)

Here is the start of the formula as to how i see it:

If {CM3RM1.PLANNED_START} <= {Print Date(Date)} then

("**" + {CM3RM1.NUMBERPRGN}) else {CM3RM1.NUMBERPRGN}

When I check for errors to the formula, I get error message "The field name is unknown" with the 'special field' name highlighted.

Any help is greatly appreciated.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Try this formula

If {CM3RM1.PLANNED_START} <= PrintDate then 
("**" + {CM3RM1.NUMBERPRGN}) else {CM3RM1.NUMBERPRGN}

you can also try this

If {CM3RM1.PLANNED_START} <= DataDate then 
("**" + {CM3RM1.NUMBERPRGN}) else {CM3RM1.NUMBERPRGN}

Regards,

Raghavendra

Former Member
0 Kudos

Ok, that worked. Now I have to play around with the logic because it's not applicable in all situations. Thanks for your help.

Answers (0)