I would like to run an output set that generates the donation level for each constituent. I added on the TR_QUERY_ELEMENT table the information but I'm just getting the donation level id which doesn't help at all for my purposes. What I want to have is the description not the Id. Does any one knows whatam missing on the table?
Thank in advance!!
Sandra,
Try setting up tr_query_element with the following values:
Data Select = !.pgm_desc
Data From = (select a.*, pgm_desc = b.description from vxs_cust_program a JOIN tr_donation_level b ON a.donation_level = b.id)
If you have multiple Program types, you might also consider setting up a parameter.Dale