Adding Appeal column in Contribution Report

Maybe someday we can just select the fields we want to include in reports rather than having to write SQL scripts!  I will be waiting for someone’s successful reply.  Thank you for including the script in your email.

Laura Chaney

From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Eric Lazaro
Sent: Tuesday, May 26, 2015 3:02 PM
To: Laura Chaney
Subject: [Tessitura Development Forum] Adding Appeal column in Contribution Report

Hi Everyone,

Our development team is looking to include the Appeal column on their report. I tried to modify the TR_Query_Element with a query of

(select a.*,appeal_desc = b.description,camp_desc = c.description from T_APPEAL a JOIN VS_APPEAL b ON a.appeal_no = b.appeal_no JOIN t_campaign c ON a.campaign_no = c.campaign_no)

It works when I run it in MS Studio but it does not work when Execute an Output Set.

Is there anyone including  the Appeal on their report with Output Set??

Thanks

Eric Lazaro

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Maybe someday we can just select the fields we want to include in reports rather than having to write SQL scripts!  I will be waiting for someone’s successful reply.  Thank you for including the script in your email.

Laura Chaney

From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Eric Lazaro
Sent: Tuesday, May 26, 2015 3:02 PM
To: Laura Chaney
Subject: [Tessitura Development Forum] Adding Appeal column in Contribution Report

Hi Everyone,

Our development team is looking to include the Appeal column on their report. I tried to modify the TR_Query_Element with a query of

(select a.*,appeal_desc = b.description,camp_desc = c.description from T_APPEAL a JOIN VS_APPEAL b ON a.appeal_no = b.appeal_no JOIN t_campaign c ON a.campaign_no = c.campaign_no)

It works when I run it in MS Studio but it does not work when Execute an Output Set.

Is there anyone including  the Appeal on their report with Output Set??

Thanks

Eric Lazaro

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!