Livereprot with Reportformat "LiveReport"

I have a problem with a report.As "Report Format" I used "Livreport" because I wanted to have the outpout (some projects) clickable.As Parameter I set the %1 to "Reportfields".My LR should print:- the Path ( a function LLPath, we have written)- and the name of the Coordinators of the projectsselect %1, dTree.Name, LL_Path(dTree.DataID), KUAF.NameFROM KUAF, DTree, KUAFChildren WHERE (KUAF.ID = KUAFChildren.ChildID AND KUAFChildren.ID = DTree.DataID + 1 AND dTree.SUBTYPE = 202AND dataId in (select DataID from DTree where subtype = 202 and DataID in (select DataID from DTree start with DataID = '20097' connect by prior DataID = ParentID))) ORDER BY KUAF.NameUnder Display Columns I wrote as Field/Columntitle:dTree.Name / ProjectnameLLPath(dTree.DataID) / PathKUAF.Name / Username or groupUnfortunately it didn't work and columns "Projectname" and 'Username or group say:"An unknown feature was specified" and also the projectname in the 2nd column is not correct but show the groupname instead of the projectnameI'm not sure, how it works correctly. Can anyone can give me some hints, what I'm doing wrong or has a good description?Many thanks in advanceIsa

Find more posts tagged with

Comments

adarsh_lobo_(adarsh.lobo@shell.com_(Delete)_112626

Message from <Adarsh.Lobo@shell.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Isa,

I have a LiveReport with following details for finding coodinator logins for a specfic Project.

SQL:

select d.*, k2.name "Coordinator Login", ll_path(d.dataid) "Path" from kuafchildren child, kuaf k1, kuaf k2, dtreeacl, dtree d where d.dataid=dtreeacl.dataid and k1.name='Coordinators' and dtreeacl.rightid=k1.id and k2.id=child.childid and k1.id=child.id and d.subtype=202 and d.dataid=6088073

Report Format:

LiveReport

Display Coulmns:

Field Column Title

Coordinator Login Coordinator Login

Path Path

I get the display as:

Project (Clickable) Coordinator Login Path.

The above given query can be modified to get the coordinator logins of projects in a specific workspace as follows:

Not sure if it helps you. If it does then you should be happy!!

Thanks,

Adarsh

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, September 24, 2008 9:36 PM
To: eLink Recipient
Subject: Livereprot with Reportformat "LiveReport"

Livereprot with Reportformat "LiveReport" Posted by tsystemsuser2 (Hedemann, Isa) on 09/24/2008 12:04 PM

I have a problem with a report.

As "Report Format" I used "Livreport" because I wanted to have the outpout (some projects) clickable.

As Parameter I set the %1 to "Reportfields".

My LR should print:
- the Path ( a function LLPath, we have written)
- and the name of the Coordinators of the projects

select %1, dTree.Name, LL_Path(dTree.DataID), KUAF.Name
FROM KUAF, DTree, KUAFChildren
WHERE
@ @ (KUAF.ID = KUAFChildren.ChildID AND KUAFChildren.ID = DTree.DataID + 1 AND dTree.SUBTYPE = 202
AND dataId in
(select DataID from DTree
where subtype = 202 and
DataID in (select DataID
from DTree
start with DataID = '20097'
connect by prior DataID = ParentID))
)
ORDER BY KUAF.Name

Under Display Columns I wrote as Field/Columntitle:
dTree.Name / Projectname
LLPath(dTree.DataID) / Path
KUAF.Name / Username or group

Unfortunately it didn't work and columns "Projectname" and 'Username or group say:"An unknown feature was specified" and also the projectname in the 2nd column is not correct but show the groupname instead of the projectname
I'm not sure, how it works correctly. Can anyone can give me some hints, what I'm doing wrong or has a good description?

Many thanks in advance
Isa