Normal 0 false false false EN-US X-NONE X-NONE
Greeting all!
I am a brand new for Tessitura. I am working on the reports that have two parameters. On SSRS, the report looks fine, but after I deployed the report and tried to run it on Tessitura Test Environment, I don’t see anything except the headers. Even I was trying to test the parameters by using the expression in to a text box and to see how it looks on Tessitura, and one of the parameters looks fine except it shows with double quotation, and the other parameter shows just the id not the string.
What I supposed to see for @MembLevel_str parameter was B2, but it shown as “B2” and for @NRR_str it supposed to be shown as RN, but shown as 2
Can any of you please help me on this how to tackle this problem?
I am using Tessitura Version 12.5, MSSS2012 and my report configured and pointed to the right Target Report Folder, Query type is from stored procedure
Thanks,
Wossen
ALTER PROCEDURE [dbo].[LRP_MEMBERSHIP_RENEW_REACTIVATION]
(
@MembLevel_str VARCHAR(MAX) = NULL,
@NRR_str VARCHAR(MAX) = NULL
)
AS
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SET NOCOUNT ON;
--Create and populate a temp table to hold the NRR Status
CREATE TABLE #nrr (
id int not null,
nrr varchar(2) null
INSERT INTO #nrr
SELECT ElementID, CONVERT(VARCHAR(2),Element) FROM dbo.FT_SPLIT_LIST (@NRR_str,',')
--Create and populate a temp table to hold the Membership Level
CREATE TABLE #MembLevel (
MembLevel_str varchar(3) null
INSERT INTO #MembLevel
SELECT ElementID, CONVERT(VARCHAR(3),Element) FROM dbo.FT_SPLIT_LIST(@MembLevel_str,',')
--Create a table to hold the final results for this report
CREATE TABLE #results (
customer_no INT NULL,
NRR_str VARCHAR(2) NULL,
MembLevel_str VARCHAR(3) NULL,
expr_dt DATETIME NULL,
init_dt DATETIME NULL,
current_status INT)
--First insert the membership info into the results table
INSERT INTO #results
SELECT customer_no = a.customer_no,
NRR_str = a.NRR_status,
MembLevel_str = a.memb_level,
expr_dt = a.expr_dt,
init_dt = a.init_dt,
current_status = a.current_status
FROM dbo.TX_CUST_MEMBERSHIP a (NOLOCK)
JOIN #nrr AS g ON a.NRR_status = g.nrr
LEFT JOIN TR_GOOESOFT_DROPDOWN AS TG (NOLOCK) ON a.NRR_status = TG.description
JOIN #MembLevel AS m ON a.memb_level = m.MembLevel_str
LEFT JOIN T_MEMB_LEVEL AS TM (NOLOCK) ON a.memb_level = TM.memb_level and a.memb_org_no = TM.memb_org_no
WHERE (TG.code = 31)