Hello, Go to Reports/Labels & Letters/CSI Information Request LabelsThe second salutation line is not importing into CSI Information Request Labels.
I am thinking about customize this report and the procedure AP_CUST_SERVICE_LABELS_REP
AP_CUST_SERVICE_LABELS_REP is used by at least three reports....
Category Report ReportId Stored Procedure(s) Datawindow(s) WindowLabels and Letters Cust Service Opera News Labels ON_Reprint AP_CUST_SERVICE_LABELS_REP d_cust_service_labels w_cust_service_labelsLabels and Letters Customer Information Response Labels Labels AP_CUST_SERVICE_LABELS_REP d_cust_service_labels w_cust_service_labelsLabels and Letters Customer Notification Labels Notify_Label AP_CUST_SERVICE_LABELS_REP d_cust_service_labels w_cust_service_labelsLabels and Letters Customer Service Form Letters cust_issues AP_CUST_SERVICE_LETTERS_REP from T_FORMAT_INFO w_cust_service_rep
The problems are :
If I rename AP_CUST_SERVICE_LABELS_REP(nothing inside the procedure were changed) and use it as my new label datasource, it would not return the same result as it is in CSI infomation Request Labels and no updates at all.
Normal 0 false false false EN-US ZH-CN X-NONE MicrosoftInternetExplorer4
Besides, I can’t find anything about update CSI related tables in AP_CUST_SERVICE_LABELS_REP
In the original CSI infomation Request Labels, it updates records in the database. If I just use this procedure as my new label data source, I will get results..like Batch No Entry Type GI Act No Entry AmtI don't have a clue where those numbers come from..
The result I expect for is
"Select customer_no, activity_no, street1, street2, city, state, postal_code, esal1_desc, esal2_desc, lsal_desc, signor, activity_type, country, business_title"
Is there something behind the scene that I can't see.
Any suggestions..
Thank you very much in advance
Vicky
The simple answer here is that there is more going on behind the scenes in the application. These reports use a non standard reports window (which encapsulates the datawindow). The window has additional code that handles processing within the report, which explains why the result set of the stored procedure may not exactly match the result set (columns and or data output) of the report itself.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Vicky Wenhan Yu Sent: Friday, March 19, 2010 9:30 AM To: Ryan Creps Subject: Re: [Tessitura Technical Forum] About CSI Information Request Labels
Category Report ReportId Stored Procedure(s) Datawindow(s) Window Labels and Letters Cust Service Opera News Labels ON_Reprint AP_CUST_SERVICE_LABELS_REP d_cust_service_labels w_cust_service_labels Labels and Letters Customer Information Response Labels Labels AP_CUST_SERVICE_LABELS_REP d_cust_service_labels w_cust_service_labels Labels and Letters Customer Notification Labels Notify_Label AP_CUST_SERVICE_LABELS_REP d_cust_service_labels w_cust_service_labels Labels and Letters Customer Service Form Letters cust_issues AP_CUST_SERVICE_LETTERS_REP from T_FORMAT_INFO w_cust_service_rep If I just rename this procedure(nothing were changed in the procedure) and use it as my new label datasource, it would not return the same result as it is in CSI infomation Request Labels and no updates at all. In the original CSI infomation Request Labels, it would update records in the database. If I just use this procedure as my new lable data sourse, I would get some wired results..like Batch No Entry Type GI Act No Entry Amt I don't have a clue where those numbers come from.. Is there anything that I can't see from the scene..
From: Vicky Wenhan Yu <bounce-vickywenhanyu1681@tessituranetwork.com> Sent: 3/18/2010 4:05:36 PM
Hello, Go to Reports/Labels & Letters/CSI Information Request Labels The second salutation line is not importing into CSI Information Request Labels.
Is there a better way to add salutation2 to the label?
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!
Hello Ryan,
Thank you for your reply.
Is it possible for me to find more information about this report?
For example, those additional codes or how many tables were updated after running this report.
Thank you and have a nice weekend!
Besides some window formatting, the only additional process happening inside the application window is a closing Action is appended to any CSI returned in the report as long as the report is not run in a Reprint mode.
That would be an insert into T_ISSUE_ACTION.
Hope that helps.
-Ryan
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Vicky Wenhan Yu Sent: Friday, March 19, 2010 4:24 PM To: Ryan Creps Subject: Re: [Tessitura Technical Forum] RE: About CSI Information Request Labels
From: Ryan Creps <bounce-ryancreps9649@tessituranetwork.com> Sent: 3/19/2010 2:52:17 PM
Thank you very much for your help!