Web Reports and liveReport multivalued attributes

[ocovault]

Hi all,

Could anyone provide me a link or a guideline to understand how to build web reports like for newbies and then provide some information in order to create a livereport (or webreport) to bring mutivalued attributes values.

Any help would be appreciated.

Regards,

Orlando Covault

 

[appnair]

Both have classes that you can take,but in a nut shell this is what I can tell you about it.

A live Report is a livelink object that knows how to query the livelink database. If you sign a NDA with OT you will get a free schema guide that shows you the relations.It is not proper for me to give too much about livelink schema,but as almost everybody in the livelink forum know dtree is a important table and you could write select * from dtree where subtype=144 and put that in a LR object and it will show you the results.Look at the canned livereports available and that is how you start doing it. The livelink database is NOT TO BE MANIPULATED DIRECTLY BY SQL. The only way perhaps if you do not have programming resources to change things en masse in livelink is by buying WebReports. OT producse LAPI,webservices and oscript to do manipulation by customers.

A webreport amongst MANY MANY OTHER THINGS IN ITS ANVIL has a extremely huge tag library that users with sql prowess can use to change things as well.A webreport actually can call a Livereport and using javascript logic and tag library logic that resonate has produced you can acheive certain things with it.For e.g you may want to show clickable things,send email,output a excel file etc etc that is not possible with livereports. WR's can almost have anything as its source,it is very versatile in that aspect.

The best thing for you to do is basically work with the module and read its documentation or take training.
I am of the opinion that very complex things you should not try to do with webreports. What may take you a few lines of code may look like crazy code when you look at webreports.Given a choice and the customet allowed me to program in lapi,socript or websvcs I may take that route if it was a very complex requiremnt.But for actual report generation in livelink and other databases WR has no equal.

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

 

[ocovault]

Hi James,

What did you mean by NDA?

Web Reports is a module that I should install? It has additional cost? Or what you mention is that a can give the reports requirement to OT and they implemented for me so I can buy them?

Is there any official training for this? can you provide me a link to it? We are planning the training for next year and this could be helpful.

Regards,
Orlando Covault

 

[appnair]

N D A means Non Disclosure Agreement.
Yes all of this has training @OT
WR is not free. It is a licensed module form resonatekt dot com

CANNED REPORTS means that when you install livelink for the first time OT puts a library of live reports.It is accessed from your personal menu
You can look at the SQL on those and start doing similar stuff.Some versions of livelink do not install that I am not sure which.

You should get plenty of example live reports,queries etc if you peruse the LiveReports discussion on the OT knowledge website
knowledge dot opentext dot com

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

 

[ocovault]

Hi,

I already open a discussion in knowledge about getting multivalued attributes in a report and so far they are giving me examples with a combination of web and live reports. But I was hoping that I could get a much detailed example.

Regards,

Orlando Covault

 

[appnair]

if you cannot understand the core tables that make up the info it could be difficult.try small with a small subset and progress

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair