Parameter with multiple results - need an arra? 1

[knitwit]

Hi,
I am using crystal 9. I am generating a report with 3 groups 1 - county, 2- lb, 3 - lessee (all numeric values).
I would like to be able to limit the report in the following way.
If the lessee exists within the data, don't print any of the groups.
Example, lessee 1 could exist in county 1, lb 2, 3, and 4
and also in county 2, lb 5, 3 and 2. So don't print any pages with the about county and lb where this lessee exists (which could include other lessees too - don't print them either).

Would this be suppression issue or some sort of parameter with an array?

My data is in oracle 8i.
thanks
Melinda

 

[synapsevampire]

I don't understand, you state:

"If the lessee exists within the data, don't print any of the groups"

If you have lessee's, they are in a group, so I infer from the statement to not show any groups if there is data.

Please post example data and expected output.

-k

 

[knitwit]

Normal report would show
H1 - County 1
H2 - lb 1
H3 - Lessee 1
....
H3 - lessee 2
...
H3 - lessee 3
...
H2 - lb 2
H3 - Lessee 1
...
H3 - lessee 3
....

Not all lessees show up in every county and lb. If I am missing information from one of the lessees I would like to not print the lb or the lessee (any lessee within the lb)
So, if I want to select those lb's that do not contain lessee 2, then the above report would only print the lb 2
data and not the lb 1 data, because lessee 2 does not exist in lb2. One note, the lb #s can be in different counties, it is unique when combined as county and lb.
Does that help?

Does this help?

 

[synapsevampire]

Sort of understand, unfortunately you didn't provide data.

It sounds like you're saying that you want the count of lessees to equal the count of lb's, or eliminate them.

This sounds like a subreport or advanced SQL is in order, as you'll need to count all of the lessees for each lb for each county prior to deciding to display them.

A subreport might be used at the lb group header, linked by county and lessee, and it's purpose would be to return a true or false (boolean shared variable) based on whether the count of lb's where this lessee is found is equal to the number of lb's in the county.

Back in the main report suppress based on this.

-k

 

[knitwit]

No, I don't need a count...

Data like this:
Misty County
Parcel 2003
Lessee John Smith
Lessee John Jones
Lessee Kevin Smith
Parcel 2004
Lessee John Smith
Lessee John Jones
Marshy County
Parcel 1001
Lessee John Smith
Lessee Kevin Smith

I want to be able to suppress the Parcel and attached lessee list if John Jones exists in the list of that parcel
(any parcel in the report that this is true). So the above report would only show the parcel 1001 data.

 

[dgillz]

Do a John Jones test formula in the detail section.

If {Lessee}="John Jones" then 1 else 0

Subtotal this field by parcel. Then in your grpup selection formula, only choose those groups where the sum of your formula field is 0. This will eliminate the entire parcel group and detail records if John Jones exists in it.

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

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[knitwit]

Thanks - that will do exactly what I need. I was afraid I would have to do an array for this.
Melinda