[Virginia Steger]

I’m working on a report, and I’m stumped. I need my report to show one row for each time a record meets the formula criteria. In some cases, the records meet the criteria 3 or 4 times, other cases its just one time. Right now, the report only shows one row total, for the first time that the record meets the formula criteria.

Is this a linking issue? My report is based on a normalized Access table, so the linking is behind the scenes (not in Crystal). Any thoughts?

Thanks,
-Virginia

[DrewAllen]

This sounds like the same issue as in the thread How to show multiple fees, etc. per record

Drew

[Virginia Steger]

Drew,

I changed the join type to "look up all combinations" but it did not work for me. I think it probably has something to do with my formula and the hierarchy that the report looks at the criteria. I'm using an If...Then...Else statement to bring many attributes into one common field. Its long...

Quote:

If {@GIALCount} = 1
then "GIAL"
else
if {@JAARSCount} = 1
then "JAARS"
else
if {@OtherCount} = 1
then "Other 501c3"
else
if {@SILCount} = 1
then "SIL"
else
if {@TSCCount} = 1
then "TSC"
else
if {@WACount} = 1
then "WA"
else
if {@WUSADesCount} = 1
then "WUSA Designated"
else
if {@WUSAUndesCount} = 1
then "WUSA Undesignated"
else
if {@FormulaCount} = 1
then "Formula"
else
if {@UnknownCount} = 1
then "Unknown"
else ""

Then, I'm using that formula field as my group. In some cases, one gift can be in two or three different groups, and I want the report to show it in all the groups that it is in. Because of my formula, I understand that once it meets the first criteria, if it meets any other criteria as well, the report will not show it. How do I fix this so that the gifts show up in all the groups that they fit in?

Any suggestions?
-Virginia

[DrewAllen]

What are the formulas for your various "counts"?

Drew

[Virginia Steger]

Each one is its own attribute:

Quote:

If {GfAttrCat_5.GfAttrCat_5_Import_ID}<>""
then 1
else 0

[DrewAllen]

So your rowset looks something like
Record1,GIAL,JARS,Other501c3,SILS,....

If that is the case, then you can't do it using groups. You'll have to use some other approach. Each rowset can only appear in one group. In order for it to work the way that you want, you'd have to have each of these being pulled from one attribute category with different attribute descriptions for each of the groups like
Record1,GIAL
Record1,JARS
Record1,Other501c3
Record1,SILS
...

Depending on what exactly you are trying to accomplish, you may be able to use formulas to get the results that you want.

Drew