Hi
I have a report with multiple tabs.
Each tab has three charts/tables inline (one table and two charts). Each of these are linked to the same single report, output of which is embeded into the tab with an embed_object tag.
This is repeated in the next tab. The same linked report is accessed but the embed_object name is different.
When I load the report and go to any tab and call the linked report everything is fine. If I then go to the other tab and selec the linked report the data arrives correctly but the column filters are missing. It does not matter which order I try, the first selected tab is always ok the second selected tab is always a problem.
I have tried making the linked report different (two different reports) but the I have the same error.
Summary of code is as follows
Main report:
BEGIN
.......
select 'dbr.tab','On plan and behind translation plans';
select 'dbr.tab','Setup / On Hold plans and All translation plans';
select 'dbr.report','sp_DBR_situ_test_3','wibble','inLanguage="NULL"','inPast=0','inCurFut=0','inRange="AllActive"';
select 'dbr.list','hlist';
select...........report code
select 'dbr.report','sp_DBR_situ_test_3','wibble','inLanguage=3','inPast=0','inCurFut="1"','inRange="InProgress"','inDocNum="Ignore"';
select...........report code
select 'dbr.report','sp_DBR_situ_test_3','wibble','inLanguage=3','inPast="1"','inCurFut=0','inRange="InProgress"','inDocNum="Ignore"';
select...........report code
select 'dbr.embed_object','wibble';
/*---------------------------*/
select 'dbr.tab.next';
select 'dbr.report','sp_DBR_situ_test_3','wibble1','inLanguage="NULL"','inPast=0','inCurFut=0','inRange="AllActive"';
select 'dbr.list','hlist';
select...........report code
select 'dbr.report','sp_DBR_situ_test_3','wibble1','inLanguage=3','inPast=0','inCurFut=0','inRange="AllActive"','inDocNum="Ignore"';
select...........report code
select 'dbr.report','sp_DBR_situ_test_3','wibble1','inLanguage=3','inPast=0','inCurFut=0','inRange="AllHoldSetup"','inDocNum="Ignore"';
select...........report code
select 'dbr.embed_object','wibble1';
select 'dbr.tab.close';
END
Linked report:
BEGIN
select 'dbr.keepwithnext';
select 'dbr.chart','Pie', 'Global Workflow View';
select (select ctm.workflow_name from sipo_db.cm_translation_state_names ctm where ctm.id=coalesce(cto.translation_state,'1')), count(*) from sipo_db.cm_translation_objects cto JOIN sipo_db.cm_workflows as cmw on cmw.trans_obj_id=coalesce(cto.translation_id,cto.id) and cmw.workflow_id=6 where (cto.translation_state<>6 or cto.translation_state is null) group by cto.translation_state;
select 'dbr.chart','Pie', 'Workflow Summary View in Selection';
select (select ctm.workflow_name from sipo_db.cm_translation_state_names ctm where ctm.id=coalesce(cto.translation_state,'1')),
count(*)
from sipo_db.cm_translation_objects cto
JOIN sipo_db.cm_workflows as cw on cw.trans_obj_id=coalesce(cto.translation_id,cto.id) and cw.workflow_id=6
where
case inRange
when 'AllActive' then (cto.translation_state<6 or cto.translation_state is null)
when 'AllHoldSetup' then (cto.translation_state>6 or cto.translation_state is null)
when 'InProgress' then (cto.translation_state<6)
end
and
case inDocNum
when 'Ignore' then (cto.language=inLanguage and if(inPast=1,cw.estimated_date>cw.baseline_date,1=1) and if(inCurFut=1,cw.estimated_date<=cw.baseline_date,1=1))
else ((cto.translation_state<6 or cto.translation_state is null) and cto.doc_number like(concat('%',inDocNum,'%')))
end
group by cto.translation_state;
select 'dbr.title','Details'; select 'dbr.column.filter','DocNum','text'; select 'dbr.column.filter','ModNum','text'; select 'dbr.column.filter','POwner','text'; select 'dbr.column.filter','BU','select'; select 'dbr.column.filter','MajorBrand','select'; select 'dbr.column.filter','MinorBrand','select'; select 'dbr.column.filter','MinorBrand','select'; select 'dbr.column.filter','DocSType','select'; select 'dbr.column.filter','Tstate','select';
select 'dbr.colstyle','ModNum','%d'; select 'dbr.search',1; select 'dbr.pager',100;
select (select tm.taxvaldesc from sipo_db.tm_m_ibm_taxdtls tm where tm.id=cto.language) as 'Language',
csn.workflow_name as 'Transalation State[Tstate]',
cto.doc_number as 'Doc Number[DocNum]',
dv.mod_number as 'Module Number[ModNum]',
dv.owner_name as 'Project Owner[POwner]',
(select tm.taxvaldesc from sipo_db.tm_m_ibm_taxdtls tm where tm.id=dv.business_unit) as 'Business Unit[BU]',
(select tm.taxvaldesc from sipo_db.tm_m_ibm_taxdtls tm where tm.id=dv.major_brand) as 'Major Brand[MajorBrand]',
(select tm.taxvaldesc from sipo_db.tm_m_ibm_taxdtls tm where tm.id=dv.minor_brand) as 'Minor Brand[MinorBrand]',
(select tm.taxvaldesc from sipo_db.tm_m_ibm_taxdtls tm where tm.id=dp.document_sid) as 'Document Type[DocSType]',
cw.baseline_date as 'Planned Complete Date',
cw.estimated_date as 'Estimated Complete Date'
from sipo_db.cm_translation_objects cto
LEFT JOIN sipo_db.frf_documents as fd on fd.documentid=cto.doc_number and fd.status=9
LEFT JOIN sipo_db.dnrf_prefixes as dp on dp.id=fd.dnrf_id
LEFT JOIN sipo_db.dnrf_values as dv on dv.id=dp.dnrf_value_id
JOIN sipo_db.cm_workflows as cw on cw.trans_obj_id=coalesce(cto.translation_id,cto.id) and cw.workflow_id=6
JOIN sipo_db.cm_translation_state_names as csn on csn.id=coalesce(cto.translation_state,'1')
where
case inRange
when 'AllActive' then (cto.translation_state<6 or cto.translation_state is null)
when 'AllHoldSetup' then (cto.translation_state>6 or cto.translation_state is null)
when 'InProgress' then (cto.translation_state<6)
end
and
case inDocNum
when 'Ignore' then (cto.language=inLanguage and if(inPast=1,cw.estimated_date>cw.baseline_date,1=1) and if(inCurFut=1,cw.estimated_date<=cw.baseline_date,1=1))
else ((cto.translation_state<6 or cto.translation_state is null) and cto.doc_number like(concat('%',inDocNum,'%')))
end;
END
