I am building a report from a donation database that needs to include various benefit detail for each gift. I need to create a sentence from several multi-valued database fields that exist for the benefits. In the database, there could be multiple benefits for each gift-- each benefit would subsequently have its own quantity and value.
I need to get this into sentence format: Quantity1 + Benefit1 + Value1, Quantity2 + Benefit2 + Value2, etc.
Something like "2 Round(s) of Golf valued at $200.00, 2 Dinner(s) at Club valued at $100.00."
Each one of these fields could be multivalued, single valued, or null. Below is what the data fields look like in Crystal.
I need to get this into sentence format: Quantity1 + Benefit1 + Value1, Quantity2 + Benefit2 + Value2, etc.
Something like "2 Round(s) of Golf valued at $200.00, 2 Dinner(s) at Club valued at $100.00."
Each one of these fields could be multivalued, single valued, or null. Below is what the data fields look like in Crystal.