SUM in a report using a Swap Select Attribute

rbross

Hello,

I have a form for entering report parameters and one of the attributes uses a swap select.
the SUM looks like this:

<<SUM DonationSplitDetail.DonationAmt WHERE(DonationSplitDetail.OB_DonationDetail.PS_Contact.ID=ThisBenefactor.PS_Contact.ID AND DonationSplitDetail.OB_DonationDetail.PS_Contact.PM_Relationship=Virtual_Financial_Rpt_Parms.PS_Relationship AND (DonationSplitDetail.PS_Program IN Virtual_Financial_Rpt_Parms.PS_Program OR Virtual_Financial_Rpt_Parms.PS_Program IS UNDEFINED) AND YEAR(DonationSplitDetail.OB_DonationDetail.OB_DonationHdr.DateBatch)=YEAR(Virtual_Financial_Rpt_Parms.DateFrom) AND Month(DonationSplitDetail.OB_DonationDetail.OB_DonationHdr.DateBatch)=6)>>

The green part of the query used to just use = I changed it to IN, but now the Sumed attribute on the report shows nothing?

I am trying to allow the user to select multiple 'Programs' for a given Relationship.
For example, in this report, they select a relationship called TEACH Sponsor. the Programs that go along with that are Teach Committed and Teach Uncommitted.

When the Query just uses: (DonationSplitDetail.PS_Program=Virtual_Financial_Rpt_Parms.PS_Program OR Virtual_Financial_Rpt_Parms.PS_Program IS UNDEFINED) it works fine with no program selected or 1 program selected but changing the = to IN does not work.
Does anyone know if this can be done???

Thanks

customaware

I dont think you can navigate an IN down multiple levels of Peer Single.

As they are all ps just create a SHortcut to test.

rbross

The attribute was a peer single but I changed it to Allow Multiple and changed the control on the form to a Swap Select. I just haven't renamed the attribute yet. Wanted to see if this would work first.

rbross

Using the following syntax works but still does not include the Uncommitted values. Just SUMs the Committed Values:
DonationSplitDetail.PS_Program.ID CONTAINS Virtual_Financial_Rpt_Parms.PS_Program.ID

its like it is only recognizing the first value that is selected in the Virtual_financial_parms.PS_Program

Keep in mind even though I am using the PS prefix this attribute allows multiple selections.

customaware

You can only use a CONTAINS on a Reference.

As you have it... it should be...

DonationSplitDetail.PS_Program.ID = Virtual_Financial_Rpt_Parms.PS_Program.ID

rbross

eagles9999 wrote
You can only use a CONTAINS on a Reference.

As you have it... it should be...

DonationSplitDetail.PS_Program.ID = Virtual_Financial_Rpt_Parms.PS_Program.ID

What if I switched the syntax to read like this:

Virtual_Financial_Rpt_Parms.PS_Program.ID CONTAINS DonationSplitDetail.PS_Program.ID

The reference, in this case, is the virtual field PS_Program which has a reference to Program.

customaware

I don't understand why you are wanting to use a CONTAINS to compare two Attributes Roger

PointsWell

rbross wrote
Virtual_Financial_Rpt_Parms.PS_Program.ID CONTAINS DonationSplitDetail.PS_Program.ID

This example is invalid as you are comparing and ID with an ID which can either be =, !=, > or < etc

It should be

Virtual_Financial_Rpt_Parms.PS_Program CONTAINS DonationSplitDetail.PS_Program

if you have changed the ps_Program to be a pm.