Home
Designing Analytics Reports
Main-Subreport-Join with filter-conditions
Mario1710
Hello!
I have to transfer a crystal report to birt.
Between the mainreport and the subreport of the crystal-report there the following conditions:
if {?Pm-FUNDS.FUNDSTRUCTTYPE} <> 4 then
{FUNDS.FUND} like left({?Pm-FUNDS.FUND},7) & '*' and
{GLHOLKEYS.ACCIK} in [1]
else
{FUNDS.FUND} = {?Pm-FUNDS.FUND} and
{GLHOLKEYS.ACCIK} in [2]
and
IF {funds.fundstructtype} = 2 THEN
{glaccrepfc7.glaccrepfc7} <> 'BR_HN_FONDSZE'
AND {glaccrepfc7.glaccrepfc7} <> 'BR_HB_FONDSZE'
ELSE
TRUE;
Description:
{?Pm-FUNDS.FUNDSTRUCTTYPE} and {?Pm-FUNDS.FUND} are the joins between main- and subreport.
I have build the mainreport and the subreport and joined them. But now i need the conditions to filter the datasets in the subreport.
How can i transfer these conditions to birt?
Thanks!
Mario
Find more posts tagged with
Comments
There are no comments yet