Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Content Management (Extended ECM)
API, SDK, REST and Web Services
Wraping field data in a report
WYETH01User3_(Delete)_2702333
I am trying to modify the standard Livelink report that will list all available projects according to permissions but will also include some description information.select DTree.*, KUAF.name kuafname from DTree, KUAF where %1 and %2 and (KUAF.ID=DTree.UserID) order by DTree.Name%1 = Filter Project, %2 = Filter PermissionsBeing of Livereport format, I choose for the Dcomment field to be displayed under a title called "Description".However my problem is that this field displays in a column that does not wrap the text irrespective of the setting in the Livereport's "Columns Can Wrap" option.Any ideas?
Find more posts tagged with
Comments
Bhupinder_Singh
I once entered this as a bug:Bug Description (#1780083)Column Wrap for LiveReport format is not enforced on the additional display columns. The above bug is currently scheduled to be fixed for the next major release of Livelink (no date available yet).Two alternatives come to mind in the meantime: - Use the AutoLiveReport format. - Export the LiveReport results to a Microsoft Excel spreadsheet and use the formatting tools in Excel (see How do I export the results of a LiveReport to Microsoft Excel? at
https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=2673211&objAction=ArticleView
for more details).Sincerely,Bhupinder---------------------------------------------------------------------------Bhupinder Singh, B.Math., B.Ed.Open Text Customer SupportCustomer support e-mail: support@opentext.comCustomer Support Telephone: 800-540-7292----------------------------------------------------------------------------
Marsh_USA
It can be wrapped as:SELECT daudit.DName, COUNT(event) as TimesAccessed FROM DAudit, DTree WHERE daudit.DataId = dtree.DataId AND daudit.Event IN ('FETCH', 'VIEW') GROUP BY daudit.DataId, daudit.DNameMichael WuEngineerMarsh USA Inc.1133 Avenue of the AmericasNew York, NY 10036-2774Phone: (212) 948-3026Fax: (212) 948-3192Internet: Wenhua.Wu@marsh.com