Show All [Type] Items , Live report

Abdul RK

Hello Developers,

I have recevided SQL source from this Live report for viewing of "Documents" via Live Reports which are on xECM.

select DTree.*, KUAF.Name kuafname from DTree, KUAF where (DTree.SubType=144) and (1=1) and (KUAF.ID=DTree.UserID) order by DTree.Name

Now using custom live report I am getting correct values, So I wanted to export them in excel so i am using webreport and datasource is this live report SQL query.

When Webreport is downloaded it shows numeric values. So where I could be wrong.

Help will be highly appreciated  

Appu Nair

The OT LiveReport has many filters that allow it to do changes to what you see so if in your report you go to a section that shows autolivereport etc many of these can be changed on top of it the webreport has tags that allow it to show other manipulations so if you conceptually tellthe forum what is that you are seeking as output in WR it will help.

Assuming your report has DataID returned if you type thi in the ROW section of your WR you will starts eeing

[LL_REPTAG=DataID /] [LL_REPTAG=DataID NODEINFO:NAME /]

this is akin to you getting just the DataID from your SQL and then using WR tags to get most of the other columns.

Livelink schema defines its columns numericallly and it has its reasons for doing so :)

your SQL produces 49+1 column from Kuaf so we do not know how your WR is done, if you are a beginner then old WR gives tags like

[LL_REPTAG_1 /] upto [LL_REPTAG_5 /] so upto OriginOwnerID so only Name is string in that

the reason why old WR does that is to show developers alternate ways o reporting if you know your column name then you dont need that but can go like what I showed

[LL_REPTAG=DataID /] show me the rowvalue in that key like that

I have attached a playing reportview thinking you are a starter, so go ahead and make a copy of your LR and WR and in the copy attach the version of WR I attach(you go to functionmenu and addreportview version) see if produces

Appu.txt

wanted output and start editing that so you can acheive what you want

my LR is select * from DTree with Autolivereport