Subreport Problem

[nikol]

I have just installed CRXI & using there new feature Dynamic Prompt. I have created LOVs for few reports . It was working fine. But Now I have to create a single report
from all the reports. I linked all the subreports with parameter column.Its working but taking lots of time. almost a min. Any help to upgrade the report's performance.
Thanks

 

[kskid]

For the most part, reports with subreports are always slow.

-LW

 

[nikol]

Ok, I came to know.
Do u have any idea.I have created a D.Prompt(Cluster)
& in SELECT EXPERT I did {table.field}={Parameter.name cluster}

select a.uid,a.name,
case
WHEN
(a.name='EMP1 '
or
a.name='EMP2' OR a.name='EMP3')
THEN 'Caregiver Services'
WHEN
(a.name='SAL1' OR a.name='SAL2' Or a.name='SAL3') THEN 'Long Term Care Services'

When I select 'CareGiver services' for a single report it working. BUT when I used this D.Prompt in subreport Its giving DETAILS for 3 times(I need only 1).Do u have any idea.Why this happening?