Formula in Page Header 1

[jdemmi]

I know I should be able to figure this out but I can't

I need to place a formula that is based on 1 of the "group fields" in the page header. It's a simple formula:

If table.field1 is valueA then "Yes"
else "No"

The problem is, that by placing it in the Page header the "last" table.field1 value is evaluated in the formula which almost always results in the ELSE condtion being met.

What I need is to basically say, in layman's terms:

If table.field1 EVER = valueA then "Yes"
else "No"

What am I missing?

-- Jason
"It's Just Ones and Zeros

 

[Madawc]

Crystal does things in a fixed order. Each section takes notice only of the data read, not what may be read later.

It does rather depend on the value. You can do a summary total showing the maximum, or minimum, if that helps. (You don't say what the desired value is. Nor which version of Crystal you have.)

If you can't get a summary - say you are looking for "G" when vaules A thru Z are all possible - then you'd have to put a subreport in the page header, which will be inefficient. The subreport would need to check all of the data for the value.

Or better, put the subreport in the report header, and then use a shared variable to pass a value back and test for it in each page header. (Note that each use of a subreport results in a separate request for data to the server, which takes time.)

Madawc Williams (East Anglia, UK)
Windows XP & Crystal 10

 

[jdemmi]

The possible values are strings (text). I am looking for the specific value "TEMP". I am using CR 8.5

I'd really like to stay away from the subreport option (kind of overkill for this case).

But if it is my only option....

-- Jason
"It's Just Ones and Zeros

 

[lbass]

Create two formulas:

//{@Yesno}:
if {table.field1} = "valueA" then "Yes" else "No"

//{@max}:
maximum({@Yesno},{table.groupfield})

Place {@max} in the page header. This will display correctly for whatever is the current group at the beginning of the page.

-LB

 

[jdemmi]

Thanks but that is not what I need.

Here's a little more detail.

1. Almost the entire report is in the page headr. (Don't ask)
2. There is 1 group, on TABLE.FIELD1.
3. Each record can (almost always does) have more than 1 set if data, more than 1 TABLE.FIELD1 value. (Multiple GROUP sections_
4. The possible values for TABLE.FIELD1 are text and can literally be anything.
5. The GROUP on TABLE.FIELD1 is sorted ascending.
6. The value I need to "trap" is E_TEMP (Group Header)
7. The Yes/No formula needs to be placed in the PAGE HEADER

Sorting won't help me as the value I am attemptingg to trap begins with "E" and will NOT ALWAYS be the min or max value. It may sometimes, but not always.

I attempted to use WHILEREADINGRECORDS because if you think about it that is exactly what I need. But it did not work.

Picture it this way:

Report executes
Starts populating data in the page header.
Begins reading the group data
GROUP 1 VALUE1 = ABC
GROUP 1 VALUE2 = CCC
GROUP 1 VALUE3 = E_TEMP
GROUP 1 VALUE4 = XYZ
GROUP 1 VALUE5 = ZZZ

Therefore the Yes/No should return YES because E_TEMP does exist.

It will return yes IF and ONLY if my record set contains E_TEMP as the LAST value, like this
GROUP 1 VALUE1 = ABC
GROUP 1 VALUE2 = CCC
GROUP 1 VALUE3 = E_TEMP


Any other ideas?

I inherited this report and did not want to butcher it too much but I may have to.

-- Jason
"It's Just Ones and Zeros

 

[lbass]

I'm not sure I'm following, but now it sounds like you want to test to see if any group#1 instance = "E-Temp". If this is true, then change {@Yesno} to:

if {table.field1} = "E-Temp" then "Yes" else "No"

Then place {@YesNo} in the detail section (where it should have been the first time around), and then change {@max} to:

maximum({@Yesno})

Place it in the page header.

If this is not what you mean, I think you need to provide a sample of data as it would appear in the detail section, with headers showing the group field and other fields. It would be less confusing if you used something other than generic labels, as well.

-LB

 

[jdemmi]

Holy Crap I think that got it. I KNEW it was possible and not the first time someone need to do this.

I will have to test thoroughly to make sure it is capturing the condition correclty EVERY TIME. But at first glance it looks good

THANKS!

I hope I can return the favor some day.

STAR FOR YOU.

-- Jason
"It's Just Ones and Zeros