on 05-07-2009 6:07 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.