Variable from other databand does not run in subreport

[phuongtn2010]

Hi,
I have a problem with parameter.
- I have a Databand1.category(cat_id, cat_name)
- In databand I insert a subreport: I insert databand2 in subreport with query command. In this query I insert a variable(is cat_id of databand1)

--> But it just fill the first value of databand1, it does not run other records

This is my query:
select t.ten_tm , t.ma_tm, l.CHUTHICH
from tentm t, loaitm l where t.MA_TM in (select regexp_substr(l.CHUTHICH, '[^, ]+', 1, level)from dual
CONNECT by regexp_substr(l.CHUTHICH, '[^, ]+', 1, level) is not null)

and l.id = {loaitm.ID} (problem in this line)


thanks

[HighAley]

Hello.

The sub-report is rendered an a new page. The variables from the main report are not available.
Please, try to use the Sub-report Parameters.

Or you could use Panels instead of the sub-reports.

Thank you.

[phuongtn2010]

Thank you, I solved it

[HighAley]

Hello.

We are always glad to help you.
Let us know if you need our help.

Thank you.