Grouping problem

[Cort]

Hmm, need a bit of help here please:

I have 2 fields I want to base a group on. A payment Type field and a Payment Date field. I want to create the group based on the date of the final payment so when the payment type = "FP" then group on [payment date]

I cant use the record selection to select "FP" because I need all the other transactions to calculate values.

Thanks in advance.

 

[Cort]

Never mind. After discussion with my database guy it seems not all records have a final payment. My problem just became more complicated.

 

[Naith]

Not really 100% as to what's going on here; are you saying that you have PaymentDate as your main group, and PaymentType as a subgroup, and you only want to see the subgroup once PaymentDate equals the final payment date?

Or you want a dynamic subgroup?

You can conditionally suppress a group based on payment type's value, as I'm sure you're already aware. But if you want a dynamic subgroup, you can create a formula like:

//@Dynagroup
If PaymentType = 'FP' then PaymentDate
else OtherDate

and group on @Dynagroup.

Naith

 

[Cort]

Nope, never seen the dynamic groups. And that would be exactly what I needed if all my records had a final payment. Thank you for your information. I though it was impossible to group on a formula but now I know better.